Calculate a Formula from Referenced Cells

Supplied materials

• Paper and pencil; answers may also be spoken or typed.
• All cases, labels, numbers and rules are supplied on this page. No real account, private information or purchase is needed.

Learn the idea

A formula uses values from named cells. The expression equals B2 plus B3 adds those cell values, not their row numbers or addresses. A formula’s result changes when a referenced value changes. Our paper sheet gives all values; no spreadsheet app is required.

Substitute the stated cell values into the formula and then calculate. Do not add the row numbers 2 and 3 in place of the cell contents.

Use this supplied case: Sheet: B2=6, B3=4. Formula result for =B2+B3? Use the details in this example. Say which detail helped you choose. This pretend example does not tell us how every real system works.

1. Follow the worked example one step at a time. Say or draw what happens.
2. Substitute the stated cell values into the formula and then calculate.
3. Say which detail makes the example answer fit. Pick another answer and say why it does not fit.
4. Try the question and practice questions. Read the rule again if your answer does not match the explanation.

Check your reasoning

Your answer is temporary and is not saved to an account. Download your current answer before leaving or reloading. Written work on paper or in another app stays in your own file.

Take it further

New values: B2=11, B3=6. Expected:=B2+B3 returns 17. Changing B3 to 8 changes the result to 19.

Nothing here is saved to an account or sent to a teacher. The answer download includes your current choice and any checked feedback. It does not include choices from the separate More practice section. Download that section separately.