Cell Formatting Quiz

What is the purpose of the Format Painter in Microsoft Office applications?

• To copy cell formatting

• To delete cell borders

• To copy cell content

• To change cell font

Which of the following is not a font style?

• Underline

• Regular

• Bold

• Italic

What does the Fill Color button do in Microsoft Excel?

• Adds a fill color to a cell

• Removes fill color from a cell

• Changes font color

• Adds borders to a cell

What is the purpose of the Wrap Text feature in Excel?

• Changes the orientation of text

• Enables text to continue on the same line

• Adds a space between the left margin and text

• Creates new lines as more text is added

What does the Merge & Center option do in Excel?

• Divides a merged cell back into individual cells

• Merges selected cells without centering the content

• Merges selected cells horizontally but keeps each row separate

• Merges selected cells and centers the information horizontally

What does the Increase Decimal button do in Excel?

• Automatically formats the cell as currency

• Increases the number of decimal places

• Formats the cell as a percent

• Decreases the number of decimal places

What are Cell Styles in Excel used for?

• To apply preset formatting options to cells

• To resolve column width errors

• To remove all formatting from the selected cells

• To adjust row height or column width

What does the Row Height feature in Excel allow you to do?

• Increase the column width

• Adjust row height to match the data in the selected cell

• Define the row height in points

• Define the row height in pixels

What does the Clear Formats button do in Excel?

• Removes all formatting from the selected cells

• Adds a fill color to a cell

• Merges selected cells and centers the information horizontally

• Increases the number of decimal places

What does the AutoFit tool in Excel do?

• Merges selected cells and centers the information horizontally

• Adds a fill color to a cell

• Increases the number of decimal places

• Automatically adjusts row height or column width to match the data in the selected cell