Quelpr
1 markSpreadsheet Terminologies and Notions

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

What format has been applied to the numeric data in the spreadsheet?

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(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]
  3. 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…[1 mark]
  4. 7(d)(ii)How many revenue items will be extracted by the filter?[1 mark]

More practice: the rest of this paper · more Spreadsheet Terminologies and Notions questions · all CSEC Information Technology past papers