FINANCIAL RECORD typing

8-

Question 4 (b) i 25 minutes

Create the spreadsheet following ALL instructions given.

(ii) Use equal left and right margins of I " (2.54 cm) on A4 or letter size paper.

(iii) Use portrait orientation.

(iv) Centre ALL column headings.

(v) Use formulae to calculate ALL totals where applicable.

Use formulae to calculate the balance due for each student.

(vii) Format ALL dollar amounts as currency.

(viii) Create a column chart with the title "balance due" to show the amount owing by each

student.

(ix) Save the document as Records.

GO ON TO THE NEXT PAGE 01251020/F2018

Sludcnl€

Namcg Iola] Amt

A (Iml

finian«e

Boarding V)ue

Rcnicih Francig

Xavier Picard

Sharine Marsh

Okeema Pius

Vijay Ramlogan

TOTAL

3912

8764

8525

7465

cc

300

300

300

300

1475

'c

1800

2500

4500

300

Fec

500

500

1000

500

1000

ran-Ne-.

8

(16 marks)

Total 34 marks

END OF TEST

IF YOU FfNISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.

01251020/F 2018