Exam 2: Microsoft Excel Basics

To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual.

After you sort or filter the data, a graphic, like a ScreenTip, appears when you place your mouse pointer over the Column Labels and Row Labels down arrows.

If the data used to create a PivotTable is changed, click the ____ button to update the PivotTable to reflect this change.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

If a cell is not wide enough to display all the cell's contents, extra text extends into the next cells if there is room.

The formulas replace the formula results in the worksheet. If a cell does not contain a formula, the cell appears shaded out.

When an item is highlighted in the ____, only the data for that item is displayed.

As you are typing a range name into a formula, ____.

Sparklines are displayed ____.

When the Subtotal function is used by clicking the Subtotal button on the Data tab, data is summed within the data range to give subtotals and a grand total.

The selection is the body of numbers the statistics will describe.

If you select more than one row or column, the same number of rows or columns you selected is inserted in the worksheet.

Spaces can be used to separate words in macro names.

You enable the Share Workbook feature using the ____________________ dialog box.

To print all of the worksheets in the workbook, click Print Entire Workbook print option.

You create a button by first choosing the ____________________ form control and then drawing the button where you want it to appear in the worksheet.

The Sort button is found on the ____ tab on the Ribbon.

Excel refers to the row format as ____________________ rows.

A ____ border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range.