Google Sheets: Understanding Number Formats Quiz

What is the purpose of using number formats in Google Sheets?

• To tell the spreadsheet what type of data is in a cell

• To make the spreadsheet colorful

• To increase the size of the spreadsheet

• To add more rows and columns

Which of the following is NOT a type of number format mentioned in the text?

• Currency

• Percentage

• Fraction

• Temperature

What happens if you type a percent sign (%) after a number in Google Sheets?

• The number is converted to a fraction

• The percentage number format is applied automatically

• The number is deleted

• The number is converted to a date

How can you apply number formatting to an entire column?

• By using the 'Insert' menu

• By changing the font size

• By typing the format in the first cell

• By selecting the column letter and applying the desired number formatting

What should you do if you want your data to appear exactly as entered?

• Use the date format

• Use the percentage format

• Use the plain text format

• Use the currency format

What is the result of applying percentage formatting to a cell with a value of 5?

• 500%

• 50%

• 0.05%

• 5%

Which command allows you to control how many decimal places are displayed in a cell?

• Increase/Decrease column width

• Increase/Decrease row height

• Increase/Decrease decimal places

• Increase/Decrease font size

What will happen if you type 'March 15th' into a cell?

• The spreadsheet will apply currency formatting

• The spreadsheet will recognize it as a date

• The spreadsheet will treat it as text

• The spreadsheet will apply percentage formatting

Which of the following is a correct way to enter a date in Google Sheets?

• March 15 2016

• 15th March 2016

• March 15th, 2016

• 15/03/2016

What should you check if Google Sheets does not automatically apply date formatting?

• The size of the text

• The format of the date entered

• The font style

• The color of the cell