Excel Quiz 2

When inserting a column into a spreadsheet a column is always placed to the left of the currently selected column.

• True

• False

The difference between the Center button and the Merge & Center button is that the Center button does not merge cells.

• True

• False

When Format Painter is active, how can it be turned off?

• Click the Format Painter button one more time.

• Click the Format Painter button twice.

• Click the Paste button once.

• Click the Format Painter button three times.

What happens when you click the Merge & Center button on a cell that has already been merged? 

• The cells become centered. 

• The cells become unmerged 

• The cells become highlighted 

• The cells become unformatted 

What happens when the Merge and Center button is used?

• Text will wrap around in the cells.

• Formatting in the cells will clear.

• A pattern will be created in the cell.

• A block of cells will be merged into one.

How can you make the Format Painter remain active for multiple successive uses? 

• Double click the Format Painter button.

• Single click the Format Painter button.

• Triple-click the Format Painter button

• No-click is necessary for the Format Painter button

Excel can clear formatting without the data in the cell changing. The Clear button is found on the  _____ tab in the _____ group. The Clear tool will clear formatting, contents, comments, or hyperlinks. 

• Home Tab in the Editing group

• Insert Tab in the Text group.

• Page Layout Tab in the page Setup group

• Home Tab in the Themes group

When typing in a cell, what will pressing Alt+Enter do?

• Create a manual page break within a cell

• Create a manual line break within a cell

• Create a manual line break within a Column 

• Create a manual line break within a row

The Format Cells dialog box can be accessed by clicking the dialog box launcher on the Home Tab from which groups?

• The Clipboard group, the Alignment group, or the Number group 

• The Font group, the Alignment group, or the Number group 

• The Styles group and Cells group

• The Editing group, the Cells group, or the Sensitivity group 

The Formula Bar will show what was originally typed into a cell,

• True

• False