Quelpr
1 markManipulating Data in a Spreadsheet

CSEC Information Technology · 2015 · Paper 2 · Question 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?

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(b)Write the function to find the maximum YEARLY Total for the period 2013-2015.[2 marks]
  3. 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]
  4. 7(d)The sales figures in the spreadsheet have been formatted. State the format used.[1 mark]

More practice: the rest of this paper · more Manipulating Data in a Spreadsheet questions · all CSEC Information Technology past papers