Excel on the web - Cell-by-Cell Formula Trace

Sample Data

This table shows products with their price and quantity. Column D will calculate total cost per product.

Cell	Value
A1	Product
B1	Price
C1	Quantity
D1	Total
A2	Apple
B2	2
C2	5
D2
A3	Banana
B3	1
C3	7
D3

Formula Trace

=B2*C2

Step 1: B2

Step 2: C2

Step 3: 2 * 5

Cell Reference Map

    A       B       C       D
1 |Product| Price |Quantity| Total 
2 | Apple |   2   |   5    |  =B2*C2
3 |Banana |   1   |   7    |       

Formula in D2 uses values from B2 (Price) and C2 (Quantity) to calculate total.

Result

    A       B       C       D
1 |Product| Price |Quantity| Total 
2 | Apple |   2   |   5    |  10   
3 |Banana |   1   |   7    |       

The total cost for Apple is shown as 10 in cell D2 after formula calculation.

Sheet Trace Quiz - 3 Questions

What value does cell B2 hold?

A 5

B 10

C 2

D Apple

Key Result

Multiplying two cell values to calculate total cost (Price * Quantity).