CSEC Electronic Document Preparation and Management · 2014 · Paper 2 · Question 3(c)
Center the spreadsheet vertically and horizontally on the page.
The mark scheme is shown once you've answered.
Practise this questionOther parts of this question
- 3(a)Type the registration data in a spreadsheet using landscape orientation, following all layout and formatting instructions.[8 marks]
- 3(b)(i)Calculate the Balance Owed for each participant.[3 marks]
- 3(b)(ii)Calculate the Total Fee.[2 marks]
- 3(b)(iii)Calculate the Total Amount Paid.[2 marks]
- 3(b)(iv)Calculate the Average Fee.[2 marks]
- 3(b)(v)Calculate the Average Amount Paid.[2 marks]
- 3(d)Create a column chart titled 'Payments to Date' displaying total fees and total payments to date, labelling all axes.[9 marks]
- 3(e)Save the document as 'spreadsheet' and print the spreadsheet and chart on separate pages.[3 marks]
More practice: the rest of this paper · more Document Formatting and Editing questions · all CSEC Electronic Document Preparation and Management past papers