Recall & Review
beginner
What is a formula in Excel?
A formula is a set of instructions that tells Excel to perform a calculation automatically using the values in cells.
Click to reveal answer
beginner
How do formulas help save time in spreadsheets?
Formulas automatically update results when input values change, so you don't have to recalculate manually.
Click to reveal answer
beginner
Why do formulas reduce errors compared to manual calculations?
Because formulas use exact cell references and rules, they avoid mistakes that happen when typing numbers or doing math by hand.
Click to reveal answer
beginner
What symbol do formulas in Excel always start with?
Formulas always start with an equal sign (=) to tell Excel to calculate the expression that follows.
Click to reveal answer
beginner
Give a simple example of a formula that adds two cells, A1 and B1.
The formula is =A1+B1. It adds the values in cells A1 and B1 and shows the result automatically.
Click to reveal answer
What does a formula in Excel do?
✗ Incorrect
Formulas perform calculations automatically using the data in cells.
Which symbol must a formula start with in Excel?
✗ Incorrect
Formulas always start with an equal sign (=) to indicate a calculation.
Why do formulas reduce errors compared to manual math?
✗ Incorrect
Formulas use cell references and recalculate automatically, reducing mistakes.
If you change a number in a cell used in a formula, what happens?
✗ Incorrect
Formulas recalculate automatically when referenced cell values change.
Which of these is a simple formula to add cells A1 and B1?
✗ Incorrect
The correct formula syntax to add two cells is =A1+B1.
Explain in your own words why formulas automate calculations in Excel.
Think about what happens when you change numbers in cells used by formulas.
You got /4 concepts.
Describe how starting a formula with '=' helps Excel understand your intention.
Why do you think Excel needs a special symbol at the start?
You got /3 concepts.