Quelpr
2 marksBasic Pre-defined System Functions

CSEC Information Technology · 2022 · Paper 2 · Question 2(c)(iv)

A spreadsheet showing book sales data for Week 2 is provided.

Write the formula/function to be inserted in Cell B8 to calculate the total number of books sold on Monday.

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. 2(a)State the location on the network where EACH of the following hardware devices could be found AND describe the function of EACH device: - Network interface…[8 marks]
  2. 2(b)The wireless devices were accessing the Internet but Sharon's desktop computer was unable to access the Internet. Suggest TWO instructions that could be given…[2 marks]
  3. 2(c)(i)List the steps (in the correct order) required to create the chart from data in a spreadsheet.[4 marks]
  4. 2(c)(ii)State ONE other type of chart which is appropriate to represent the data in the spreadsheet and state how it differs from the one shown.[2 marks]
  5. 2(c)(iii)Name ONE type of chart other than those mentioned in (c)(i) and (ii) and describe when it is BEST used.[2 marks]

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