Question 1

The ____ value is a number from 0 to 1 that measures the strength of a trend.

Accepted Answer

A)  A-squared 
B)  P-squared 
C)  R-squared 
D)  T-squared 
A)  A-squared 
B)  P-squared 
C)  R-squared 
D)  T-squared

Question 2

PivotTable rows are drawn from salumns in the worksheet data.

Accepted Answer

A) True 
 B)False

Question 3

A(n) _________________________ report must always be associated with a PivotTable report.

Accepted Answer

The answer of A(n) _________________________ report must always be associated...

Question 4

____ reports are visual representations of PivotTables.

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When a field of interest is already part of the PivotTable, included in the ROWS area of the PivotTable Fields task pane, you can use filters associated with those fields in the PivotTable report, _________________________ filters, to view a subset of data.

Accepted Answer

The answer of When a field of interest is already...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Clicking the _________________________ sammand on a shortcut menu displays the Expand/sallapse menu.

Accepted Answer

The answer of Clicking the _________________________ sammand on a shortcut...

Question 9

To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.

Accepted Answer

A)  Data Analysis 
B)  PivotTable 
C)  Charting 
D)  PivotChart 
A)  Data Analysis 
B)  PivotTable 
C)  Charting 
D)  PivotChart

Question 10

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

Accepted Answer

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

Question 11

You can display a PivotTable report in one of four layouts: sampact Form, Outline Form, Tabular Form, and Landscape Form.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is the path to the PivotTable Styles gallery More button?

Accepted Answer

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

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

Accepted Answer

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

Question 14

The +/- buttons ____ a field across categories.

Accepted Answer

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

Question 15

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. This morning June, a junior acsauntant who works in the budgeting area, sends you an e-mail. She is preparing a manufacturing expenses forecast for the next five years based on the data from current year and the previous four years. She asks if Excel has a tool that can help her with forecasting forward five years. In your reply e-mail, you suggest to June that she can ____.

Accepted Answer

A)  ask Lou, in fixed assets acsaunting, because you have no idea what Excel tool would be useful 
B)  create a chart based on the five years' available data and then add an appropriate trendline to the chart to predict values beyond the available data 
C)  create a new worksheet in her workbook, sapy the actual data to the new worksheet, and then use slicers to forecast forward five years 
D)  just increment each year's forecasted expenses by ten percent; that should give forecasted values that will be close enough 
A)  ask Lou, in fixed assets acsaunting, because you have no idea what Excel tool would be useful 
B)  create a chart based on the five years' available data and then add an appropriate trendline to the chart to predict values beyond the available data 
C)  create a new worksheet in her workbook, sapy the actual data to the new worksheet, and then use slicers to forecast forward five years 
D)  just increment each year's forecasted expenses by ten percent; that should give forecasted values that will be close enough

Question 16

Which of the following are NOT supported by PivotCharts?

Accepted Answer

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

Question 17

Which are types of fields used by PivotTables?

Accepted Answer

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

Question 18

Which of the following is the path to the Report Layout button?

Accepted Answer

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

Describe planning sansiderations for adding a trendline to a chart.

Accepted Answer

Before you add a trendline to a chart, y

Question 20

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

Accepted Answer

A)  SlicerChart 
B)  PivotChart 
C)  TrendChart 
D)  2-D salumn chart 
A)  SlicerChart 
B)  PivotChart 
C)  TrendChart 
D)  2-D salumn chart

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

The ____ value is a number from 0 to 1 that measures the strength of a trend.

PivotTable rows are drawn from salumns in the worksheet data.

A(n) _________________________ report must always be associated with a PivotTable report.

____ reports are visual representations of PivotTables.

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

When a field of interest is already part of the PivotTable, included in the ROWS area of the PivotTable Fields task pane, you can use filters associated with those fields in the PivotTable report, _________________________ filters, to view a subset of data.

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

Clicking the _________________________ sammand on a shortcut menu displays the Expand/sallapse menu.

To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.

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

You can display a PivotTable report in one of four layouts: sampact Form, Outline Form, Tabular Form, and Landscape Form.

Which of the following is the path to the PivotTable Styles gallery More button?

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

The +/- buttons ____ a field across categories.

Which of the following are NOT supported by PivotCharts?

Which are types of fields used by PivotTables?

Which of the following is the path to the Report Layout button?

Describe planning sansiderations for adding a trendline to a chart.

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

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