MyLab IT Excel Chapter 4

¡Supera tus tareas y exámenes ahora con Quizwiz!

Field button

A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.

ROWS area

An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles.

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.

Clear Filter

A button that removes a filter.

Field names

The column titles from source data that form categories of data for a PivotTable.

Field names

The column titles from source data that form the categories of data for a PivotTable.

Layout section

The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.

Source data

Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.

Field buttons

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:

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

C

refresh

The command to update a worksheet to reflect new data.

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

Data Model

A method of incorporating data from multiple, related tables into an Excel worksheet.

Filter

A process by which you can limit the display of data to only specific information.

Quick Explore

A tool that allows you to drill down through PivotTable data with a single click.

PivotTable Fields Pane

A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.

PivotTable Fields pane

A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.

PowerView

Allows you to create and interact with multiple charts, slicers, and other data visualizations in a single worksheet

Quick Explore

Allows you to drill down through PivotTable data with a single click

FILTER area

An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report.

Relationship

An association between tables that share a common field.

Canvas

Area of a Power View worksheet that contains data visualizations.

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

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

column titles

PivotTable field names are formed from the source data's

filter data

Slicers are used to

Associated PivotTable report

The PivotTable report in a workbook that is graphically represented in a PivotChart.

VALUES area

The area in the layout section of the PivotTable Field List where data is summarized is the

FILTER area

The area in the layout section of the PivotTable Field List 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

Refresh

The command to update a worksheet to reflect the new data.

list

The data for a PivotTable should be in the format of a:

Source data

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.

Slicer header

The top of a slicer that indicates the category of the slicer items

Filter

To limit the display of data to only specific information.

Business Intelligence tools

Tools that can be used to perform data analysis and create sophisticated charts and reports.

Business Intelligence Tools

Used to perform data analysis and create sophisticated charts and reports

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

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

Add-ins

Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.

Layout section

The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.

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

Filtering button

A button on a slicer which you use to select the item by which to filter.

PowerPivot

Allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables

PivotTable

An interactive, Excel report that summarizes and analyzes large amounts of data.

Slicer

Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.

Slicer

Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.

PivotChart report

A graphical representation of the data in a PivotTable report.

PivotChart report

A graphical representation of the data in a PivotTable.

PowerPivot

An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.

Power View

An Excel BI tool that allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.

VALUES area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data.

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

B

COLUMNS area

An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.


Conjuntos de estudio relacionados

Managerial Accounting Ch 4 Presentation

View Set

Introduction to College Accounting Chapter #1 (21st edition Heintz | Parry)

View Set

Microbiology Final Exam: principles of disease

View Set

APES: Air Pollution and Climate Change

View Set

Life and Health: Guaranteed Missed Questions

View Set

CompTIA A+ 1101 section 2 networking part 3

View Set