MO-211 practice question 7 of 35
How can you apply a custom number format to a cell in Excel?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
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.
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.
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.
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
