Chapter 7 Excel

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

data visualization

An object such as a chart or map on a Power View sheet is a ____

Add-in

An optional command or feature that is not immediately available and must be installed and/or activated use is a(n)

row labels

By default, when a non-numeric field is added to a Pivot Table, it is placed in the ______area

more than one arrangement

By using a Pivot Table report, you can show the same data in a table in ____

Business Intelligence Tools

Excel includes several ____that can be used to perform data analysis and create sophisticated charts and reports.

field names

Excel uses the column title as the _____for the categories of data

Row labels

In the Pivot Table Field list, you can rearrange existing fields or reposition fields by using which of the following areas at the bottom of the layout section.

column labels

In the Pivot Table field list, you can rearrange existing fields or reposition those fields by using which of the following areas at the bottom of the layout section

Bing

Power View can use the ____ map service if your data contains location information

Pivot Table Styles

Preformatted Pivot Tables that are arranged in a gallery are called ____

field buttons

The Pivot Chart displays ____that you can click to choose a filter and change the data displayed in the chart.

Quick explore

The ___tools allows you to drill down through Pivot Table data with a single click

slicer header

The category of slicer items is indicated by the ____

Power View

The charts and other objects created on a _____worksheet are related and can be cross-filtered

Sum

The default summary function for a data fields containing numbers in an Excel Pivot Table is____

Power View canvas

The part of a Power View worksheet where the data visualization displays is the ____

Switch visualization

To create a column chart visualization on a Power View sheet, first drag the fields to the Fields area, and then click the Column chart arrow in _____

Layout

To format the elements of a Power View object, select the object and then click the _____format tab.

edit cells in the source list and then refresh the Pivot Table

To make changes to Pivot Table data, you must

Values

When a numeric field is added to a Pivot Table, it is placed in the ___area of the Pivot Table field list

Power View Fields pane

When creating a Power View sheet, multiple tables are visible in the ____

Values

Which of the following areas of a Pivot Table field list allows you to display average values

data markers

Which of the following is a bar, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell.

field button

Which of the following is a button that identifies a field in a Pivot Table or Pivot Chart report

Pivot Table report

Which of the following is a report that provides interactive analysis of data, where you can change views of data, see different levels of details, or reorganize the chart layout by dragging fields and showing or hiding items in fields

Pivot Table report

Which of the following is an interactive Excel report that summarizes and analyzes data, such as database records from various sources external to Excel

External data

Which of the following is data that is stored outside of Excel and includes databases created in Access, dbase, SQL server or on a Web server

Summary calculation

Which of the following is the method of summarizing values in the data area of a Pivot Table report by using the values of other cells in the data area

PowerPivot

With ___ you can analyze data from multiple sources, work with multiple data tables, and create relationships between tables

filters

You can limit the display of data to specific information by using___

PowerPivot

You must use _____to create Pivot Tables using the data from multiple, related tables

Power View

_______allows you to create and interact with multiple charts, slicers, and other data visualization in a single sheet

Power View

____is a data visualization tool that can be used to create interactive dashboards and reports

refresh

If you change the underlying data on which a Pivot Table report is based, you must also ___or update the Pivot Table to reflect the new data.

field

In a Pivot Table or Pivot Chart Report, data is derived from a _____in the source data

Pivot Table Style

You can apply a _____to the entire Pivot Table report

combine and compares

A Pivot Table report ____large amounts of data so you can analyze related totals.

Data Model

A ___ is a method of incorporating data from multiple, related tables, into Excel worksheet.

Data Model

A ____can import data from an Excel workbook, from an Access database, or from an external source such as a corporate database, a public data feed, or an analysis service.

X

A field that is being removed from the Pivot Table is indicated by a(n)


Conjuntos de estudio relacionados

F7 Stockholder's Equity, EPS, Statement of Cashflows Becker 2016

View Set

Bronfenbrenner's Bio-Ecological Model of Development Theory

View Set

WOS 1. 1 Życie zbiorowe i jego reguły

View Set

Chapter 7 Drugs for Women's Health Prep U

View Set

Meteorology Test Chapters 4,5,6 & 7

View Set

Routing and Switching Essentials (V6.0) - RSE 6.0 Chapter 8 Exam

View Set