Quelpr
1 markManipulating Data in a Spreadsheet

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

If range A4 to F6 was sorted in ASCENDING order by subject, state the cell location of Biology after the sort.

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)(i)Write the formula used to calculate the total number of students who passed Chemistry.[4 marks]
  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 Manipulating Data in a Spreadsheet questions · all CSEC Information Technology past papers