Font selection and pairing in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows font names, their styles, and suggested usage for a BI dashboard design.

Cell	Value
A1	Font Name
B1	Font Style
C1	Usage
A2	Roboto
B2	Regular
C2	Body Text
A3	Roboto
B3	Bold
C3	Headings
A4	Montserrat
B4	Regular
C4	Subheadings
A5	Open Sans
B5	Italic
C5	Quotes

Formula Trace

SELECT fonts WHERE usage IN ('Headings', 'Body Text')

Step 1: Check each row's Usage column for 'Headings' or 'Body Text'

Step 2: Extract Font Name and Font Style from matched rows

Step 3: Pair fonts for dashboard text elements

Cell Reference Map

   A          B           C
1 |Font Name |Font Style |Usage
2 |Roboto    |Regular    |Body Text
3 |Roboto    |Bold       |Headings
4 |Montserrat|Regular    |Subheadings
5 |Open Sans |Italic     |Quotes

The formula references the Usage column (C2:C5) to filter fonts for headings and body text.

Result

   A          B           C
1 |Font Name |Font Style |Usage
2 |Roboto    |Regular    |Body Text
3 |Roboto    |Bold       |Headings

Selected font pairing for dashboard:
- Body Text: Roboto Regular
- Headings: Roboto Bold

The result shows the selected font pairing for the dashboard's body text and headings.

Sheet Trace Quiz - 3 Questions

Which font style is chosen for the dashboard headings?

A Roboto Regular

B Montserrat Regular

C Roboto Bold

D Open Sans Italic

Key Result

Filter rows by Usage column to select fonts for headings and body text.

Practice

1. Which of the following is the best reason to choose a clear, simple font for your BI report body text?

easy

A. It improves readability and helps users understand data easily.

B. It makes the report look more colorful and fun.

C. It allows you to use more fonts on the same page.

D. It reduces the file size of the report.

Solution

1. Step 1: Understand the purpose of body text fonts

   Body text should be easy to read so users can quickly grasp information.

2. Step 2: Evaluate the options

   Only It improves readability and helps users understand data easily. focuses on readability and user understanding, which is key for BI reports.

3. Final Answer:

   It improves readability and helps users understand data easily. -> Option A

4. Quick Check:

   Clear fonts improve readability [OK]

Hint: Choose fonts that make reading easy and clear [OK]

Common Mistakes:

• Choosing fonts just because they look colorful
• Using many different fonts in one report
• Ignoring readability for style

2. Which font pairing follows best practice for BI report headings and body text?

easy

A. Heading: Times New Roman, Body: Times New Roman Italic

B. Heading: Comic Sans, Body: Papyrus

C. Heading: Arial Bold, Body: Arial Regular

D. Heading: Brush Script, Body: Courier New

Solution

1. Step 1: Identify font pairing principles

   Good pairing uses a clear, professional heading font with a matching, readable body font.

2. Step 2: Analyze each option

   Heading: Arial Bold, Body: Arial Regular uses Arial Bold and Regular, a clean and consistent pairing suitable for BI reports.

3. Final Answer:

   Heading: Arial Bold, Body: Arial Regular -> Option C

4. Quick Check:

   Consistent, clear font pairing = Heading: Arial Bold, Body: Arial Regular [OK]

Hint: Pair bold heading with regular body font from same family [OK]

Common Mistakes:

• Using decorative fonts that reduce clarity
• Mixing unrelated font styles
• Choosing fonts that clash visually

3. You have a BI dashboard with headings in 'Roboto Bold' and body text in 'Roboto Regular'. What is the expected user experience?

medium

A. Users easily distinguish headings from body text with clear readability.

B. The report looks unprofessional because fonts are too similar.

C. Users find the report confusing due to font mismatch.

D. The body text is hard to read because Roboto is a decorative font.

Solution

1. Step 1: Understand font family usage

   Using the same font family with different weights helps separate headings and body clearly.

2. Step 2: Evaluate user experience

   Roboto is a clean, readable font; bold headings stand out while regular body text remains clear.

3. Final Answer:

   Users easily distinguish headings from body text with clear readability. -> Option A

4. Quick Check:

   Same font family with weight difference improves clarity [OK]

Hint: Use same font family with different weights for clarity [OK]

Common Mistakes:

• Thinking similar fonts cause confusion
• Assuming decorative fonts improve readability
• Ignoring font weight differences

4. A BI report uses 'Georgia Italic' for headings and 'Arial Black' for body text. What is the main issue here?

medium

A. The fonts are too similar, causing confusion.

B. Arial Black is not a valid font.

C. Italic headings are always hard to read.

D. The body font is too heavy and reduces readability.

Solution

1. Step 1: Analyze font styles for readability

   Arial Black is very heavy and bold, which can overwhelm body text readability.

2. Step 2: Consider heading font style

   Georgia Italic is readable for headings, but pairing with heavy body font reduces clarity.

3. Final Answer:

   The body font is too heavy and reduces readability. -> Option D

4. Quick Check:

   Heavy body fonts reduce readability [OK]

Hint: Avoid heavy fonts for body text to keep it readable [OK]

Common Mistakes:

• Assuming italic is always bad for headings
• Ignoring font weight impact on body text
• Thinking font validity is the issue

5. You want to create a BI report with a professional look. Which font pairing strategy should you use to balance clarity and style?

hard

A. Use two decorative fonts to make the report stand out.

B. Use a sans-serif font like 'Open Sans' for body and a serif font like 'Merriweather' for headings.

C. Use the same font for headings and body with no weight difference.

D. Use a script font for headings and a monospace font for body.

Solution

1. Step 1: Understand font pairing principles

   Combining a clean sans-serif body font with a distinctive serif heading font creates balance and professionalism.

2. Step 2: Evaluate options for clarity and style

   Use a sans-serif font like 'Open Sans' for body and a serif font like 'Merriweather' for headings. uses this proven pairing, while others reduce readability or look unprofessional.

3. Final Answer:

   Use a sans-serif font like 'Open Sans' for body and a serif font like 'Merriweather' for headings. -> Option B

4. Quick Check:

   Sans-serif body + serif heading = professional look [OK]

Hint: Pair sans-serif body with serif heading for style and clarity [OK]

Common Mistakes:

• Using decorative fonts that reduce clarity
• Using identical fonts without weight difference
• Mixing script and monospace fonts in reports