Microsoft Excel Quiz 5

What is the shortcut key to format cells in Microsoft Excel?

• Alt + F4

• Ctrl + 1

• Shift + Delete

• Ctrl + A

Which option in the 'Format Cells' dialog box is used to change the font color?

• Size

• Border

• Font

• Alignment

What is the purpose of the 'Merge & Center' option in Excel?

• To delete the selected cells

• To split the selected cells into multiple smaller cells

• To combine and center the selected cells into one larger cell.

• To change the font style of the selected cells

How can you apply a currency format to a cell in Excel?

• Right-click on the cell and select 'Currency'

• Select the cell or range of cells, then choose 'Currency' from the 'Number Format' drop-down menu.

• Use the 'Bold' formatting option

• Type the currency symbol directly into the cell

Which option is used to add borders to cells in Excel?

• Lines

• Frames

• Outlines

• Borders

What is the shortcut key to apply bold formatting to the selected text in Excel?

• Shift + B

• Ctrl + B

• Alt + B

• Ctrl + X

What is the purpose of the 'Wrap Text' option in Excel?

• To insert a new row

• To wrap the text within a cell

• To delete a column

• To change the font style

How can you apply a date format to a cell in Excel?

• By clicking on the cell and typing the date format directly

• By using the 'Insert' tab and selecting 'Date Format'

• By selecting the cell or range of cells, then choosing the desired date format from the 'Number' group in the 'Home' tab.

• By right-clicking on the cell and choosing 'Date Format'

Which option is used to apply a percentage format to a cell in Excel?

• Option A: Number Format drop-down menu

• Option B: Bold button

• Option C: Text Alignment menu

• Option D: Font Color drop-down menu

What is the purpose of the 'Clear' option in Excel?

• To remove contents, formatting, or comments from selected cells.

• To change the font style of selected cells

• To merge selected cells together

• To add more contents to selected cells