12 Questions | Total Attempts: 320  Settings  A basic quiz for a first experience with spreadsheets. For children aged 9 or 10.

• 1.
What are spreadsheets used to do?
• A.

• B.

To make numbers prettier.

• C.

To organise data in a table.

• D.

To help us calculate rapidly, explore different options and represent data in charts.

• 2.
• A.

Keynote

• B.

Pages

• C.

Numbers

• D.

LibreOffice Calc

• E.

Word

• F.

Excel

• G.

Powerpoint

• 3.
• A.

Columns and rows

• B.

Lines and numbers

• C.

Cells and references

• 4.
Example/s of a cell reference.
• A.

5B

• B.

C1

• C.

L99

• D.

I8

• 5.
All formulae begin with...
• A.

+

• B.

-

• C.

*

• D.

/

• E.

=

• 6.
I want to multiply the number in cell E2 by that in cell B5. What is the formula?
• A.

=E2*B5

• B.

=E2xB5

• C.

=B5*E2

• D.

E2*B5=

• 7.
=F7/G3 This formula divides the number in cell F7 by the number in cell G3.
• A.

True

• B.

False

• 8.
What does the function SUM do?
• A.

It helps you put the title in the middle.

• B.

It quickly moves all the selected cells down.

• C.

It quickly adds up values in a range of cells.

• D.

It highlights all selected cells red.

• 9.
• A.

Creating charts and graphs

• B.

Exploring alternatives

• C.

Making work look better

• D.

Presenting research to an audience

• 10.
Which of these could you use a spreadsheet for?
• A.

Presenting data in charts and graphs

• B.

Presenting research homework.

• C.

Calculating pocket money in order to find out how long you need to wait to buy a new 'toy'.

• D.

Budgeting for a party.

Related Topics Back to top