Quelpr
1 markPaper 1 · Multiple choiceBasic Pre-defined System Functions

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

The function to display the text 'LOW' in cell G2 is

  1. (A)=IF(E2>F2, "LOW")
  2. (B)=IF(E2-F2, "LOW")
  3. (C)=IF(E2<F2, "LOW")
  4. (D)= IF(F2-E2, "LOW")

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. Q43Items 43-45 refer to the following spreadsheet. The values in Column B should be formatted using the[1 mark]
  2. Q44Which formula should be placed in Cell E2 to obtain the stock balance?[1 mark]

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