Quelpr
4 marksCharting Operations

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

A bar chart titled 'Book Sales for Week 2' created from spreadsheet data is presented.

List the steps (in the correct order) required to create the chart from data in a 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. 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)(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]
  4. 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]
  5. 2(c)(iv)Write the formula/function to be inserted in Cell B8 to calculate the total number of books sold on Monday.[2 marks]

More practice: the rest of this paper · more Charting Operations questions · all CSEC Information Technology past papers