Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Back Excel Assignment Semester 1.pdf 1 AVERAGE RESULTS OF STUDENTS IN CLASS (AVERAGE) 2 TOP STUDENT IN THE CLASS (MAX) 3 THE LOWEST STUDENT IN
Back Excel Assignment Semester 1.pdf 1 AVERAGE RESULTS OF STUDENTS IN CLASS (AVERAGE) 2 TOP STUDENT IN THE CLASS (MAX) 3 THE LOWEST STUDENT IN THE CLASS (MIN) 4 NUMBER OF STUDENTS ATTENDED THE EXAM (COUNT) Use the above Sample Excel Table (Type the data, format it as required, Complete and perform the calculations) 1. Save the Workbook as Excel assigment.xlsx in Documents 2. Merge and Center the title "COMPUTER SCIENCE FINAL EXAM RESULTS JAN 2023 " 3. Type the following data, format it as required, and perform the calculations 4. Use Autosum function to calculate the total of each student 5. Use Average function to calculate the average of each student 6. Use IF function to calculate the Grade of each student 7.Use if function to display students who have passed and failed (Student Status) 8. Produce the Top student with the highest marks in the exam 9. Produce the lowest student in the Exam 10. show Student Grades in pie chart 11. Save and submit ExcelAssignment.xIsx to your instructor whatsapp number Student Grades JAN 2023 Student Girades IAN 2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started