Exam 2: Microsoft Excel Basics

When you create a PivotChart with worksheet data, a ____ is created at the same time.

The Watch Window remains open while the workbook is open.

To add password protection to a worksheet, the ____ dialog box is used.

Each PivotChart type (with the exception of pie charts) typically has ____.

Excel displays a(n) ____ icon next to the cell with an error status.

Explain what the signature line is and why it is useful.

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?

Clicking selections on the ____ lets you filter your data in a PivotTable.

When you use Goal Seek, it focuses on several cells of data.

To open the Scenario Manager dialog box, click the ____ button arrow in the Data Tools group on the Data tab, and then click Scenario Manager.

You can have the high, low, first, and last points on a sparkline display with ____________________.

AutoFilters are automatically added to the data when you format data as a table.

Press the ____ keys to apply underlining.

You select a named range by clicking the ____ down arrow and then selecting the named range.

Each formula begins with a quotation mark (").

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

To remove AutoFilters from a table, select the row with the AutoFilters, click the Sort & Filter button in the ____ group, and then click the Filter option to remove the filters.