Quelpr
2 marksBasic Pre-defined System Functions

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

Write the function to find the maximum YEARLY Total for the period 2013-2015.

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 name of the feature used in the spreadsheet to align the text "BJ STORES" across the columns used in the spreadsheet.[1 mark]
  2. 7(c)It is projected that the 2016 sales for each branch will increase by 10% over the 2015 sales. Write the formula to compute the 2016 projected sales for the BCE…[2 marks]
  3. 7(d)The sales figures in the spreadsheet have been formatted. State the format used.[1 mark]
  4. 7(e)If the spreadsheet is sorted in ascending order by the total sales for each branch, which branch will be at the top of the spreadsheet?[1 mark]

More practice: the rest of this paper · more Basic Pre-defined System Functions questions · all CSEC Information Technology past papers