A blank workbook is a good place to learn because you can change a number and immediately see what a formula does. This exercise uses a pretend supplies list with three rows. Keep it separate from a real budget or work file while you practice.
Begin formulas with =, use cell references instead of retyping values, and practice multiplication plus SUM on a small table you can check by hand.
Go straight to the stepsBefore you begin
The examples use English function names and ordinary A1-style cell references. Localized Excel versions may display different function names or separators.
What you’ll need
- Excel on a computer or in a browser
- A new blank workbook
- A few minutes to enter and check sample numbers
Let’s do this
Step by step
- 01
Create the practice table
In A1:D1, enter Item, Quantity, Unit price, and Total. Add Notebook, Pen, and Folder in A2:A4. Put 2, 3, and 4 in B2:B4, and 5, 2, and 1 in C2:C4.
- 02
Calculate the first row
Click D2, type =B2*C2, and press Enter. The answer should be 10. Select D2 again and inspect the formula bar: the cell shows the result while the bar shows the calculation.
- 03
Copy the formula down
Copy D2 to D3:D4, or use the fill handle. Check each result and formula. Relative references should move to the corresponding row: =B3*C3 and =B4*C4. The results are 6 and 4.
- 04
Add the totals
In D5, type =SUM(D2:D4). The colon identifies the continuous range from D2 through D4. The result should be 20. Put a label such as Grand total in C5 so the answer has context.
- 05
Change an input and verify
Change the notebook quantity in B2 from 2 to 3. D2 should become 15 and D5 should become 25. This check demonstrates why referring to an input cell is useful.
Practice changing one thing
Duplicate the practice sheet before experimenting. Add a fourth item, then examine whether the grand total includes it. You are learning to inspect a formula’s range instead of assuming the answer is right because it looks plausible.
Try predicting the result before pressing Enter. If two folders cost one unit each, you already know the line total should be two. A tiny example with a known answer helps you distinguish a wrong reference from a misunderstanding of the calculation.
Keep the sheet readable
Choose one place for each input and label it. Avoid burying a changing price inside a formula such as =3*2 if the price already has its own cell. When you revisit the sheet, you should be able to identify the inputs and the calculated outputs without remembering today’s exercise.
Small formulas worth recognizing
| Purpose | Example | Result |
|---|---|---|
| Add two numbers | =2+3 | 5 |
| Subtract | =9-4 | 5 |
| Multiply | =3*4 | 12 |
| Divide | =12/3 | 4 |
| Control calculation order | =(2+3)*4 | 20 |
A quick final check
- The first row returns 10 before I change it.
- Copied formulas refer to the correct rows.
- The final change produces a grand total of 25.
Common questions & sticking points
Why does Excel show my formula as text?
Check for a leading apostrophe and whether the cell is formatted as Text. Change to General and re-enter the formula if needed. Show Formulas can also display formulas instead of results.
What should I learn after SUM?
Try AVERAGE, COUNT, and absolute references on another small practice table. Add one concept at a time and check results you can calculate yourself.
Sources & further reading Optional
References used to check this guide. Follow your product’s own safety instructions where its design differs.
Last source check: September 21, 2026