Quelpr
1 markSpreadsheet Terminologies and Notions

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

Questions based on the given spreadsheet.

State the range of cells containing the names 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(b)What data format has been applied to the data with the number of accounts for each 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 Spreadsheet Terminologies and Notions questions · all CSEC Information Technology past papers