The accompanying spreadsheet model, which is designed to compute student grades, contains some errors.
a. Show and review the formulas in the spreadsheet model. Which cells are most likely to contain formulas with errors?
b. For each of the suspected cells, identify the precedents and dependents of the formula in the cell. Use the Error Checking tool to inspect the cells. Are the errors due to circular reference, incorrect cell reference, or invalid user inputs?
c. Repair the errors and use the Watch Window tool to monitor the values in E20, F21, I10, and I15. What are the values in those cells after the errors have been fixed? Show the repaired formulas in the spreadsheet model.

 

Gradebook
Student ID	Exam 1	Exam 2	Exam 3	Homework 1	Homework 2	Homework 3	Course Number Grade	Course Letter Grade		Grading Criteria
000-01-5562	60	50	40	79	92.0	76	58.7	F		0	F
000-01-2667	80	71	70	84	81.0	90	0	#N/A		60	D
000-01-7376	65	65	65	60	90.0	94	0	#N/A		70	C
000-01-1986	90	90	80	90	100.0	85	0	#N/A		80	B
000-01-1936	75	70	65	95	94.0	85	0	#N/A		90	A
000-01-2306	92	78	65	84	82.0	73	0	#N/A
000-01-9719	82	78	62	77	98.0	74	0	#N/A
000-01-9713	96	98	97	90	77.0	83	0	#N/A
000-01-9797	92	88	65	78	94.0	89	0	#N/A
000-01-7686	94	92	86	84	75.0	73	0	#N/A
000-01-7905	60	50	65	80	86.0	74	0	#N/A
000-01-4447	78	81	70	78	75.0	99	0	#N/A
000-01-3981	90	90	90	70	87.0	86	0	#N/A
000-01-5359	92	95	79	80	81.0	71	0	#N/A
Average	81.85714	78.28571	71.35714	80.6428571	86.5714286	82.2857143
Maximum	96	98	97	95	100	99
Minimum	60	60	60	60	60	60
Grade allocation:	20%	20%	30%	10%	10%	10%