lesson
A formula can use current cell values
1 · Learn
A formula calculates from values or references. In a typical spreadsheet, =B2*C2 multiplies the current values of B2 and C2. If either value changes, the formula result updates. Typing a previously calculated total as a number does not create that relationship.
Check formula syntax in your approved tool and test with simple known values. A plausible-looking total can still come from the wrong reference.
2 · Worked example
If B2 contains 4 and C2 contains 2.50, the result is 10. Changing B2 to 6 gives 15 without replacing the formula.
3 · Your turn
B2 is 3 and C2 is 1.20. What should =B2*C2 show? What happens if B2 becomes 5?
Check your answer
3.60, then 6.00, assuming numerical values and ordinary currency formatting.
4 · Apply your learning
Enter the model in an approved spreadsheet, change one input and check against a hand calculation.
Adult guidance and safety
Use a school-approved offline or supervised tool and fictional data. Keep work private, respect media permissions and check accessibility. Paper traces support understanding but do not replace running, saving and testing a real project. Do not enter passwords, addresses or other personal details into exercises.
Open your writing and drawing pad
Write, draw or show your working. Use a mouse, pen or finger. This pad is not a submitted answer.
Not saved to your account. Download your drawing as PNG and your typed notes as TXT before leaving or refreshing. They are separate files. Do not enter private information.
Open a picture saved on this device to draw on it again. Opening replaces the drawing, but Undo can restore it. PNG only, up to 4 MB and 4096 × 4096 pixels. The picture stays in this browser; it is not uploaded. Paper lines in a saved picture become part of that picture.
Clear the drawing? Your typed notes will stay. You can undo this action.
Your pad is empty.
Open a UTF-8 TXT file from this device, up to 40 KB and 10,000 characters. It stays in this browser. Opening can be undone until you type again. Downloads keep a new copy; they do not change the file you opened.
Replace the notes on this page with the opened file? Download the current notes first if you want to keep them.
Typed notes are not submitted answers.
Check a calculation · Year 5 onward
Use this only when your teacher or adult allows a calculator for the task. Show your thinking first. It does not replace mental or written arithmetic and does not mark your lesson answer.
Practice this lesson
Lesson resources
Browse the available practice activities and worksheets for this lesson.
Your progress