Quelpr
1 markSpreadsheet Terminologies and Notions

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

Refer to the given spreadsheet showing performance of 30 students in CSEC examinations across subjects.

State the number of rows that are illustrated 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(b)(i)Write the formula used to calculate the total number of students who passed Chemistry.[4 marks]
  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 Spreadsheet Terminologies and Notions questions · all CSEC Information Technology past papers