Quelpr
8 marksTabulations, Data Management, and Integration

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

Spreadsheet task involving conference registration information, calculations, formatting, and chart creation.

Type the registration data in a spreadsheet using landscape orientation, following all layout and formatting instructions.

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. 3(b)(i)Calculate the Balance Owed for each participant.[3 marks]
  2. 3(b)(ii)Calculate the Total Fee.[2 marks]
  3. 3(b)(iii)Calculate the Total Amount Paid.[2 marks]
  4. 3(b)(iv)Calculate the Average Fee.[2 marks]
  5. 3(b)(v)Calculate the Average Amount Paid.[2 marks]
  6. 3(c)Center the spreadsheet vertically and horizontally on the page.[2 marks]
  7. 3(d)Create a column chart titled 'Payments to Date' displaying total fees and total payments to date, labelling all axes.[9 marks]
  8. 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