Data Detective (Spreadsheets & Modelling) quiz games for KS3 Computing

1. 1

   What value does the formula =MAX(3,9,5) return?

   17935
2. 2

   Every formula in a spreadsheet must start with which symbol?

   %=@#
3. 3

   Which symbol is used for multiplication inside a spreadsheet formula?

   &*^x

+ 12 more questions in the game.

1. 1

   Relative and absolute references: true or false?

   A relative reference changes when the formula is copied to another cell.
2. 2

   Choosing charts: true or false?

   A bar chart is a poor choice for comparing totals between different categories.
3. 3

   Relative and absolute references: true or false?

   Once a formula is typed in, its references can never be changed to absolute.

+ 12 more questions in the game.

1. 1

   Spreadsheet functions: true or false?

   =COUNT(A1:A4) counts how many of those cells contain a number.
2. 2

   Formulas and operators: true or false?

   A formula can refer to a cell that itself contains another formula.
3. 3

   Spreadsheet basics: true or false?

   A cell reference like B4 always names the column first and the row second.

+ 12 more questions in the game.