Starter quiz

  • Why is it important to organise data?
    • to make it easier to understand  ✓
    • to make it look pretty
    • to make it harder to find
    • to confuse others
  • What is a spreadsheet?
    • a piece of paper with data
    • a tool for drawing pictures
    • an electronic document for organising data  ✓
    • a type of graph
  • Match the terms with their definitions.
    • row
      a horizontal line of data ✓
    • column
      a vertical group of data ✓
    • cell
      a rectangular box in a spreadsheet ✓
    • formula
      a calculation in a spreadsheet ✓
    • function
      a ready-made instruction for a calculation ✓
    • range
      a group of cells next to each other ✓
  • What is the cell reference for the first cell in a spreadsheet?
    • 'A1' ✓
  • If we wanted to add up all the cells between B2 to B10 using a function, what would we type in?
    • '=SUM(B2:B10)' ✓
  • What is a budget used for?
    • organising data
    • calculating totals
    • creating graphs
    • planning spending  ✓
+