Spreadsheet Pre-test

What do all formulas begin with?

• %
• [ ]
• =
• :

What symbol do we use for multiplication in a Spreadsheet program? 

• /
• =
• ^
• *

What symbol do we use for division in a Spreadsheet program? 

• /
• *
• +
• =

What is the cell reference of the yellow cell?

• B7

• 7B

• 8B

• B8

What two operations does the AVERAGE function perform?

• Addition and Multiplication

• Multiplication and Division

• Addition and Subtraction

• Addition and Division

What is the purpose of the MIN function

• Add the numerical values in a range of cells

• Find the lowest number in a range of cells

• Find the highest number in the range of cells

• Finds the average from a range of cells

What is the purpose of the COUNT function?

• Adds the values of a range of cells

• Counts how many cells in a range contain anything

• Counts how many cells in a range contain numbers

• Counts how many cells have been selected

What is the purpose of the MAX function

• Add the numerical values in a range of cells

• Find the lowest number in a range of cells

• Find the highest number in the range of cells

• Finds the average from a range of cells

What function should be entered to calculate the total budget?

• =AVERAGE(B3:B6)
• =SUM(B3:B6)
• =SUM(B3-B6)
• =TOTAL(B3:B6)

Which of the following is an example of a range?

• D3

• D3 and D5

• D3:D18

• Sum