Excel task 1
   
quiz 1
quiz 2
quiz 3
quiz 4
quiz 5
average
1 Paul McCartney
77%
87%
92%
67%
74%
?
2 Frank Sinatra
65%
57%
72%
99%
68%
?
3 William Clinton
87%
94%
98%
60%
89%
?
4 Madeleine Albright
96%
88%
92%
90%
94%
?
5 Golda Meir
88%
96%
85%
92%
66%
?
6 Dan Brown
84%
77%
93%
77%
86%
?
7 Sandra O'Connor
70%
82%
69%
95%
75%
?
   
?
?
?
?
?
   
class average
class average
class average
class average
class average
 
               
               
Within Microsoft Excel, set up a spreadsheet for the quizzes you have given your Spanish class.  
Alphabetize the list of students. Determine the class average for each quiz given, as well as each student's quiz average.
Create in your journal a new slide called "My Excel Spreadsheets." Insert Excel task 1.
  Your Excel program has help like this page on how to enter a formula.