Excel task 2
   
quiz average
class participation
exam 1
exam 2
exam 3
course grade
   
20%
10%
20%
20%
30%
100%
1 Paul McCartney
79%
95%
88%
90%
92%
?
2 Frank Sinatra
72%
90%
70%
96%
88%
?
3 William Clinton
86%
98%
90%
98%
92%
?
4 Madeleine Albright
92%
87%
95%
97%
88%
?
5 Golda Meir
85%
75%
88%
93%
91%
?
6 Dan Brown
83%
80%
77%
85%
92%
?
7 Sandra O'Connor
78%
75%
90%
88%
94%
?
   
?
?
?
?
?
   
class average
class average
class average
class average
class average
 
               
               
Within Microsoft Excel, set up a spreadsheet for the variously weighted course grade sources in your Spanish class.  
Alphabetize the list of students (by last name). Determine the class average for each column, as well as each student's course grade.
Paste in your journal Excel task 2.
  Your Excel program has help like this page on how to enter a formula.