Question 1

A ____ is an interactive view of worksheet data.

Accepted Answer

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

Question 2

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 3

Which of the following chart types cannot include trendlines?

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

Case 8-2
Last year, your cousin Margie started a small business selling crafting and needlework supplies to small retailers across the state. She has recorded her company'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 copy the sorted data and paste it on a new worksheet for analysis 
B)  hire an accounting firm to do the analysis 
C)  copy 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 copy the sorted data and paste it on a new worksheet for analysis 
B)  hire an accounting firm to do the analysis 
C)  copy 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 6

You can connect ____ 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 7

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

Accepted Answer

A)  Count 
B)  Varp 
C)  Average 
D)  Count Nums 
E)  None of the above 
A)  Count 
B)  Varp 
C)  Average 
D)  Count Nums 
E)  None of the above

Question 8

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

Accepted Answer

A) True 
 B)False

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

Case 8-1
As the senior accountant for a manufacturing company, you have many years experience working with Excel and often provide help and tips on using Excel to the company's more junior accountants.
-This morning June, a junior accountant 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 accounting, 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, copy 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 accounting, 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, copy 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 11

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 12

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 13

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

Accepted Answer

A)  anywhere in the range that contains the data 
B)  in cell A1 
C)  anywhere outside the range that contains the data 
D)  There is no active cell in a PivotTable report. 
A)  anywhere in the range that contains the data 
B)  in cell A1 
C)  anywhere outside the range that contains the data 
D)  There is no active cell in a PivotTable report.

Question 14

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

Accepted Answer

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

Question 15

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 16

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

Accepted Answer

Question 17

In PivotTables, ____ fields correspond to columns in the original data.

Accepted Answer

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

Question 18

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

Accepted Answer

Question 19

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

Accepted Answer

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

Question 20

Case 8-1
As the senior accountant for a manufacturing company, you have many years experience working with Excel and often provide help and tips on using Excel to the company's more junior accountants.
-After lunch, Jim in purchasing and sales accounting gives you a call. He is working with a workbook containing budgeting worksheets and charts created by a temporary employee, who is no longer working at the company. 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 ____.

Accepted Answer

A)  display the R-squared value for the trendline; the closer the value is to 0, the more accurate the trendline 
B)  rechart the data and add an exponential trendline 
C)  display the R-squared value for the trendline; the closer the value is to 1, the more accurate the trendline 
D)  call the agency who provided the temporary employee and ask them to send a new temporary employee to fix the problem 
A)  display the R-squared value for the trendline; the closer the value is to 0, the more accurate the trendline 
B)  rechart the data and add an exponential trendline 
C)  display the R-squared value for the trendline; the closer the value is to 1, the more accurate the trendline 
D)  call the agency who provided the temporary employee and ask them to send a new temporary employee to fix the problem

A ____ is an interactive view of worksheet data.

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.

Which of the following chart types cannot include trendlines?

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

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

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

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

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

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

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

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

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

Which of the following are NOT supported by PivotCharts?

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

In PivotTables, ____ fields correspond to columns in the original data.

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

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

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 9: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

A ____ is an interactive view of worksheet data.

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.

Which of the following chart types cannot include trendlines?

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

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

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

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

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

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

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

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

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

Which of the following are NOT supported by PivotCharts?

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

In PivotTables, ____ fields correspond to columns in the original data.

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

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

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters