Exam 9: Manage Multiple Worksheets

In the ________ method, the mouse is used to move a selected cell or a range of cells to a new location.

Match each feature with its description. -Hide

Match each paste option with its description. -Formulas

The Clear button does NOT have an option for removing all formatting, comments, text, and hyperlinks from a cell.

Right-clicking on a row heading displays ________.

When the date is selected as the Number Category in the Format Cells dialog box, the Sample is actually the preview of the date in the active cell displayed as the option selected.

Match each feature with its description. -Select All Sheets

The number of cells in a selected destination must be the same as the number in the selected source.

Ungroup is an option on the shortcut menu that appears when a(n) ________ is right-clicked.

Selecting the ________ option from the Clear button removes all text, comments, formatting, and hyperlinks from the selected cell(s).

Only visible worksheet tabs can be grouped.

The Show Formulas button is on the ________ tab of the Ribbon.

A gradient color on a worksheet tab indicates that the worksheet is ________.

Hyphen (-) and forward slash (/) behave identically in a date entered into the active cell.

In a formula that includes both multiplication and addition, either can be performed first.

Match each paste option with its description. -Keep Source Column Widths

Using serial numbers to represent dates in an Excel worksheet enables dates to be used in ________.

Content of a cell can be cleared by pressing the ________ key when the cell is active.

The ________ Excel formula accurately displays the use of a cell from another worksheet.

Clicking the Paste arrow opens the ________ gallery.