1. Set up a worksheet exactly as follows, ensuring that the “Average” column and row are calculated via a formula:
2. Move the results rows so that they are in alphabetic order by surname making sure that the “Average” column and “Paper average” row are still calculated correctly.
3. Move the “Average” column (column E) so that it appears after the “Name” column and before the “Paper 1” column.
4. The mark for Peter Davidson Paper 3 should be 45%, not 85%. Make the correction.
5. Apply conditional formatting to the “Average” column so that values greater than 60% are shown in bold green text with a light green background.
6. Apply conditional formatting the “Paper 1”, “Paper 2” and “Paper 3“ columns so that values less than 50% are displayed shown in bold red text with a light red background.
7. Save the workbook with the name S2Exercise4
The worksheet should appear as follows:
