Quelpr

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

The Softball Association keeps details of all monies collected in a spreadsheet.

State the cell address and the function required in the cell to compute the total revenue collected from sponsors.

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(b)What format has been applied to the numeric data in the spreadsheet?[1 mark]
  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 Basic Pre-defined System Functions questions · all CSEC Information Technology past papers