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.All formulae begin with...
- A.
+
- B.
-
- C.
*
- D.
/
- E.
=
- 5.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=
- 6.=F7/G3 This formula divides the number in cell F7 by the number in cell G3.
- A.
True
- B.
False
- 7.Spreadsheets are useful for ...
- A.
Creating charts and graphs
- B.
Exploring alternatives
- C.
Making work look better
- D.
Presenting research to an audience
- 8.Example/s of a cell reference.
- A.
5B
- B.
C1
- C.
L99
- D.
I8
- 9.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.
- 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: 10 | Attempts: 2789 | Last updated: Aug 30, 2022
-
Sample QuestionTables in spreadsheets are better than tables in word processors because they
Questions: 12 | Attempts: 2403 | Last updated: Mar 22, 2022
-
Sample QuestionWhat software application is the most effective tool to create charts of data?
Questions: 15 | Attempts: 1466 | Last updated: Mar 22, 2022
-
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