10 Questions

• 1.
What is the name of the square or box in a spreadsheet called?
• A.

Block

• B.

Cell

• C.

Brick

• D.

Wall

• E.

Cement

• 2.
What is the name of a cell that has a thick black line around it?
• A.

Formula

• B.

Active Cell

• C.

• D.

Cell Reference

• E.

Range

• 3.
What is a combination of column letter and a row number?
• A.

Cell Name

• B.

Rows

• C.

Columns

• D.

A Meeting Place

• E.

All of the above

• 4.
What is the correct way to start a formula?
• A.

+

• B.

-

• C.

=

• D.

/

• E.

(

• 5.
What is the correct formulae for adding 2 cells together?
• A.

A1+A2

• B.

+A1/A2

• C.

=A1+A2

• D.

(A1+A2)

• E.

A1-A2

• 6.
What does autofill do?
• A.

Fills up the cells with colour

• B.

Adds figures in a row or column

• C.

Formats the data to currency

• D.

Calculates the remaining rows or columns

• E.

Copies cells

• 7.
How do you create an absolute cell reference?
• A.

Put a fence around it

• B.

Use the Format menu

• C.

Use a formula

• D.

Add £ signs before the cell

• E.

Add \$ signs to the cell reference

• 8.
Put this formula in the correct order (sumA1:A5=)
• A.

(=sum)A1:A5

• B.

Sum=(A1:A5)

• C.

(A1:A5)sum=

• D.

=sum(A1:A5)

• E.

=(A1:A5)sum

• 9.
What is the name of the cell in column G row 20?
• A.

02G0

• B.

20G

• C.

G20

• D.

0G2

• E.

CG20

• 10.
Spreadsheets can be used to see different scenarios to see what might happen.  What is this called?
• A.

Testing

• B.

Working Out

• C.

Estimating

• D.

Planning

• E.

Modelling

Related Quizzes
Featured Quizzes
Related Topics