Quelpr
2 marksCharting Operations

CSEC Information Technology · January 2014 · Paper 2 · Question 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 revenue collected. State the ranges for the category name and the data used in the creation of the pie chart.

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(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 Charting Operations questions · all CSEC Information Technology past papers