130 likes | 209 Views
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.
E N D
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. • Functions use operators like + and /. • Spreadsheets allow us to predict outcomes. • Graphs are used to represent data visually. True False False False True True
What are functions? shortcut A function is a __________ to the most common mathematical calculation which also begins with ______________. equals (=)
3 Parts of a Spreadsheet Function equals (=) Start with ___________ ____________ Name __________ of Cells Function Range
Identifying Parts of a Spreadsheet Function Last Cell 1st Cell 5 4 =MIN(B2:B5) Equal sign 3 Range 1 2 Function Name
Which Function? AVERAGE MAX • Mean ________________ • Highest ________________ • Total ________________ • Smallest ________________ SUM MIN
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? =
What function is typed in cell B8 to get $535.00? Are we working down or across? Down What function name is used? MIN
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
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
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.
What function is typed in cell B8 to get $535.00? =MIN(B2:B5) function The result of the function