Task B
1. Make columns B, C, D, E and F display percentages with no decimal places.
2. For John Smith, enter the value 75% for Maths (cell B4), 62% for English (cell C4) and 45% for Science (cell D4).
3. For David Jones, enter 61%, 48%, 70%
4. For Frank Wilson enter 63%, 80%, 51%
5. For Joanne Thompson enter 53%, 85%, 41%
6. For Susan Watson enter 42%, 63%, 85%
7. Change the font size of the title in cell A1 to 16
8. Increase the height of row 1 to allow for the larger text
9. Make all of the text in row 3 bold and underlined
10. Save the workbook with the name S2Exercise1B
The spreadsheet should appear as shown below:
