Quelpr
1 markSpreadsheet Terminologies and Notions

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

A spreadsheet showing BJ Stores sales from 2013 to 2015.

State the name of the feature used in the spreadsheet to align the text "BJ STORES" across the columns used in 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(b)Write the function to find the maximum YEARLY Total for the period 2013-2015.[2 marks]
  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 Spreadsheet Terminologies and Notions questions · all CSEC Information Technology past papers