Basic Spreadsheets Check Point

What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?

• +

• =

• /

• *

Which function tells you the maximum value in a range?

• Max

• =Maximum

• MaximumValue

• =MAX

Which function tells you the minimum value in a range?

• =MIN

• MIN

• =MINIMUM

• MINIMUM

Choose two methods in which you can add values together in a spreadsheet. (Make sure that you choose 2!!)

• A1+B1

• =SUM(_:_)

• =A1+B1

• =1A+1B

Give the cell references for the following range:

The first ten cells of column B

• =B1+B10

• =B1:B10

• =1B:10B

• B1:B10

Give the cell references for the following range:

The cells in rows 15-20 in column A

• =A15:A20

• A15 - A20

• =15A-20A

• =15A:20A