Deck 19: Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Question 1

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)

Answer 1

A

Question 2

In PivotTables, ____ fields sarrespond to salumns in the original data.

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

Answer 2

D

Question 3

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

Answer 3

A

Question 4

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

Question 5

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

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

Question 6

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 salumn chart

Question 7

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)

Question 8

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 9

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 10

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

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

Question 11

A ____ is an interactive view of worksheet data.

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

Question 12

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

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

Question 13

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

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

Question 14

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 15

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

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

Question 16

____ reports are visual representations of PivotTables.

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

Question 17

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

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

Question 18

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 19

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 20

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 21

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 22

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 23

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 24

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 25

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 26

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) salumns
C) Fields
D) PivotTable

Question 27

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

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

Question 28

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 29

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

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

Question 30

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 31

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 32

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 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

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 37

PivotTables are ____ by nature.

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

Question 38

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 39

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 40

The +/- buttons ____ a field across categories.

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

Question 41

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

Question 42

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

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

Question 43

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

Question 44

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

Question 45

Modified Multiple Choice Which of the following chart types cannot include trendlines?

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

Question 46

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

Question 47

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

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

Question 48

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

Question 49

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

Question 50

Modified Multiple Choice Which are types of fields used by PivotTables?

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

Question 51

PivotTables are always based on a PivotChart.

Question 52

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

Question 53

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

Question 54

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

Question 55

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 56

Filtering cannot happen independently of cell selection.

Question 57

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

Question 58

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

Question 59

Modified Multiple Choice Which of the following are NOT supported by PivotCharts?

A) 3-D cylinder
B) stock
C) XY (scatter)
D) bubble

Question 60

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

Question 61

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

Question 62

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

Question 63

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 64

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

Question 65

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

Question 66

PivotTable rows are drawn from salumns in the worksheet data.

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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