0
0
Figmabi_tool~10 mins

First Figma design - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows simple business metrics: Sales, Costs, and Profit.

CellValue
A1Metric
B1Value
A2Sales
B21500
A3Costs
B3900
A4Profit
B4600
Formula Trace
Profit = Sales - Costs
Step 1: Sales - Costs
Step 2: 1500 - 900
Cell Reference Map
    A       B
1 | Metric | Value
2 | Sales  | 1500  
3 | Costs  | 900   
4 | Profit | 600   

Arrows: Profit (B4) depends on Sales (B2) and Costs (B3)
Profit cell (B4) uses values from Sales (B2) and Costs (B3) to calculate.
Result
    A       B
1 | Metric | Value
2 | Sales  | 1500  
3 | Costs  | 900   
4 | Profit | 600   

Profit is calculated as Sales minus Costs.
The Profit value 600 is shown in cell B4 after calculation.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which cells are used to calculate Profit?
AA4 and B4
BB2 and B3
CA2 and A3
DB1 and A1
Key Result
Profit is calculated by subtracting Costs from Sales (Profit = Sales - Costs).