Formula structure (=, cell references) in Excel - Cheat Sheet & Quick Revision

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.

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.

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.

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.

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.

What symbol must you start a formula with in Excel?

A $

B +

C #

D =

Formulas in Excel always start with an equal sign (=) to tell Excel to calculate.

Which of these is a valid cell reference?

A 1A

B AA

C A1

D 1

Cell references use a letter for the column and a number for the row, like A1.

What does the formula =A1+B1 do?

A Adds values in A1 and B1

B Subtracts B1 from A1

C Multiplies A1 and B1

D Divides A1 by B1

The plus sign (+) adds the values in cells A1 and B1.

How do you refer to cell A1 on a sheet named 'Data'?

A Data!A1

B Data:A1

C Data#A1

D Data.A1

Use an exclamation mark (!) between the sheet name and cell reference.

What happens if you enter A1+B1 without the equal sign?

A Excel calculates the sum

B Excel treats it as text

C Excel highlights the cells

D Excel shows an error

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.

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.

Practice

1. What does the = sign at the start of a formula in Excel mean?

easy

A. It marks the cell as text.

B. It highlights the cell.

C. It tells Excel to calculate the formula.

D. It deletes the cell content.

Solution

1. Step 1: Understand the role of = in Excel

   The = sign tells Excel that the following text is a formula to calculate.

2. Step 2: Differentiate from other uses

   Without =, Excel treats input as text or numbers, not formulas.

3. Final Answer:

   It tells Excel to calculate the formula. -> Option C

4. Quick Check:

   = means calculate formula [OK]

Hint: Formulas always start with = to calculate [OK]

Common Mistakes:

• Thinking = is just decoration
• Confusing = with text input
• Assuming = deletes content

2. Which of these is the correct way to write a formula that adds values in cells A1 and B1?

easy

A. =A1 + B1

B. A1 plus B1

C. SUM(A1, B1)

D. A1 + B1

Solution

1. Step 1: Check formula start

   Formulas must start with = to calculate.

2. Step 2: Verify syntax for addition

   =A1 + B1 correctly adds values in A1 and B1.

3. Final Answer:

   =A1 + B1 -> Option A

4. Quick Check:

   Formula starts with = and uses + [OK]

Hint: Start formulas with = and use + for addition [OK]

Common Mistakes:

• Omitting = at start
• Writing text instead of formula
• Using wrong function syntax

3. If cell A1 contains 5 and cell B1 contains 3, what will be the result of the formula =A1*B1?

medium

A. 15

B. 53

C. 8

D. Error

Solution

1. Step 1: Identify values in cells

   A1 = 5 and B1 = 3.

2. Step 2: Calculate multiplication

   Formula =A1*B1 multiplies 5 by 3, result is 15.

3. Final Answer:

   15 -> Option A

4. Quick Check:

   5 * 3 = 15 [OK]

Hint: Multiply values by using * between cell references [OK]

Common Mistakes:

• Adding instead of multiplying
• Concatenating numbers as text
• Forgetting = sign

4. What is wrong with this formula: =A1 + B1 if it shows an error when A1 contains text 'Hello' and B1 contains 10?

medium

A. The formula must start with + instead of =.

B. You cannot add text and numbers directly.

C. Cell references must be lowercase like a1 and b1.

D. The formula should use commas instead of plus sign.

Solution

1. Step 1: Understand data types in cells

   A1 contains text 'Hello', B1 contains number 10.

2. Step 2: Check formula operation

   Adding text and number causes error because Excel cannot sum text with numbers.

3. Final Answer:

   You cannot add text and numbers directly. -> Option B

4. Quick Check:

   Text + number causes error [OK]

Hint: Cannot add text and numbers directly in formulas [OK]

Common Mistakes:

• Starting formula with + instead of =
• Thinking case of cell references matters
• Using wrong operators for addition

5. You want to calculate the total price by multiplying quantity in cell B2 by price per item in cell C2. Which formula correctly does this and updates automatically if values change?

hard

A. =B2+C2

B. B2*C2

C. =SUM(B2,C2)

D. =B2*C2

Solution

1. Step 1: Identify correct formula structure

   Formula must start with = to calculate.

2. Step 2: Use multiplication for total price

   Multiplying quantity and price uses *, so =B2*C2 is correct.

3. Step 3: Confirm automatic update

   Using cell references ensures formula updates when values change.

4. Final Answer:

   =B2*C2 -> Option D

5. Quick Check:

   Formula with = and * updates automatically [OK]

Hint: Use = and * with cell refs for auto-updating multiplication [OK]

Common Mistakes:

• Omitting = sign
• Using SUM instead of multiplication
• Adding instead of multiplying