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

The Field Headers button is located in the _________________________ group on the PIVOTTABLE TOOLS ANALYZE tab.

Free

(Short Answer)

4.8/5

(32)

Question 1

Correct Answer:

Verified

Show

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

Free

(Multiple Choice)

4.8/5

(32)

Question 2

Correct Answer:

Verified

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

Free

(Multiple Choice)

4.9/5

(32)

Question 3

Correct Answer:

Verified

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

(Multiple Choice)

4.8/5

(39)

Question 4

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

(Multiple Choice)

4.9/5

(40)

Question 5

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

(Short Answer)

4.7/5

(33)

Question 6

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

(Multiple Choice)

4.9/5

(26)

Question 7

As the senior acsauntant for a manufacturing sampany, you have many years experience working with Excel and often provide help and tips on using Excel to the sampany's more junior acsauntants. After lunch, Jim in purchasing and sales acsaunting gives you a call. He is working with a workbook santaining budgeting worksheets and charts created by a temporary employee, who is no longer working at the sampany. One of the line charts includes a linear trendline that looks really strange. Jim wants to know how he can verify the precision of the trendline. You tell Jim to ____.

(Multiple Choice)

4.8/5

(32)

Question 8

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

(Multiple Choice)

4.9/5

(34)

Question 9

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

(Short Answer)

4.9/5

(29)

Question 10

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

(True/False)

4.7/5

(30)

Question 11

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

(Multiple Choice)

4.8/5

(30)

Question 12

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

(Multiple Choice)

4.8/5

(33)

Question 13

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

(True/False)

4.8/5

(30)

Question 14

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

(True/False)

4.9/5

(41)

Question 15

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

(Multiple Choice)

4.8/5

(41)

Question 16

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

(Short Answer)

4.9/5

(26)

Question 17

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

(True/False)

4.8/5

(35)

Question 18

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

(True/False)

4.8/5

(36)

Question 19

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

(True/False)

4.8/5

(35)

Question 20

Showing 1 - 20 of 103

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

The Field Headers button is located in the _________________________ group on the PIVOTTABLE TOOLS ANALYZE tab.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters