I.Refer to the attached spreadsheet,Cells D1, E1, F1, and G1 indicate the value of each graded item. For example, midterm 1 counts for 20%, midterm 2 counts for 25%, etc.What is the average total grade for everyone on the list?

Round your answer to two decimal places. 12.34% would be entered as12.34

2.Refer to the attached spreadsheet.The grading scheme is shown below; for example, a student scoring 56%would earn a C-. How many students earned a "B" in the course?Do not include students who earned a B- or a B+.

3.Refer to the attached spreadsheet. How many students have the initials RB?

4.And now for a challenge!Refer to the attached spreadsheet.How many students have the initials RB and earned either a C-, a C, or aC+ in the course?