Lesson 6 Excel

What command 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

Which alignment option should be used to spread text evenly throughout a cell, wrapping automatically and adjusting the row height if necessary?

• Center

• Middle Align

• Justify

• Top Align

What cannot be copied using Format Painter?

• Font color

• Bold

• Font size

• Cell content

What is the least effective way to remove or replace a cell 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

True or False: 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

True or 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

True or False: Style attributes include fonts and font sizes, number formats, and borders and shading.

• True

• False

True or False: You cannot split a single worksheet cell that has not been merged.

• True

• False

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

• True

• False