Excel 2016 MOAC Lesson 06

Which of the following commands is used to insert a cell into a worksheet?

• The Insert command in the Cells group on the Home tab
• The Format command in the Cells group on the Home tab
• The Format Painter command in the Clipboard group on the Home tab
• The Format command in the shortcut menu when you right-click a cell

You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used?

• Center

• Middle Align

• Justify

• Top Align

Which of the following can you not copy using Format Painter?

• Font color

• Bold

• Font size

• Cell content

You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

• Apply another style to the cell.
• Use the Undo command.
• Clear the cell’s content
• Apply the Normal style to the cell

Which of the following is not useful for changing the font size?

• Font Size drop-down list

• Increase Font Size button

• Decrease Font Size button

• Increase indent button

When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.

• true

• false

When you point to defined styles in the Cell Styles gallery, you can see the formatting that will be used when you apply each style.

• true

• false

Style attributes include fonts and font sizes, number formats, and borders and shading.

• true

• false

You cannot split a single worksheet cell that has not been merged.

• true

• false

After you select a color and apply it to a cell's background, the Fill Color button takes on that color.

• true

• false