ICT HK Excel Quis for Week 3

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

• =

• MAX

• MIN

• COUNTA

Name a function that tells you the maximum value?

• =

• MAX

• MIN

• COUNTA

Name a function that tells you the minimum value?

• =

• MAX

• MIN

• COUNTA

Name a function that tells you the number of non-blank cells?

• =

• MAX

• MIN

• COUNTA

Show two ways in which you can add values together in a spreadsheet. You are adding values in cells A2, A3 and A4.

• =sum(A2:A4)

• =(A2+A3+A4)

• sum(A2:A4)

• =add(A2:A4)

Give the cell references for the first ten cells of column B.

• B1-10

• B1:10

• B1:B10

• =B1:B10

Give the cell references for the cells in rows 15–20 in column A.

• A1-20

• A15:A20

• A15:A

• A15:20

Give the cell references for the cells in rows 15–20 in column A, B and C.

• A15:A20,B15:B20,C15:C20

• A15-A20,B15-B20,C15-C20

• A15:C20

• A15-C20

Give the cell references for all of the cells of column A from row 2 to the end.

• A2-Aall

• A2:Aall

• A2:Aend

• A2:A