Quelpr
2 marksBasic Pre-defined System Functions

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

Write the function that should be used to find the HIGHEST number of loan accounts in a bank.

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(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 Basic Pre-defined System Functions questions · all CSEC Information Technology past papers