FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following are NOT supported by PivotCharts?

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

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

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

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.

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

A ____ is an interactive view of worksheet data.

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

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

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

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

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

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

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

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

Which of the following chart types cannot include trendlines?

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

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

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