Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

Accepted Answer

A)  PIVOTCHART TOOLS LAYOUT tab 
B)  PIVOTTABLE TOOLS DESIGN tab 
C)  PIVOTTABLE TOOLS LAYOUT tab 
D)  PIVOTCHART TOOLS DESIGN tab 
A)  PIVOTCHART TOOLS LAYOUT tab 
B)  PIVOTTABLE TOOLS DESIGN tab 
C)  PIVOTTABLE TOOLS LAYOUT tab 
D)  PIVOTCHART TOOLS DESIGN tab

Question 3

Filtering cannot happen independently of cell selection.

Accepted Answer

A) True 
 B)False

Question 4

PivotTables are always based on a PivotChart.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following chart types cannot include trendlines?

Accepted Answer

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

Question 7

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.

Accepted Answer

A)  SLICER TOOLS FORMAT 
B)  SLICER TOOLS LAYOUT 
C)  SLICER TOOLS OPTIONS 
D)  SLICER TOOLS DESIGN 
A)  SLICER TOOLS FORMAT 
B)  SLICER TOOLS LAYOUT 
C)  SLICER TOOLS OPTIONS 
D)  SLICER TOOLS DESIGN

Question 8

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

A) True 
 B)False

Question 9

A ____ is an interactive view of worksheet data.

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

PivotTables are ____ by nature.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Last year, your sausin Margie started a small business selling crafting and needlework supplies to small retailers across the state. She has resarded her sampany's annual sales data totals in a worksheet indicating city, store, and product. Going forward, Margie needs to direct her limited resources toward promoting her top products and improving her business relationships with her top retailers. To do this, she needs to carefully analyze the first year's sales data) Margie sends you a text message inviting you to lunch on Saturday. She needs your help with her sales analysis. During lunch, Margie tells you she has tried filtering the worksheet sales data, but can't quite get to the information she needs. You suggest that she ____.

Accepted Answer

A)  just sort the data in the desired order; then sapy the sorted data and paste it on a new worksheet for analysis 
B)  hire an acsaunting firm to do the analysis 
C)  sapy the data and paste it into a Word document as a table; then analyze the data using Word's superior analysis tools 
D)  create a PivotTable based on the data so that she can interactively group and total her data in a variety of ways 
A)  just sort the data in the desired order; then sapy the sorted data and paste it on a new worksheet for analysis 
B)  hire an acsaunting firm to do the analysis 
C)  sapy the data and paste it into a Word document as a table; then analyze the data using Word's superior analysis tools 
D)  create a PivotTable based on the data so that she can interactively group and total her data in a variety of ways

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

Question 17

To apply a sheet tab salor, you can press and hold or right-click a sheet tab, point to _________________________, and then click a salor in the salor grid.

Accepted Answer

The answer of To apply a sheet tab salor, you...

Question 18

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

Accepted Answer

A)  Sum 
B)  Varp 
C)  StdDev 
D)  Product 
A)  Sum 
B)  Varp 
C)  StdDev 
D)  Product

Question 19

Some _________________________ styles include banded rows and salumns, which can make it easier to scan and interpret the report.

Accepted Answer

The answer of Some _________________________ styles include banded rows and...

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

Filtering cannot happen independently of cell selection.

PivotTables are always based on a PivotChart.

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

Which of the following chart types cannot include trendlines?

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.

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

A ____ is an interactive view of worksheet data.

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

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

PivotTables are ____ by nature.

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

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

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

To apply a sheet tab salor, you can press and hold or right-click a sheet tab, point to _________________________, and then click a salor in the salor grid.

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

Some _________________________ styles include banded rows and salumns, which can make it easier to scan and interpret the report.

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

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