Gradebook Ideas (Teachers new to Excel) - Step 3

Links Verified: March 20, 2026

Use the AVERAGE function to calculate each student score average. Then bold the headings, add borders, and center the score columns.

Add Averages and Format the Sheet

Next step: review and update the gradebook.

Try It

1. In the first Average cell, type =AVERAGE(B2:D2).
2. Press Enter and copy the formula down.
3. Add bold text, borders, and light heading color.

This project is part of the Excel Classroom Data Projects series.

Next step: Continue to step 4.