Question 1

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

Accepted Answer

Question 2

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?

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

Question 5

In a PivotTable, you use the filter button to specify how to filter the data; after you create a(n) _________________________, you can perform the same filtering task in one step.

Accepted Answer

The answer of In a PivotTable, you use the filter...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

If you tap or click outside of a PivotTable or PivotChart, the _________________________ will no longer be displayed.

Accepted Answer

The answer of If you tap or click outside of...

Question 8

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.

Accepted Answer

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

Question 9

In a PivotTable report, you can add details by further categorizing the data to look at specific _________________________.

Accepted Answer

The answer of In a PivotTable report, you can add...

Question 10

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

Accepted Answer

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

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

Accepted Answer

Question 12

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

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

When creating a(n) _________________________, you can use categories in the data to summarize different groups or totals.

Accepted Answer

The answer of When creating a(n) _________________________, you can use...

Question 17

When creating a PivotChart report, you select the chart type and subtype in the __________________________ dialog box.

Accepted Answer

The answer of When creating a PivotChart report, you select...

Question 18

A(n) _________________________ field in a PivotTable report is a field with values not entered as data, but determined by samputation involving data in other fields.

Accepted Answer

The answer of A(n) _________________________ field in a PivotTable report...

Question 19

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

Accepted Answer

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

Question 20

How do you determine which fields to use in a PivotTable?

Accepted Answer

You can create PivotTable and PivotChart

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

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

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?

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

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

In a PivotTable, you use the filter button to specify how to filter the data; after you create a(n) _________________________, you can perform the same filtering task in one step.

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

If you tap or click outside of a PivotTable or PivotChart, the _________________________ will no longer be displayed.

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.

In a PivotTable report, you can add details by further categorizing the data to look at specific _________________________.

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

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

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.

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

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.

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

When creating a(n) _________________________, you can use categories in the data to summarize different groups or totals.

When creating a PivotChart report, you select the chart type and subtype in the __________________________ dialog box.

A(n) _________________________ field in a PivotTable report is a field with values not entered as data, but determined by samputation involving data in other fields.

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

How do you determine which fields to use in a PivotTable?

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