Quelpr
1 markManipulating Data in a Spreadsheet

CSEC Information Technology · 2011 · Paper 2 · Question 7(c)

The data in the spreadsheet have been sorted. Indicate the name of the field used for 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 range of cells containing the names of the banks.[1 mark]
  2. 7(b)What data format has been applied to the data with the number of accounts for each of the banks?[1 mark]
  3. 7(d)Write the function that should be used to find the HIGHEST number of loan accounts in a bank.[2 marks]
  4. 7(e)You are asked to create a pie chart to show the TOTAL number of accounts in EACH bank. Write the TWO ranges of data you would use.[2 marks]

More practice: the rest of this paper · more Manipulating Data in a Spreadsheet questions · all CSEC Information Technology past papers