Quiz for Lesson 5

April 2, 2025 by matthew531@msn.com

Understanding Number format in Excel

1. Where can you find built-in number formats in Excel?

A) Home tab → Number Format menu

B) View tab → Layout

C) Data tab → Format Values

2. What format does Excel apply to cells by default?

A) Text

B) General

C) Currency

3. Which area in Excel does not support the use of number formats?

A) Charts

B) Pivot tables

C) Images

4. What keyboard shortcut opens the Format Cells dialog box?

A) Ctrl+F

B) Ctrl+Shift+M

C) Ctrl+1

5. Which of the following is not a standard number format category in Excel?

A) Font

B) Percentage

C) Currency

6. In Excel, what happens if you type "5%" into a cell?

A) Excel treats it as text

B) Excel changes the format to Percentage

C) Excel converts it to currency

7. What is the main purpose of custom number formats in Excel?

A) To change the actual value in a cell

B) To make charts more colorful

C) To control how numbers are displayed without changing the actual data

8. Which of the following is an example of a custom number format code that displays only the month name?

A) Mmmm

B) Dddd

C) Yyyy

Your score is

Categories Excel