Excel exercise
Question A:
1. Create 5 columns naming Student ID, Test 1, Test 2, Test 3, and test 4
2. Bold column names and change Heading style to “Heading 2”
3. Fill up these columns with the value of following the image -
4. Insert a blank row at 2nd row and insert date of test following the image -
5. Create a new column naming “Average” and copy format style and paste on “Average” cell.
6. Calculate average mark of each student using calculation field.
7. Calculate average mark of each test exam bellow test marks and naming the row “Test Average”.
8. Test Average marks should be formatted with 2 decimal places.
9. Insert Header with your name and footer with current date.
10. Save the workbook naming it “Grades”.