Question 1

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

Accepted Answer

The answer of  As shown in the acsampanying figure,...

Question 2

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

Accepted Answer

The answer of _________________________ can represent changes in one set...

Question 3

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.

Accepted Answer

Trendlines are used to show patterns in data over time and can help identify the direction and magnitude of the relationship between two sets of data.

Question 4

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

Accepted Answer

The answer of In Excel, you add a trendline to...

Question 5

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

Accepted Answer

The answer of Formatting techniques that work for regular tables...

Question 6

PivotTable rows are drawn from salumns in the worksheet data.

Accepted Answer

PivotTable rows are drawn from columns in the worksheet data, not "salumns."

Question 7

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

Accepted Answer

The default chart type for a PivotChart is a 2-D Clustered Column chart in Microsoft Excel.

Question 8

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

Accepted Answer

The answer of PivotChart reports often are used to represent...

Question 9

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

Accepted Answer

The answer of _________________________ helps predict data values that are...

Question 10

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

Accepted Answer

Compatibility mode in Excel disables certain features to ensure compatibility with earlier versions of Excel, which may not support all the functionalities of PivotTables and PivotCharts.

Question 11

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

Accepted Answer

True. Blank rows above a PivotTable are used to place filters on the PivotTable Fields task pane, and these blank rows should not be deleted or modified in any way to ensure that any filters added continue to work as expected.

Question 12

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

Accepted Answer

The answer of A(n) _________________________ is the symbol in a...

Question 13

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

Accepted Answer

When the data in a PivotTable report is changed, any associated PivotChart reports automatically update to show the changes that have been made.

Question 14

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

Accepted Answer

Changes made to the PivotChart report, such as adding or removing fields, filtering data, or changing chart types, are automatically updated in the associated PivotTable report.

Question 15

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

Accepted Answer

The answer of All summary functions are available from the...

Question 16

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.

Accepted Answer

The scale and intervals of the axes can affect the visual representation of data, potentially exaggerating or understating trends.

Question 17

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

Accepted Answer

You can right-click on the cells in a PivotTable report to open a shortcut menu, which includes options to format the numbers in those cells.

Question 18

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

Accepted Answer

The answer of PivotTables automatically update when you change the...

Question 19

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

Accepted Answer

The answer of By default, a PivotChart report will be...

Question 20

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

Accepted Answer

This is true. You can access the Value Field Settings dialog box by selecting a cell within the PivotTable, then right-clicking and selecting "Value Field Settings" or by going to the "Value Field Settings" option in the "Value Tools" tab in the ribbon. From there, you can choose a different summary function for each value field in the PivotTable.

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