1.1. 1.2. 1.3. 1.4. Insert the following content starting at A2: Surname: Student Name: Elvis Presley...

Transcribed Image Text:

1.1. 1.2. 1.3. 1.4. Insert the following content starting at A2: Surname: Student Name: Elvis Presley Michael Jackson Jennifer Aniston Mariah Alton Carey John Test 1 number: (15%) 12345 54321 24689 10910 26280 65 70 80 60 80 Bold all the headings Calculate the final mark Calculate the sum of Final Exam in cell F9 Test 2 (15%) 70 65 60 50 60 Exam (70%) 85 90 80 55 75 Final Mark (2) ~~~~~~~~~~~~~~ 1.5. Calculate the average mark in F9 using the Exam Mark 1.6. 1.7. Calculate the Maximum of Test 2 in cell E9 Calculate the Minimum of Test 1 in cell D9 Merge and Centre cells A1 - G1 1.8. 1.9. Add a border around the edges of the table 1.10. Change the colour of each column to a different colour 1.11. Add the colour Blue accent 5 lighter 60% to the first row and label it Mark sheet 1 (2) Change the sheet name to Business Management 1.12. 1.13. Change the Tab labelled Business Management colour to purple 1.14. Change the width of the columns accordingly 1.15. Change the marks to numbers, with no decimals 1.16. Insert the a bar graph of your choice using the information from: Exam mark Final mark The graph should show all labels (10) Names: Surname: Student number: 1 Alton Elvis Michael Jackson Jennifer Aniston Mariah Carey John Presley 12345 54321 24689 109010 26280 Test 1 (15%) 65 70 80 60 80 Test 2 (15%) 70 65 60 50 60 Exam (70%) 85 90 80 55 75 Final Mark =(F7+E7+D7)/3 1.1. 1.2. 1.3. 1.4. Insert the following content starting at A2: Surname: Student Name: Elvis Presley Michael Jackson Jennifer Aniston Mariah Alton Carey John Test 1 number: (15%) 12345 54321 24689 10910 26280 65 70 80 60 80 Bold all the headings Calculate the final mark Calculate the sum of Final Exam in cell F9 Test 2 (15%) 70 65 60 50 60 Exam (70%) 85 90 80 55 75 Final Mark (2) ~~~~~~~~~~~~~~ 1.5. Calculate the average mark in F9 using the Exam Mark 1.6. 1.7. Calculate the Maximum of Test 2 in cell E9 Calculate the Minimum of Test 1 in cell D9 Merge and Centre cells A1 - G1 1.8. 1.9. Add a border around the edges of the table 1.10. Change the colour of each column to a different colour 1.11. Add the colour Blue accent 5 lighter 60% to the first row and label it Mark sheet 1 (2) Change the sheet name to Business Management 1.12. 1.13. Change the Tab labelled Business Management colour to purple 1.14. Change the width of the columns accordingly 1.15. Change the marks to numbers, with no decimals 1.16. Insert the a bar graph of your choice using the information from: Exam mark Final mark The graph should show all labels (10) Names: Surname: Student number: 1 Alton Elvis Michael Jackson Jennifer Aniston Mariah Carey John Presley 12345 54321 24689 109010 26280 Test 1 (15%) 65 70 80 60 80 Test 2 (15%) 70 65 60 50 60 Exam (70%) 85 90 80 55 75 Final Mark =(F7+E7+D7)/3

Answer rating: 100% (QA)

ANSWER ANS13 D715E715F77 As in the question it is given that 15 of both test 1 test 2 and 7... View the full answer