Quelpr
1 markPaper 1 · Multiple choiceManipulating Data in a Spreadsheet

CSEC Information Technology · May/June 2017 · Paper 1 · Question Q43

Items 43-45 refer to the following spreadsheet. The values in Column B should be formatted using the

  1. (A)comma format
  2. (B)money format
  3. (C)currency format
  4. (D)percentage format

This question uses a figure or table from the paper — you'll see it when you practise.

The answer is shown once you've answered.

Practise this question

Other parts of this question

  1. Q44Which formula should be placed in Cell E2 to obtain the stock balance?[1 mark]
  2. Q45The function to display the text 'LOW' in cell G2 is[1 mark]

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