Lab › Excel Basics › Monthly Sales Totals
Monthly Sales Totals: Excel Lab
Lab 01 · BeginnerSUMAVERAGEFill Handle
The task: A shop sold 6 products for 4 months. Find the total and the average for each product.
1 Watch how it is done
Step 1: Add the four months
=SUM(B4:E4)- Click cell F4.
- Type =SUM(B4:E4) and press Enter.
- Drag the fill handle (small square at the corner) down to the last row.
Step 2: Find the average
=AVERAGE(B4:E4)- Click cell G4.
- Type =AVERAGE(B4:E4) and press Enter.
- Drag the fill handle down to the last row.
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: Highest, Lowest and Average Marks →
Want the theory? Read the Excel Basics lessons →
← More Excel Basics labs · All lab categories
