BCIS Excel Final Exam Review Gradebook Exercise
1. Fill in the empty cells in the Gradebook spreadsheet with the correct formulas, not
the mathematical answer.
a. The Daily Avg field is calculated by adding up all of the daily grades.
b. The Test Avg is calculated by the typical method of averaging grades. Use
the most efficient method assuming there could be many more test grades.
c. The Average field is calculated by counting the Daily Avg as 20% of the
total average, the Test Avg as 65% of the total average, and the Final
Exam as 15% of the total average.
d. The Class Average is the average of all student averages.
e. The Pass/Fail column contains a “Pass” if the student average is greater
than a 79, or “Fail” if it is less than an 80.
2. Insert a row at the top of the spreadsheet and add the title “Mrs. Garza’s
Gradebook” in cell A1
3. Center the title in the middle of the spreadsheet.
4. Change the font size of the title to 14 points.
5. Make the title bold.
6. Make the Daily Avg, Test Avg, Final Exam, and Average column headings bold
7. Make all column headings over numeric data right justified in the cell.
8. Format the Average field to 2 decimals.
9. Sort the Student Names in ascending order.
10. Insert a row at the top of the spreadsheet entering your name in cell A1 and your
class period in C1.
11. Adjust all columns’ width as necessary so all labels and date are displayed
12. Produce a column chart to compare each student’s Daily Avg, Test Avg, and
Final Exam grade. Add a chart title and labels as shown. Your chart should be
similar to the one below.
13. Fill the graph with a light blue color
14. Print both values and formulas in landscape. Print the chart on the same page as
the worksheet. Save as FinalReview2.Make sure to go in Page Setup and select
“Fit on 1 page”
Mrs. Garza's Gradebook Analysis
80 Daily Avg
60 Test Avg
40 Final Exam