1 / 13

Label the Spreadsheet

Label the Spreadsheet. 2. Function. 3. 1. Cell Address. Column B. 4. Label. 5. Value. 6. Active Cell B7. Spreadsheet Questions. A function and formula start with equals. The first row in a spreadsheet is A. The range A5:A10 consists of 2 cells.

nora-odom
Download Presentation

Label the Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Label the Spreadsheet 2 Function 3 1 Cell Address Column B 4 Label 5 Value 6 Active Cell B7

  2. Spreadsheet Questions • A function and formula start with equals. • The first row in a spreadsheet is A. • The range A5:A10 consists of 2 cells. • Functions use operators like + and /. • Spreadsheets allow us to predict outcomes. • Graphs are used to represent data visually. True False False False True True

  3. FunctionsReview Day 2

  4. What are functions? shortcut A function is a __________ to the most common mathematical calculation which also begins with ______________. equals (=)

  5. 3 Parts of a Spreadsheet Function equals (=) Start with ___________ ____________ Name __________ of Cells Function Range

  6. Identifying Parts of a Spreadsheet Function Last Cell 1st Cell 5 4 =MIN(B2:B5) Equal sign 3 Range 1 2 Function Name

  7. Which Function? AVERAGE MAX • Mean ________________ • Highest ________________ • Total ________________ • Smallest ________________ SUM MIN

  8. What function is typed in cell B8 to get $535.00? What math operation are we using? Minimum What do we start a function with? =

  9. What function is typed in cell B8 to get $535.00? Are we working down or across? Down What function name is used? MIN

  10. What function is typed in cell B8 to get $535.00? Remember you have to use (parenthesis) for the range What is the first cell being used? B2

  11. What function is typed in cell B8 to get $535.00? Remember you have to use colon (:) to include in betweens What is the last cell being used? B5

  12. What function is typed in cell B8 to get $535.00? When function is complete PRESS Enter and the result/answer will appear in the cell.

  13. What function is typed in cell B8 to get $535.00? =MIN(B2:B5) function The result of the function

More Related