Quelpr
2 marksCharting Operations

CSEC Information Technology · 2011 · Paper 2 · Question 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.

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(c)The data in the spreadsheet have been sorted. Indicate the name of the field used for the sort.[1 mark]
  4. 7(d)Write the function that should be used to find the HIGHEST number of loan accounts in a bank.[2 marks]

More practice: the rest of this paper · more Charting Operations questions · all CSEC Information Technology past papers