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

Question 1

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

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

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

Answer 2

B

Question 3

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 3

C

Question 4

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 5

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 6

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

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

Question 7

A ____ is an interactive view of worksheet data.

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

Question 8

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

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

Question 9

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

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

Question 10

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

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

Question 11

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 12

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 13

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 14

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 15

You can filter the PivotTable report by ____.

A) Total 2014 Sales
B) Revenue Venue
C) Total 2015 Sales
D) Average 2014 Sales

Question 16

____ reports are visual representations of PivotTables.

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

Question 17

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 18

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

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

Question 19

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

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

Question 20

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 21

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 22

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 23

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 24

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

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

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

Question 27

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 28

The + / - buttons ____ a field across categories.

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

Question 29

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 30

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 31

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

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

Question 32

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 33

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

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

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

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

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

Question 36

PivotTables are ____ by nature.

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

Question 37

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

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

Question 38

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 39

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 40

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 41

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

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

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

Question 44

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

Question 45

Which are types of fields used by PivotTables?

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

Question 46

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 47

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

A) Count
B) Var.p
C) Average
D) Count Nums

Question 48

Which of the following are NOT supported by PivotCharts?

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

Question 49

Filtering cannot happen independently of cell selection.

Question 50

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

Question 51

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

Question 52

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

Question 53

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 54

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

Question 55

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

Question 56

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

Question 57

Which of the following chart types cannot include trendlines?

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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 68

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

Question 69

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 70

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

Question 71

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