You need to apply the same font to an entire workbook at one time. What should you do?

Question

Options

• ASelect Format on the menu, and then select Field Labels
• BSelect Format on the menu, and then select Workbook
• CSelect Help on the menu, and then select Settings and Performance
• DSelect Format on the menu, and then select Title and Caption

• A
  7% (5)
• B
  88% (60)
• C
  1% (1)
• D
  3% (2)

Explanation

Selecting Format > Workbook is correct because workbook-level formatting settings apply globally across all sheets and elements, making it the appropriate scope for a font change that affects everything at once.

Why the distractors are wrong:

• A (Format > Field Labels) targets only data field label text, not the entire workbook.
• C (Help > Settings and Performance) is in the wrong menu entirely - Help deals with documentation and diagnostics, not visual formatting.
• D (Format > Title and Caption) scopes the change only to title and caption elements, leaving the rest of the workbook unaffected.

Memory tip: Think scope - Workbook is the largest container, so when you need a change that spans everything, look for the option that matches that top-level scope. "Workbook = whole book, one font to rule them all."

No community discussion yet for this question.