0
0
Figmabi_tool~10 mins

FigJam for brainstorming in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data represents brainstorming ideas with their respective votes collected during a FigJam session.

CellValue
A1Idea
A2Improve customer support
A3Add chatbot feature
A4Create FAQ page
B1Votes
B25
B38
B43
Formula Trace
=MAX(B2:B4)
Step 1: B2:B4 values
Step 2: MAX([5, 8, 3])
Cell Reference Map
   A                 B
1 Idea             Votes
2 Improve customer support 5
3 Add chatbot feature     8
4 Create FAQ page          3

Arrows: MAX function references B2, B3, B4
The formula references the votes in cells B2, B3, and B4 to find the highest vote count.
Result
   A                 B       C
1 Idea             Votes   Max Vote
2 Improve customer support 5       8
3 Add chatbot feature     8       
4 Create FAQ page          3
The result of the formula MAX(B2:B4) is 8, shown in cell C2 as the highest vote count from the brainstorming session.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =MAX(B2:B4) calculate?
AThe lowest number of votes
BThe total number of votes
CThe highest number of votes among the ideas
DThe average number of votes
Key Result
MAX(range) returns the highest numeric value within the specified range.