Spreadsheets quiz games for GCSE ICT (Eduqas 5539)

1. 1

   Which of these is an example of an absolute cell reference?

   =A1$A$1A1A1:A5
2. 2

   According to the spec, which of these is classed as a SIMPLE function?

   VLOOKUPCOUNTIFSUMIFAVERAGE
3. 3

   Which of these is a layout and formatting feature rather than a form control?

   A merged and centred title cellA check box form controlA spinner form controlA scroll bar form control

+ 12 more questions in the game.

1. 1

   Data that is a normal, sensible, acceptable value is ____ data.

   extremerandomvaliderroneous
2. 2

   A weakness identified during evaluation should come with a suggested ____.

   evaluationimprovementtabletesting
3. 3

   Recording a screenshot showing a test's actual outcome is evidence of ____.

   evaluationimprovementtestingtable

+ 12 more questions in the game.

1. 1

   Displaying a value such as 0.2 as 20% uses ____ formatting.

   rangepercentageconditionalformat
2. 2

   Which validation check ensures that a compulsory field, such as a customer's surname, cannot be left blank?

   Presence checkRange checkFormat checkType check
3. 3

   Cobalt Sports Academy is formatting its membership spreadsheet. True or false?

   Decimal place formatting has no effect on how a currency value is displayed.

+ 12 more questions in the game.

1. 1

   The ____ function finds the mean of a range of numbers.

   SUMAVERAGEINTMOD
2. 2

   ____ counts how many cells in a range meet a stated condition.

   COUNTIFVLOOKUPIFSUMIF
3. 3

   The ____ function returns the remainder after one number is divided by another.

   SUMMODINTAVERAGE

+ 12 more questions in the game.