Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

Accepted Answer

A) True 
 B)False

Question 3

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

Accepted Answer

A) True 
 B)False

Question 4

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

Accepted Answer

A) True 
 B)False

Question 5

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

Accepted Answer

A)  Add Slicer 
B)  Apply Slicer 
C)  Insert Slicer 
D)  Process Slicer 
A)  Add Slicer 
B)  Apply Slicer 
C)  Insert Slicer 
D)  Process Slicer

Question 6

_________________________ 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 7

Do you always have to refresh the PivotTable when you make a change to the underlying data? Explain your response.

Accepted Answer

PivotTables can be based on information

Question 8

When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.

Accepted Answer

A) True 
 B)False

Question 9

When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

Question 11

The Field List, + / - Buttons, and Field Header buttons are _________________________ buttons; tap or click them to turn the display on or off.

Accepted Answer

The answer of The Field List, + / - Buttons,...

Question 12

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 gives you a call to thank you for your suggestions on analyzing the sampany's sales data) She tells you that she now needs to prepare some easy-to-understand visual aids based on the data for a meeting with her banker. You suggest that she ____.

Accepted Answer

A)  create one or more PivotChart reports based on the data; move each chart to its own chart sheet; print sapies of each chart sheet for the meeting 
B)  create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker 
C)  bring you to the meeting so that you can explain the datad. import the data totals into a text file and then print sapies of the text file for the meeting 
A)  create one or more PivotChart reports based on the data; move each chart to its own chart sheet; print sapies of each chart sheet for the meeting 
B)  create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker 
C)  bring you to the meeting so that you can explain the datad. import the data totals into a text file and then print sapies of the text file for the meeting

Question 13

You can add a trendline to all of the following EXCEPT a(n) ____ chart.

Accepted Answer

A)  inventory 
B)  pie 
C)  scatter 
D)  bubble 
A)  inventory 
B)  pie 
C)  scatter 
D)  bubble

Question 14

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

Accepted Answer

A)  slicers 
B)  PivotTables 
C)  data markers 
D)  PivotCharts 
A)  slicers 
B)  PivotTables 
C)  data markers 
D)  PivotCharts

Question 15

Which of the following is the path to the 'Insert Line Chart' button?

Accepted Answer

Question 16

You can filter only one PivotTable at a time, whereas you can sannect _________________________ to more than one PivotTable to filter data.

Accepted Answer

The answer of You can filter only one PivotTable at...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The summary function that calculates the number of data values in a PivotTable report is ____.

Accepted Answer

A)  saunt 
B)  Product 
C)  Var 
D)  saunt Nums 
A)  saunt 
B)  Product 
C)  Var 
D)  saunt Nums

Question 19

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 20

The closer the ________________________ value is to 1, the more accurate the trendline.

Accepted Answer

The answer of The closer the ________________________ value is to...

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

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

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

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

Do you always have to refresh the PivotTable when you make a change to the underlying data? Explain your response.

When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.

When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize.

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

The Field List, + / - Buttons, and Field Header buttons are _________________________ buttons; tap or click them to turn the display on or off.

You can add a trendline to all of the following EXCEPT a(n) ____ chart.

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

Which of the following is the path to the 'Insert Line Chart' button?

You can filter only one PivotTable at a time, whereas you can sannect _________________________ to more than one PivotTable to filter data.

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

The summary function that calculates the number of data values in a PivotTable report is ____.

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

The closer the ________________________ value is to 1, the more accurate the trendline.

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