76
Spreadsheet
Activity 22: Create a simple spreadsheet to show
marks and grade of pupils of Grade 3
in a Maths test:
Save the spreadsheet in the folder Grade 3 using lename “Maths Test”.
Activity 23: Apply the following formatting to
the le “Maths Test”:
1. Change the font of the words NAME, MARK and GRADE to Times New Roman
and their font size to 16.
2. Change the colour of the names of pupils to blue.
3. Apply bold to the grade of Pravin and change its colour to red.
4. Italicize Amira’s name.
5. Adjust the columns’ widths where the text does not t in.
6. Save and close the le.
NAME MARK GRADE
Amira 87 A
Christian 71 B
Pravin 28 U
Rita 50 C