Quelpr
3 marksFiling Systems and Security

CSEC Electronic Document Preparation and Management · 2014 · Paper 2 · Question 3(e)

Save the document as 'spreadsheet' and print the spreadsheet and chart on separate pages.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(a)Type the registration data in a spreadsheet using landscape orientation, following all layout and formatting instructions.[8 marks]
  2. 3(b)(i)Calculate the Balance Owed for each participant.[3 marks]
  3. 3(b)(ii)Calculate the Total Fee.[2 marks]
  4. 3(b)(iii)Calculate the Total Amount Paid.[2 marks]
  5. 3(b)(iv)Calculate the Average Fee.[2 marks]
  6. 3(b)(v)Calculate the Average Amount Paid.[2 marks]
  7. 3(c)Center the spreadsheet vertically and horizontally on the page.[2 marks]
  8. 3(d)Create a column chart titled 'Payments to Date' displaying total fees and total payments to date, labelling all axes.[9 marks]

More practice: the rest of this paper · more Filing Systems and Security questions · all CSEC Electronic Document Preparation and Management past papers