Quiz › Formatting › Number formats
Number formats: Excel Quiz
5 quick questions. Pick an answer to see if you are right.
- A1 has 0.5. You format it as Percentage. What does the cell show?
- A. 50%
- B. 500%
- C. 5%
- D. 0.5%
Show the answer
A — 50%. 0.5 is one half, which is 50%. - A1 has 1234.5. You format it with a comma and 2 decimals. What does the cell show?
- A. 12,34.50
- B. 1,234.50
- C. 1,234.5
- D. 1234.5
Show the answer
B — 1,234.50. The comma marks thousands and 2 decimals adds the last 0. - A1 has 5. You give it the custom format 000. What does the cell show?
- A. 5.00
- B. 5
- C. 500
- D. 005
Show the answer
D — 005. 000 means always show 3 digits, so 5 shows as 005. - A1 shows 50% after formatting. What will this formula return?
=A1*200- A. 200
- B. 50
- C. 10000
- D. 100
Show the answer
D — 100. 50% is really 0.5. Then 0.5*200 is 100. - A1 has 2.567 but shows 2.6 (1 decimal). What will this formula return?
=A1*2- A. 5.1
- B. 5
- C. 5.134
- D. 5.2
Show the answer
C — 5.134. Formatting changes the look, not the number. 2.567*2 is 5.134.
Want to learn this? Read the Formatting lessons →
← More Formatting topics · All quiz categories
