0
0
Figmabi_tool~10 mins

Figma Community exploration - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows popular Figma Community plugins with their download counts and user ratings.

CellValue
A1Plugin Name
B1Downloads
C1Rating
A2Color Picker
B215000
C24.8
A3Icon Set
B312000
C34.5
A4Wireframe Kit
B418000
C44.7
A5Chart Maker
B59000
C54.6
Formula Trace
AVERAGE(B2:B5)
Step 1: B2 + B3 + B4 + B5
Step 2: 15000 + 12000 + 18000 + 9000
Step 3: 54000 / 4
Cell Reference Map
    A           B           C
1 |Plugin Name|Downloads  |Rating  |
2 |Color Picker| 15000  | 4.8    |
3 |Icon Set   | 12000  | 4.5    |
4 |Wireframe Kit|18000  | 4.7    |
5 |Chart Maker| 9000   | 4.6    |
The formula references the Downloads column cells B2 to B5 to calculate the average downloads.
Result
    A           B           C           D
1 |Plugin Name|Downloads  |Rating  |Average Downloads|
2 |Color Picker| 15000  | 4.8    |               |
3 |Icon Set   | 12000  | 4.5    |               |
4 |Wireframe Kit|18000  | 4.7    |               |
5 |Chart Maker| 9000   | 4.6    |           13500|
The average downloads of 13500 is shown in cell D5, summarizing the typical popularity of these plugins.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the total number of downloads summed in the formula?
A54000
B45000
C60000
D13500
Key Result
AVERAGE(range) calculates the mean of all numeric values in the specified cell range.