Quelpr
1 markManipulating Data in a Spreadsheet

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

What data format has been applied to the data with the number of accounts for each of the banks?

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(c)The data in the spreadsheet have been sorted. Indicate the name of the field used for the sort.[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