Spreadsheet Introduction Year 5

12 Questions | Total Attempts: 320

SettingsSettingsSettings
Please wait...
Spreadsheet Introduction Year 5

A basic quiz for a first experience with spreadsheets. For children aged 9 or 10.


Questions and Answers
  • 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.

Back to Top Back to top