Scenario Manager in Excel - Cell-by-Cell Formula Trace

Sample Data

This data shows a simple sales calculation with Price in A2, Quantity in B2, and Total Sales calculated in C2.

Cell	Value
A1	Price
B1	Quantity
C1	Total Sales
A2	10
B2	100
C2	=A2*B2

Formula Trace

=A2*B2

Step 1: A2

Step 2: B2

Step 3: 10 * 100

Cell Reference Map

     A      B      C
1 | Price | Quantity | Total Sales
2 |  10   |   100   |  =A2*B2  

The formula in C2 references cells A2 (Price) and B2 (Quantity) to calculate Total Sales.

Result

     A      B      C
1 | Price | Quantity | Total Sales
2 |  10   |   100   |   1000   

The Total Sales cell (C2) shows the result 1000, which is the product of Price and Quantity.

Sheet Trace Quiz - 3 Questions

What value does the formula in C2 use from cell A2?

A 10

B 100

C 1000

D 110

Key Result

Multiplying two cell values to calculate a product (e.g., =A2*B2).