Cell Formatting Tutorial Quiz

What is the first step in creating a table with borders in a spreadsheet?

• Underline the columns and add borders

• Highlight the cells and click 'Add Table'

• Select the cells and choose a line color

• Choose a line style and click 'OK'

How can you quickly format a cell to display currency?

• Use the keyboard shortcut Ctrl + Shift + 4

• Click the 'Date' button

• Right-click and select 'Format Cells'

• Type the currency symbol manually

What is the keyboard shortcut to format a cell as currency?

• Ctrl + Shift + 3

• Ctrl + Shift + 6

• Ctrl + Shift + 5

• Ctrl + Shift + 4

Which button would you use to change a cell's format to a date?

• The button with a percentage sign

• The button with a clock icon

• The button with a calendar icon

• The button with a currency symbol

What happens if a cell is too small to display its content?

• The cell turns red

• The cell displays hashes

• The content is cut off

• The content is automatically resized

What formula would you use to calculate the percentage of actual sales compared to estimated sales?

• Actual sales minus estimated sales

• Actual sales divided by estimated sales

• Estimated sales divided by actual sales

• Actual sales plus estimated sales

How can you format negative numbers to appear in red?

• Right-click, select 'Format Cells', and choose red for negative numbers

• Use the 'Conditional Formatting' option

• Type the numbers in red manually

• Select 'Red Text' from the color menu

What is the result of dividing 1 by 3 and rounding to two decimal places?

• 0.33

• 0.333

• 0.3

• 0.3333

Which button allows you to increase the number of decimal places displayed?

• The button with a minus sign

• The button with a calendar icon

• The button with a plus sign

• The button with a percentage sign

How can you ensure that a number is displayed with two decimal places?

• Right-click and select 'Format Cells', then set decimal places

• Type the number with two decimal places manually

• Use the 'Decimal' button

• Use the 'Currency' button