Spreadsheet Introduction Year 5
A basic quiz for a first experience with spreadsheets. For children aged 9 or 10.
- 1.What are spreadsheets used to do?
- A.
To add pictures to text.
- 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.Tick the spreadsheet programs.
- A.
Keynote
- B.
Pages
- C.
Numbers
- D.
LibreOffice Calc
- E.
Word
- F.
Excel
- G.
Powerpoint
- 3.Spreadsheets are arranged in...
- 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.Spreadsheets are useful for ...
- 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.
Questions: 6 | Attempts: 1683 | Last updated: Jul 30, 2011
-
Sample QuestionTables in spreadsheets are better than tables in word processors because they
Questions: 6 | Attempts: 1553 | Last updated: Jul 26, 2019
-
Sample QuestionWhat is the cell that you are working on called?
Questions: 15 | Attempts: 1277 | Last updated: Mar 7, 2013
-
Sample QuestionYou do not need to take the time to create a formula for specific set of cells you can use the ________ __________ to do it for you.
Back to top