Spreadsheets Y8 L5 starter

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

• =

• /

• *

• +

Name a function that tells you the:

Maximum value 

• MIN

• MAX

• SUM

• DIV

Name a function that tells you the:

Minimum value

• MIN

• MAX

• SUM

• COUNT

Name a function that tells you the:

Number of non-blank cells 

• COUNTA

• MIN

• AVG

• DIV

Show two ways you can add values together in a spreadsheet

• Formula with plus

         = +

• SUM Function

• ADD Function

Give the cell references for each of the following ranges:

The first ten cells of column B

• B1:B10

• 1B:10B

• B1-B10

Give the cell references for each of the following ranges:

The cells in rows 15–20 in column A

• A15:A20

• 15A:20A

• A15-A20

Give the cell references for each of the following ranges:

The cells in rows 15-20 in column A, B and C

• A15:C20

• A15-C20

• 15C:20A

Give the cell references for each of the following ranges:

All of the cells of column A from row 2 to the end

• A2:A

• A2:END

• A2:ALL