Microsoft Excel Formatting Quiz

Which menu groups are commonly used for formatting data in Microsoft Excel?

• Data and Review

• Font and Alignment

• View and Developer

• Insert and Page Layout

What is the shortcut for applying bold to the text in Excel?

• Ctrl B

• Ctrl U

• Ctrl A

• Ctrl I

Which option is used to fill the cell with color in Excel?

• Alignment

• Borders

• Font Color

• Fill Color

What does the 'merge and center' option do in Excel?

• Split a cell into two cells

• Merge and align cells to the right

• Center the text in a cell

• Merge two cells into a single cell

Which option is used to align the text vertically to the center in Excel?

• Justify

• Bottom Alignment

• Middle Alignment

• Top Alignment

What does the 'wrap text' feature do in Excel?

• Wrap the text in a cell to the right

• Wrap the text in a cell to fit the cell size

• Wrap the text in a cell to the left

• Wrap the text in a cell to the top

Which option is used to increase the font size in Excel?

• Font Size

• Increase Font

• Font Enlarge

• Font Growth

What does the 'indentation' option do in Excel?

• Change the font color

• Change the font style

• Move the text farther within the cell

• Increase the cell size

Which option is used to underline the text in Excel?

• Ctrl U

• Ctrl A

• Ctrl I

• Ctrl B

What does the 'orientation' option do in Excel?

• Change the font size

• Change the font style

• Change the font color

• Orient the text within the cell