0
0
Excelspreadsheet~10 mins

Excel vs Google Sheets comparison - Formula Comparison Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows products with their price and quantity. We want to calculate the total cost for each product.

CellValue
A1Product
B1Price
C1Quantity
D1Total
A2Apples
B22
C25
A3Bananas
B31
C37
A4Cherries
B43
C42
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 |Apples |   2   |   5    |  =B2*C2
3 |Bananas|   1   |   7    |       
4 |Cherries|  3   |   2    |
Formula in D2 references cells B2 (Price) and C2 (Quantity) to calculate total cost.
Result
    A       B       C       D
1 |Product| Price |Quantity| Total
2 |Apples |   2   |   5    |  10
3 |Bananas|   1   |   7    |    
4 |Cherries|  3   |   2    |
The total cost for Apples is calculated as 10 by multiplying price (2) by quantity (5).
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =B2*C2 calculate?
ASum of price and quantity
BTotal cost for Apples
CDifference between price and quantity
DPrice of Bananas
Key Result
Multiplying price by quantity to get total cost: =B2*C2