Spreadsheet Formulas, Functions & Cell References

Which symbol is used to multiply 2 cells together?

Which symbol is used to add 2 cells together?

Which symbol is used to indicate to the spreadsheet that you are about to use a formula or function?

Which symbol is used to divide one cell by another?

Which symbol is used to subtract one cell from another?

Which function would you use to add up more than 2 cells?

• SUM

• MIN

• MAX

• AVERAGE

Which function would you use to find the highest number in a range of cells?

• AVERAGE

• SUM

• MIN

• MAX

Which function would you use to find the average value in a given cell range?

• SUM

• MIN

• AVERAGE

• MAX

Which function would you use to find the lowest number in a cell range?

• SUM

• MIN

• MAX

• AVERAGE

If you wanted to use an absolute cell reference to freeze the reference to cell A2 in the following formula: =A1*A2 so that it does not change when it is copied, what would you type in?

• =A1*A$2

• =A1*$A$2

• =A1*$A2

• =$A1$1*A2