2 marksTabulations, Data Management, and Integration

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

Calculate the Total Amount Paid.

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

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)(iv)Calculate the Average Fee.[2 marks]
3(b)(v)Calculate the Average Amount Paid.[2 marks]
3(c)Center the spreadsheet vertically and horizontally on the page.[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 Tabulations, Data Management, and Integration questions · all CSEC Electronic Document Preparation and Management past papers