Quelpr
1 markManipulating Data in a Spreadsheet

CSEC Information Technology · January 2014 · Paper 2 · Question 7(d)(i)

State the criterion to implement the filter to extract all revenue items with a TOTAL greater than 25 000 for the six-month period. (Indicate the column heading and the criterion to be inserted under the column heading.)

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 7(a)State the cell address and the function required in the cell to compute the total revenue collected from sponsors.[3 marks]
  2. 7(b)What format has been applied to the numeric data in the spreadsheet?[1 mark]
  3. 7(c)A pie chart was created for the data in the spreadsheet. Each slice of the pie indicates the month, the total for the month and the percentage of the total…[2 marks]
  4. 7(d)(ii)How many revenue items will be extracted by the filter?[1 mark]

More practice: the rest of this paper · more Manipulating Data in a Spreadsheet questions · all CSEC Information Technology past papers