Interface navigation (toolbar, formula bar, sheet tabs) in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This sheet lists fruits with their quantities and prices. It is used to demonstrate interface navigation elements like toolbar, formula bar, and sheet tabs.

Cell	Value
A1	Item
B1	Quantity
C1	Price
A2	Apples
B2	10
C2	0.5
A3	Bananas
B3	5
C3	0.3
A4	Cherries
B4	20
C4	1.2

Formula Trace

=B2*C2

Step 1: B2

Step 2: C2

Step 3: 10 * 0.5

Cell Reference Map

    A       B       C
1 | Item  | Quantity | Price  |
2 | Apples|   10    |  0.5   | <-- formula uses B2 and C2
3 | Bananas|   5    |  0.3   |
4 | Cherries| 20    |  1.2   |

The formula references cells B2 and C2 to calculate total cost for Apples.

Result

    A       B       C       D
1 | Item  | Quantity | Price  | Total Cost |
2 | Apples|   10    |  0.5   |     5      |
3 | Bananas|   5    |  0.3   |            |
4 | Cherries| 20    |  1.2   |            |

The formula in D2 calculates total cost for Apples by multiplying quantity and price, showing 5.

Sheet Trace Quiz - 3 Questions

Which cells does the formula =B2*C2 use?

A A1 and C1

B A2 and B2

C B2 and C2

D B3 and C3

Key Result

Multiplying two cell values to calculate total cost (quantity * price).