Why reference types matter in Excel - Formula Trace Breakdown

Sample Data

This data shows two columns of numbers. Column A has 10, 20, 30 and Column B has 5, 15, 25. Column C is empty and will be used for formulas.

Cell	Value
A1	10
A2	20
A3	30
B1	5
B2	15
B3	25
C1
C2
C3

Formula Trace

=A1+B1

Step 1: A1

Step 2: B1

Step 3: 10 + 5

Cell Reference Map

    A     B     C
1 | 10 -> 5 |     |
2 | 20    15 |     |
3 | 30    25 |     |

The formula in C1 references cells A1 and B1. The arrows show the flow of values from A1 and B1 into the formula.

Result

    A     B     C
1 | 10 |  5 | 15 |
2 | 20 | 15 |    |
3 | 30 | 25 |    |

The formula in C1 adds A1 and B1, showing 15 as the result. Other cells in column C are empty.

Sheet Trace Quiz - 3 Questions

What value does the formula =A1+B1 in cell C1 produce?

A 5

B 30

C 15

D 10

Key Result

Relative references adjust when copied; absolute references stay fixed.