Research and Guided Practical

Class Task 1:Research

1.Give definitions and a labelled diagram for the following terms:

worksheet, cell, cell address, range, row , column.

2. Create and save spreadsheet document  which replicates the following arrangement:
[a student report cart , Subject and marks]

Class Task 2: Guided Practical

Create and save spreadsheet document  which replicates the following arrangement:

Student Name	Physics	Art	Music	Mathematics	Total
Jim	68	98	48	52
Mary	74	75	76	72
John	74	52	52	63
Sally	42	42	58	69
MAXIMUM MARK

Use formulas to calculate the maximum mark and totals for each student.

© 2020  Vedesh Kungebeharry. All rights reserved.