Critical Thinking Questions Case 5-1 Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.
A) apply the built-in format or style that he likes the best; it is impossible to create or modify number formats
B) create and assign a custom format code using the Format Code category in the Number tab in the Create Code dialog box
C) create and assign a custom format code using the Custom category in the Number tab in the Format Cells dialog box
D) apply a different theme to the worksheet

Question

Quizplus · Accepted Answer

Creating and assigning a custom format code using the Custom category in the Number tab in the Format Cells dialog box will allow Louie to format cells containing numbers and calculated values in a special way that cannot be achieved with built-in formats or styles. Creating a custom format code in the Format Cells dialog box gives Louie more flexibility and control over the specific formatting he wants to apply. The other options mentioned do not address Louie's need for special formatting.

Critical Thinking Questions Case 5-1 Louie Is Designing a Complex