Using the IF Function Student ID Grade Pass/Fail ABC/F 1095 78 Pass C 1154 84 Pass B 1261 26 Fail F 1343 51 Fail F 1552 80 Pass B 2063 46 Fail F 2142 72 Pass C 2229 62 Fail F 2478 91 Pass A 2617 95 Pass A 3230 55 Fail F 3573 99 Pass A 3737 44 Fail F 3886 68 Fail F 4400 71 Pass C 4639 74 Pass C 4959 50 Fail F
Added by Sarah H.
Close
Step 1
To calculate the average grade, we can use the AVERAGE function. So, in cell B21, we can write the formula as: =AVERAGE(B3:B20) Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
I am doing an Excel macro assignment and need to know how to do the following: Create Button 3: Name: "Click here to calculate the desired letter grade" Action: Calculate the letter grade (based on the desired overall mark) and display it in cell H17. Use the following formula to calculate the letter grade: OVERALL GRADE LETTER GRADE >= 85 A < 85 AND >= 70 B < 70 AND >= 60 C < 60 AND >= 50 D < 50 F Create Button 4: Name: "Click here to calculate the final Exam Mark" Action: 1. Display the following message in cell F19 "Final Exam Mark / 35". 2. Calculate the final exam mark (/35) the student needs to reach the desired overall mark and display it in cell G19. 3. Display the following message in cell F20 "Final Exam Mark / 100". 4. Calculate the final exam mark (/100) the student needs to reach the desired overall mark and display it in cell G20.
Supreeta N.
Write the formula to add the cell value from C2 through C9 (class 7)
Haricharan G.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD