0
0
Figmabi_tool~10 mins

Grid styles in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This data shows items with their prices and quantities in a simple table.

CellValue
A1Item
B1Price
C1Quantity
A2Pen
B21.50
C210
A3Notebook
B33.00
C35
A4Eraser
B40.50
C420
Formula Trace
Total Cost = Price * Quantity
Step 1: Price in B2 * Quantity in C2
Step 2: Price in B3 * Quantity in C3
Step 3: Price in B4 * Quantity in C4
Cell Reference Map
    A       B       C
1 | Item  | Price | Quantity
2 | Pen   | 1.50  | 10
3 | Notebook | 3.00 | 5
4 | Eraser | 0.50  | 20
Cells B2, C2; B3, C3; B4, C4 are referenced to calculate total cost per item.
Result
    A       B       C       D
1 | Item  | Price | Quantity | Total Cost
2 | Pen   | 1.50  | 10       | 15.00
3 | Notebook | 3.00 | 5       | 15.00
4 | Eraser | 0.50  | 20       | 10.00
The Total Cost column shows the result of multiplying Price by Quantity for each item.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the total cost for the Notebook?
A15.00
B8.00
C3.00
D5.00
Key Result
Multiply Price by Quantity to get Total Cost per item.