Quiz 2 (Chapter 4,5,6) ADT1A

What is the primary purpose of applying number formats in a spreadsheet?

• To change the font style

• To improve the spreadsheet’s appearance only

• To convert numbers into text

• To specify the type of value in a cell

Which number format would you apply to display values like $10.00 or $35.50?

• Percentage

• Currency

• Text

• Date

What happens if you type "15%" into a spreadsheet cell?

• It remains as text

• It automatically converts to 0.15

• The percentage format is applied

• Nothing changes

Which of the following entries will not be recognized as a date by default?

• 3/15/2024

• March 15

• March 15th

• 10/12

What shortcut key opens the Format Cells dialog box for more number format options?

• Ctrl + F

• Ctrl + Alt + 1

• Ctrl + 1

• Alt + Shift + F

What shortcut key opens the Format Cells dialog box for more number format options?

• Ctrl + F

• Ctrl + Alt + 1

• Ctrl + 1

• Alt + Shift + F

Which number format is ideal for data such as phone numbers or zip codes?

• Currency

• Text

• Percentage

• General

What does the Increase Decimal command do?

• Displays more decimal places without changing the actual value

• Increases the actual value

• Changes the value of the number

• Adds more digits to the number

What happens when you apply percentage formatting to the number 5?

• It becomes 5%

• It becomes 0.05%

• It becomes 500%

• It stays the same

How can you apply a number format to an entire column at once?

• Select the whole column and choose a format

• Format each cell one at a time

• Type the format name in the first row

• Use a formula