Excel Chapter 7 Intro To Business

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are: A. Field buttons B. Slicer headers C. Quick Explore

A

One possible source of data for a PivotTable is a(n): A. Access database file B. PowerPoint presentation file C. Word template file

A

PivotTable field names are formed from the source data's: A. column titles B. row titles C. sheet tab names

A

The ____________ button removes a filter from a slicer. A. Clear Filter B. Remove Slicer C. Slicer Header

A

The ____________ is a report in a workbook that is graphically represented in a PivotChart. A. Associated PivotTable B. PivotChart Report C. Report Filter

A

The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the: A. FILTERS area B. ROWS area C. VALUES area

A

To import data from Access into an Excel Data Model, use the __________ command. A. Get External Data B. Get Data Model C. Open Relationship

A

To prevent a user from making changes to an Excel worksheet, use the ___________ command so that the worksheet is not visible. A. Hide B. Protect C. Conceal

A

A ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart. A. Associated PivotTable B. PivotChart C. Table

B

Slicers are used to: A. apply labels to data B. filter data C. sort data

B

A(n) __________ chart illustrates the relationship of each part to a whole. A. column B. area C. pie

C

Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the ___________. A. Associated Reports B. Business Intelligence C. Data Model

C

The area in the layout section of the PivotTable Fields pane where data is summarized is the: A. COLUMNS area B. ROWS area C. VALUES area

C

The data for a PivotTable should be in the format of a: A. chart B. file C. list

C

To work with multiple tables in Excel, a __________ must be created between the tables. A. Data Model B. PivotChart C. relationship

C