Recall & Review
beginner
What does the equal sign (=) mean at the start of a formula in Excel?
The equal sign (=) tells Excel that what follows is a formula, not just text or a number. It starts the calculation.
Click to reveal answer
beginner
What is a cell reference in Excel formulas?
A cell reference points to a specific cell in the spreadsheet, like A1 or B2. It lets the formula use the value inside that cell.
Click to reveal answer
beginner
How do you write a formula to add the values in cells A1 and B1?
You write: =A1+B1. This adds the numbers in cells A1 and B1.
Click to reveal answer
intermediate
Can a formula use cell references from different sheets?
Yes. You can use a formula like =Sheet2!A1+Sheet3!B2 to add values from different sheets.
Click to reveal answer
beginner
What happens if you type a formula without the equal sign (=) at the start?
Excel treats it as text, not a formula. It won’t calculate anything.
Click to reveal answer
What symbol must you start a formula with in Excel?
✗ Incorrect
Formulas in Excel always start with an equal sign (=) to tell Excel to calculate.
Which of these is a valid cell reference?
✗ Incorrect
Cell references use a letter for the column and a number for the row, like A1.
What does the formula =A1+B1 do?
✗ Incorrect
The plus sign (+) adds the values in cells A1 and B1.
How do you refer to cell A1 on a sheet named 'Data'?
✗ Incorrect
Use an exclamation mark (!) between the sheet name and cell reference.
What happens if you enter A1+B1 without the equal sign?
✗ Incorrect
Without the equal sign, Excel treats the entry as plain text.
Explain why formulas in Excel must start with an equal sign (=).
Think about how Excel knows you want a calculation.
You got /3 concepts.
Describe how to use cell references in a formula to add two numbers from different cells.
Imagine adding prices from two boxes in a store.
You got /4 concepts.