Text decoration and case in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents text strings that will be styled with different text decorations and case transformations.

Cell	Value
A1	hello world
A2	Data Visualization
A3	business intelligence

Formula Trace

UPPER(A1) & " with " & "underline" & " and " & "line-through"

Step 1: UPPER(A1)

Step 2: "HELLO WORLD" & " with "

Step 3: "HELLO WORLD with " & "underline"

Step 4: "HELLO WORLD with underline" & " and "

Step 5: "HELLO WORLD with underline and " & "line-through"

Cell Reference Map

hello world

↓

Data Visualization

↓

business intelligence

Cell A1 is referenced to convert its text to uppercase.

Result

   A                                
1 HELLO WORLD with underline and line-through
2 Data Visualization                 
3 business intelligence             

The final result in cell A1 shows the uppercase text combined with text decoration descriptions.

Sheet Trace Quiz - 3 Questions

What does the function UPPER(A1) do in the formula?

A Converts text in A1 to uppercase

B Adds underline decoration

C Changes text to lowercase

D Removes spaces from text

Key Result

Concatenate uppercase text with text decoration descriptions using & operator