Spreadsheet formulas

Chalkplay teamComputingGrades 6–86 questionsMaze chase game makerEnglish
Copy & edit
Maze chase
ABCDWhich formula adds u…

Game options Saved per activity

For Maze chase. Sound and theme change straight away; other options start the game again.

Questions and answers

· 6 questionsShow answers
  1. 1. Which formula adds up cells A1 to A5?
    • Correct answer: =SUM(A1:A5)
    • =ADD(A1:A5)
    • =A1+A5
    • =TOTAL A1-A5
  2. 2. What does =AVERAGE(B1:B4) work out?
    • Correct answer: The mean of B1 to B4
    • The largest value
    • The total
    • How many cells there are
  3. 3. A1 holds 6 and A2 holds 4. What does =A1*A2 show?
    • Correct answer: 24
    • 10
    • 64
    • 2
  4. 4. Which formula finds the largest value in C1 to C10?
    • Correct answer: =MAX(C1:C10)
    • =MIN(C1:C10)
    • =TOP(C1:C10)
    • =SUM(C1:C10)
  5. 5. What does every spreadsheet formula start with?
    • Correct answer: =
    • +
    • #
    • $
  6. 6. What does the cell reference B3 mean?
    • Correct answer: Column B, row 3
    • Row B, column 3
    • Sheet B, page 3
    • The third cell in the sheet

Leaderboard

No scores yet. Play it live and the class's scores appear here.