MO-211 practice question 7 of 35

How can you apply a custom number format to a cell in Excel?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: Use the “Conditional Formatting” format
B: Use the “Custom” format Correct answer
C: Use the “Number” format
D: Use the “General” format
Correct Answer:
B. Use the “Custom” format
Explanation

To apply a custom number format in Excel, you must use the "Custom" category within the "Format Cells" dialog box. This option allows users to define their own format codes to control how numbers, dates, times, and text are displayed in a cell. This provides maximum flexibility beyond the standard, built-in formats like "Number" or "General." Users can specify elements such as the number of decimal places, leading zeros, color, and specific text characters to appear with the number.

Why Incorrect

A. Use the “Conditional Formatting” format: This feature applies formatting based on rules or criteria that a cell's value must meet, not for applying a static, custom number display format.
C. Use the “Number” format: This is a standard, built-in category for general numeric display with options for decimal places and separators, but it is not for creating user-defined formats.
D. Use the “General” format: This is the default Excel format, which displays numbers as entered without any specific formatting rules applied.

References

1. Microsoft Support. "Create or delete a custom number format." Microsoft Office Support Documentation. Accessed May 20, 2024. In the section "Create a custom number format," Step 3 explicitly states, "In the Category list, click Custom."

2. Microsoft Support. "Format numbers." Microsoft Office Support Documentation. Accessed May 20, 2024. The article details the "Format Cells" dialog box, showing "Custom" as the category for user-defined formats, distinct from "Number" and "General."

3. University of Wisconsin-Madison, Division of Information Technology (DoIT). "Excel: Formatting Numbers." KnowledgeBase. Accessed May 20, 2024. The document guides users to the "Format Cells" dialog box and explains under the "Custom Number Formats" section how to select the "Custom" category to create unique formats.

Scroll to Top