Quelpr
4 marksBasic Pre-defined System Functions

CSEC Information Technology · May/June 2013 · Paper 2 · Question 7(b)(i)

Write the formula used to calculate the total number of students who passed Chemistry.

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 number of rows that are illustrated in the spreadsheet.[1 mark]
  2. 7(b)(ii)If range A4 to F6 was sorted in ASCENDING order by subject, state the cell location of Biology after the sort.[1 mark]
  3. 7(c)(i)State the name of the function that should be used to find the number of subjects listed in the spreadsheet.[1 mark]
  4. 7(c)(ii)State the name of the function that should be used to find the LEAST number of passes with Grade I.[1 mark]

More practice: the rest of this paper · more Basic Pre-defined System Functions questions · all CSEC Information Technology past papers