Microsoft Excel 2016 Formatting Cells and Ranges Quiz

Grace wants to insert a single cell or a range of cells in Excel. What command should she use?

• Insert Cells

• Delete Cells

• Format Painter

• Merge Cells

Which alignment option centers the text horizontally in a cell?

• Left Align

• Right Align

• Center

• Justify

What does the Format Painter tool allow you to do in Excel?

• Copy and paste cell contents

• Apply conditional formatting

• Copy formatting attributes and apply them to other cells

• Merge cells

What does the Paste Special option allow you to do in Excel?

• Paste data with special formatting

• Paste formulas and values only

• Paste data with specific operations

• Paste data with conditional formatting

Which command is used to apply cell styles in Excel?

• Format Painter

• Apply Conditional Formatting

• Paste Special

• Apply Cell Styles

What command is used to insert hyperlinks in Excel?

• Insert Hyperlinks

• Delete Hyperlinks

• Format Painter

• Merge Cells

What is the purpose of applying conditional formatting to cells in Excel?

• To change the font and font size of cells

• To apply specific number formats to cells

• To insert and remove hyperlinks in cells

• To highlight cells based on certain criteria

Which command is used to apply a background color to cells in Excel?

• Fill Color

• Font Color

• Format Painter

• Merge Cells

What does it mean to wrap text in a cell in Excel?

• To apply a border around the cell

• To merge multiple cells into one

• To automatically adjust the row height to fit the text

• To align the text vertically within the cell

What does it mean to merge cells in Excel?

• To apply a border around the cells

• To combine multiple cells into one

• To automatically adjust the column width to fit the text

• To align the text horizontally within the cells