In this project, you will finalize a gradebook by entering formulas to compute final grades and class statistics. You will also create a worksheet to lookup specific assignment grades for one student at a time and answer specific questions about overall class performance.
Skills needed to complete this project
• Using COUNTIF and COUNTIFS
• Rounding with Functions
• Creating Nested IF Formulas
• Analyzing Complex Formulas Using Evaluate Formula
• Finding the Middle Value with MEDIAN
• Finding the Most Common Value(s) with MODE.SNGL and MODE.MULT
• Managing Errors with the IFERROR Function
• Finding Data with MATCH and INDEX
• Using Database Functions
Attachment:- assignment.rar