Which Excel group allows you to format numbers as currency, date, or percentage?
Analysis & Theory
The **Number** group on the **Home** tab provides tools to format numbers in various ways like currency, date, and percentage.
Which of the following formats will display 0.75 as 75%?
Analysis & Theory
`Percentage` format converts decimals into percentages (0.75 becomes 75%).
How can you apply a **Currency** format to a number in Excel?
A
Click the $ icon in the Number group
C
Click the Font Color button
D
Use Conditional Formatting
Analysis & Theory
Clicking the `$` icon in the **Number** group applies **Currency** format with the local currency symbol.
Which number format displays numbers **without decimal places** by default?
Analysis & Theory
`General` format displays numbers as-is and may not show decimals unless needed.
What does the **Increase Decimal** button do?
B
Shows more digits after the decimal point
Analysis & Theory
`Increase Decimal` displays more digits **after the decimal point** for greater precision.
What is the result of applying the **Date** format to a number like `45000`?
B
It will convert to a fraction
C
It will show a calendar popup
D
It will display as a date based on Excel's date system
Analysis & Theory
Excel stores dates as serial numbers. `45000` would be interpreted as a date like `2012-12-16`.
Which format type is used to show numbers like 3/4 or 1/2 in Excel?
Analysis & Theory
`Fraction` format displays numbers as **fractions** rather than decimals.
How can you quickly format a number as a **comma-separated value** (e.g., 1,000)?
A
Click Comma Style (,) button in Number group
Analysis & Theory
`Comma Style` adds **thousand separators** to large numbers.
Which format treats a number as plain text, preventing calculations?
Analysis & Theory
`Text` format stores numbers as **plain text**, so Excel will not evaluate them in formulas.
What does the **Decrease Decimal** button do?
A
Converts numbers to whole numbers
B
Reduces decimal digits shown without changing the actual value
Analysis & Theory
`Decrease Decimal` shortens how many digits appear **after the decimal point** but doesn't alter the value.