Deck 9: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Question 1

The ____ value is a number from 0 to 1 that measures the strength of a trend.

A) A-squared
B) P-squared
C) R-squared
D) T-squared

Answer 1

C

Question 2

A ____ is an interactive view of worksheet data.

A) PivotChart report
B) trendline
C) PivotTable report
D) 2-D column chart

Answer 2

C

Question 3

Which of the following is the path to the 'Add Chart Element' button?

A) (CHART TOOLS DESIGN tab | Analysis group)
B) (CHART TOOLS DESIGN tab | Chart Layouts group)
C) (CHART TOOLS FORMAT tab | Analysis group)
D) (CHART TOOLS FORMAT tab | Options group)

Answer 3

B

Question 4

Which of the following is the path to the Report Layout button?

A) (PIVOTTABLE TOOLS LAYOUT tab | Design group)
B) (PIVOTTABLE TOOLS DESIGN tab | Layout group)
C) (PIVOTTABLE TOOLS FORMAT tab | Layout group)
D) (PIVOTTABLE TOOLS DESIGN tab | Theme group)

Question 5

You can filter the PivotTable report shown in the accompanying figure by ____.

A) Total 2014 Sales
B) Department and Style
C) Total 2015 Sales
D) Average 2014 Sales

Question 6

Which of the following is the path to the 'Insert Line Chart' button?

A) (INSERT tab | Charts group)
B) (HOME tab | Charts group)
C) (VIEW tab | Data group)
D) (INSERT tab | Images group)

Question 7

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

A) SlicerChart
B) PivotChart
C) TrendChart
D) 2-D Column chart

Question 8

Which of the following is the path to the Move Chart button?

A) (CHART TOOLS LAYOUT tab | Location group)
B) (CHART TOOLS FORMAT tab | Location group)
C) (CHART TOOLS DESIGN tab | Location group)
D) (CHART TOOLS OPTIONS tab | Location group)

Question 9

In a PivotTable, ____ fields correspond to summary values of original data across categories.

A) category
B) index
C) data
D) summary

Question 10

You can add a trendline to all of the following EXCEPT a(n) ____ chart.

A) inventory
B) pie
C) scatter
D) bubble

Question 11

Which of the following is the path to the PivotTable button?

A) (INSERT tab | Text group)
B) (HOME tab | Analysis group)
C) (INSERT tab | Tables group)
D) (TABLES tab | Analysis group)

Question 12

When creating a PivotTable report, the active cell should be positioned ____.

A) anywhere in the range that contains the data
B) in cell A1
C) anywhere outside the range that contains the data
D) There is no active cell in a PivotTable report.

Question 13

In PivotTables, ____ fields correspond to columns in the original data.

A) row
B) index
C) summary
D) category

Question 14

To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.

A) Subtotal Values By
B) Summarize Values By
C) Total Values By
D) Calculate Values By

Question 15

A ____ is a visual way to show how two variables relate to each other.

A) pivotline
B) guideline
C) timeline
D) trendline

Question 16

A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.

A) trend
B) change
C) alignment
D) arrangement

Question 17

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

A) organizing
B) implementing
C) sorting
D) filtering

Question 18

Which of the following is the path to the PivotTable Styles gallery More button?

A) (INSERT tab | Table Styles group)
B) (PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)
C) (HOME tab | Paint Styles group)
D) (PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group)

Question 19

____ reports are visual representations of PivotTables.

A) PivotChart
B) Slicer
C) Data Marker
D) Calculated field

Question 20

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

A) data layouts
B) indices
C) trendlines
D) baselines

Question 21

Which of the following is the path to the Field Buttons button?

A) (PIVOTCHART TOOLS LAYOUT tab | Show/Hide group)
B) (PIVOTCHART TOOLS DESIGN tab | Show/Hide group)
C) (PIVOTCHART TOOLS OPTIONS tab | Show/Hide group)
D) (PIVOTCHART TOOLS ANALYZE tab | Show/Hide group)

Question 22

Tap or click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

A) Options
B) Columns
C) Fields
D) PivotTable

Question 23

The summary function that calculates the number of data values in a PivotTable report is ____.

A) Count
B) Product
C) Var
D) Count Nums

Question 24

To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.

A) Data Analysis
B) PivotTable
C) Charting
D) PivotChart

Question 25

PivotTables are ____ by nature.

A) static
B) inactive
C) attractive
D) dynamic

Question 26

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

A) Sum
B) Varp
C) StdDev
D) Product

Question 27

Which of the following is the path to the PivotChart button?

A) (PIVOTTABLE TOOLS DESIGN tab | Create Chart group)
B) (PIVOTTABLE TOOLS ANALYZE tab | Tools group)
C) (PivotChart Tools Options tab | Show group)
D) (PIVOTCHART TOOLS DESIGN tab | Create Chart group)

Question 28

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

A) slicers
B) PivotTables
C) data markers
D) PivotCharts

Question 29

The +/- buttons ____ a field across categories.

A) add and subtract
B) expand and collapse
C) multiply and divide
D) none of the above

Question 30

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

A) Add Slicer
B) Apply Slicer
C) Insert Slicer
D) Process Slicer

Question 31

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

A) PIVOTCHART TOOLS LAYOUT tab
B) PIVOTTABLE TOOLS DESIGN tab
C) PIVOTTABLE TOOLS LAYOUT tab
D) PIVOTCHART TOOLS DESIGN tab

Question 32

Which of the following is the path to the +/- Buttons button?

A) (PIVOTTABLE TOOLS DESIGN tab | Show group)
B) (PIVOTTABLE TOOLS ANALYZE tab | Show group)
C) (PIVOTTABLE TOOLS FORMAT tab | Show group)
D) (PIVOTTABLE TOOLS DISPLAY tab | Reveal group)

Question 33

With which of the following are any selected subgroups immediately identifiable, and able to be changed with the tap or click of a button or buttons?

A) autofilters
B) slicers
C) filters
D) pivots

Question 34

Which of the following is the path to the Field Headers button?

A) (PIVOTTABLE TOOLS DESIGN tab | Show group)
B) (PIVOTTABLE TOOLS LAYOUT tab | Show group)
C) (PIVOTTABLE TOOLS ANALYZE tab | Show group)
D) (PIVOTTABLE TOOLS DESIGN tab | Fields group)

Question 35

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

A) Slicers
B) Trenders
C) Charters
D) Markers

Question 36

The summary function that calculates the smallest data value in a PivotTable report is ____.

A) Varp
B) Min
C) Max
D) Average

Question 37

You can connect ____ to more than one PivotTable to filter the data.

A) PivotCharts
B) slicers
C) field lists
D) row headings

Question 38

Which of the following is the path to the Field List button?

A) (PIVOTTABLE TOOLS LAYOUT tab | Show group)
B) (PIVOTTABLE TOOLS ANALYZE tab | Show group)
C) (PIVOTTABLE TOOLS DESIGN tab | Show group)
D) (PIVOTTABLE TOOLS DESIGN tab | Fields group)

Question 39

You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.

A) SLICER TOOLS FORMAT
B) SLICER TOOLS LAYOUT
C) SLICER TOOLS OPTIONS
D) SLICER TOOLS DESIGN

Question 40

Which of the following is the path to the Refresh button?

A) (PIVOTTABLE TOOLS ANALYZE tab | Data group)
B) (PIVOTTABLE TOOLS DESIGN tab | Data group)
C) (PIVOTTABLE TOOLS FORMAT tab | Data group)
D) (PIVOTTABLE TOOLS LAYOUT tab | Data group)

Question 41

You can change the view of a PivotTable report depending on what you want to analyze.

Question 42

When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.

Question 43

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

Question 44

When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize.

Question 45

When you create a PivotTable report, Excel creates and associates a PivotChart with that PivotTable report.

Question 46

To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.

Question 47

PivotTable fields can be one of three types: data, summary, and category.

Question 48

Which are types of fields used by PivotTables?
a.
summary
b.
data
c.
category
d.
index

Question 49

Filtering cannot happen independently of cell selection.

Question 50

PivotTables are always based on a PivotChart.

Question 51

Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?

A) Count
B) Varp
C) Average
D) Count Nums

Question 52

Using ____, a user with little knowledge of formulas, functions, and ranges can complete powerful what-if analyses of a set of data.

A) trendlines
B) PivotTables
C) PivotCharts
D) slicers

Question 53

Which of the following are NOT supported by PivotCharts?
a.
3-D cylinder
b.
stock
c.
XY (scatter)
d.
bubble

Question 54

You can display a PivotTable report in one of four layouts: Compact Form, Outline Form, Tabular Form, and Landscape Form.

Question 55

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Question 56

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

Question 57

Which of the following chart types cannot include trendlines?

A) pie
B) line
C) doughnut
D) column

Question 58

Before you add a trendline to a chart, you need to determine the data series to analyze.

Question 59

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

Question 60

All types of Excel charts can have a trendline added to them.

Question 61

In Excel, you add a trendline to an existing Excel _________________________.

Question 62

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

Question 63

Changes in the view of a PivotChart report are automatically reflected in the PivotTable report.

Question 64

PivotChart reports often are used to represent changes in one set of data over time. _________________________

Question 65

As shown in the accompanying figure, _________________________ are graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts.

Question 66

PivotTable rows are drawn from columns in the worksheet data. _________________________

Question 67

When analyzing a chart that contains a trendline, always check the axes to be sure that the differences shown in the chart are not being visually overstated. _________________________

Question 68

When the data in a PivotTable report is changed, any PivotChart reports built upon that PivotTable report update to reflect those changes.

Question 69

Some features of PivotTables and PivotCharts are disabled when a workbook is in compatibility mode. _________________________

Question 70

Using a(n) trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data. _________________________

Question 71

A(n) _________________________ is the symbol in a chart that represents a single value from a worksheet cell.

Question 72

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Question 73

_________________________ can represent changes in one set of data with changes in another set of data.

Question 74

PivotTables automatically update when you change the underlying data for the PivotTable report.

Question 75

_________________________ helps predict data values that are outside of a data set.

Question 76

The default chart type for a PivotChart is a 2-D Line chart.

Question 77

By default, a PivotChart report will be created on its own chart sheet in a workbook.

Question 78

All summary functions are available from the shortcut menu of a cell in the PivotTable report.

Question 79

You can apply a number format to cells in a PivotTable report using a shortcut menu.

Question 80

Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.