Lab › Formulas & Functions › Shop Bill with GST
Shop Bill with GST: Excel Lab
Lab 13 · IntermediateMultiplication$ absolute referenceSUM
The task: Make a shop bill: amount for each item, GST at 18%, the item total and the grand total.
1 Watch how it is done
Step 1: Amount = Qty × Rate
=B4*C4- Click D4.
- Type =B4*C4 and press Enter.
- Drag the fill handle down.
Step 2: GST = Amount × GST rate
=D4*$H$4- Click E4.
- Type =D4*$H$4 and press Enter.
- Drag the fill handle down.
Step 3: Total = Amount + GST
=D4+E4- Click F4.
- Type =D4+E4 and press Enter.
- Drag the fill handle down.
Step 4: Grand total
=SUM(F4:F9)- Click the cell next to Grand Total.
- Press Alt + = (AutoSum) 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: Loan EMI Table →
Want the theory? Read the Formulas & Functions lessons →
← More Formulas & Functions labs · All lab categories
