Exam 2: Microsoft Excel Basics

After you create the PivotTable, you can continue to rearrange the data.

To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. The pointer changes from a white cross to a ____ arrow. To move the selected cells, drag them to a new location.

The Share Workbook button is found on the ____ tab.

When you remove the password protection, you are ____ the workbook.

The ____________________ feature is useful if you want to confirm that the cells you intended to use in the function are in fact used by the function or if the result of a function does not look correct.

Case EX 12-2 Joey has created a PivotTable that contains the financial data for his restaurant. If Joey wants to change the location of rows and columns in the PivotTable, he needs to use the ____ dialog box.

The What-If Analysis arrow button is found on the ____ tab.

Choosing the Information style in the Error Alert tab of the Data Validation dialog box allows data to be entered but simply displays an information box with a message that the data entered is invalid.

You can change the active worksheet in a workbook to next worksheet by pressing the ____+Page Down keys.

Using a(n) ____ lets you view two sets of data at once for convenience.

A PivotTable must be placed on the same worksheet as the data used to create it.

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

Each field (column of data) in a PivotTable can have its own PivotChart to filter data for the column.

In the outline format, you can click the plus (+) button to collapse or hide the data.

After you select a format for your table, the Table Format tab appears on the Ribbon.

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.

To import text data, click the ____ tab, and then click the From Text button.