SECTION D: MS EXCEL QUESTIONS FOUR(20 MARKS) PRACTICAL EXCEL 1. Cre...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
SECTION D: MS EXCEL QUESTIONS FOUR(20 MARKS)
PRACTICAL EXCEL
1. Create a new workbook using the given data above and save the file with the name “Football player Marks “ Enter the following data into an Excel spreadsheet. 2. Assign a Grade based on the Final Marks using the following criteria: e,g Use the IF• A: 80–100• B: 70–79• C: 60–69• D: 50–59• F: below 503. At the bottom of the spreadsheet, calculate the following statistics for Final Marks:• Mode• Count• Maximum• Minimum 4. Calculate the Final Marks by adding CA, Assignment, and Exam marks. 5. Use a formula to determine if each student Passed or Failed. A pass is 50 or above in Final Marks. 6. Use a formula to calculate the Average Final Marks for each student. 7. Bold the header row. 8. Add a Total row at the bottom of the CA, Assignment, and Exam columns.
Want instant access to all verified answers on learning.richfield.ac.za?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!