Lab › Excel Basics › Highest, Lowest and Average Marks
Highest, Lowest and Average Marks: Excel Lab
Lab 02 · BeginnerMAXMINAVERAGE
The task: Find the highest mark, the lowest mark and the class average.
1 Watch how it is done
Step 1: Find the highest mark
=MAX(B4:B11)- Click the cell next to Highest.
- Type =MAX(B4:B11) and press Enter.
Step 2: Find the lowest mark
=MIN(B4:B11)- Click the cell next to Lowest.
- Type =MIN(B4:B11) and press Enter.
Step 3: Find the class average
=AVERAGE(B4:B11)- Click the cell next to Average.
- Type =AVERAGE(B4:B11) and press Enter.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Sales Growth % →
Want the theory? Read the Excel Basics lessons →
← More Excel Basics labs · All lab categories
