Question 1

To clear all the data from a PivotChart,click the PivotChart.Then on the Analyze tab,in the Data group,click Clear,and then click Clear All.

Accepted Answer

A) True 
 B)False

Question 2

One can use the areas section (at the bottom)of the Field List to rearrange fields the way they want by dragging them between the four areas.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following will you select as X in the following series of clicks to copy a chart from Excel to Word so that it is no longer linked to Excel: In Excel: Chart > Home tab > Clipboard group > Copy button > In Word: location to paste chart > Home tab > Clipboard group > Paste > Paste Options button > X?

Accepted Answer

A)  Link 
B)  Embed 
C)  Source formatting 
D)  Destination theme

Question 4

Which of these steps will you choose to refresh data in a Pivot Chart?

Accepted Answer

A)  Right-click on the Pivot Chart and select Refresh 
B)  Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Refresh Status 
C)  Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Cancel Refresh 
D)  Click Analyze > Options > Layout & Format tab > Check Autofit column widths on update and Preserve cell formatting on update boxes

Question 5

Edwin wants to insert a Pivot Chart to summarize raw data.Which of the following combination of clicks/selections/entries should he use to do this?

Accepted Answer

A)  Select Cell > Insert > PivotChart > OK 
B)  Select Cell > Insert > Recommended PIvotTables > OK 
C)  Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK 
D)  Select Cell > Insert > Table > Create Table dialog box > Fill data in Where is the data for your table? box > OK

Question 6

Alejandro wants to change the color of a Pivot Chart he has created to make it a little more impactful.To do so,he clicks the chart he wants to change,then clicks Chart Styles in the upper right corner next to chart,clicks X and selects the color scheme he wants.What can X be in the series of clicks?

Accepted Answer

A)  Style 
B)  Color 
C)  Fonts 
D)  Effects

Question 7

Which of these tabs will you select to alter the font as desired while changing the slicer style?

Accepted Answer

A)  Font tab 
B)  Analyze tab 
C)  Border tab 
D)  Slicer Contextual tool tab

Question 8

To add a calculated field to a PIvotTable,select a cell in the pivot table,then under the PivotTable Tools tab,click the Analyze tab.In the Calculations group,click Fields,Items,& Sets,and then click Calculated Field.Enter a name for the calculated field,type a formula in the Formula box,then click Add to save the calculated field,and click Close.

Accepted Answer

A) True 
 B)False

Question 9

Which of these functions will you use to find the variance of a population of all of the values to be summarized?

Accepted Answer

A)  Var 
B)  Varp 
C)  StDev 
D)  StDevp

Question 10

Leigh-Ann wants to filter data in a PIvotChart using a slicer.She clicks on the table and then selects Slicer in a particular group on the insert tab.She then ticks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK.What tab did click during the procedure?

Accepted Answer

A)  Links 
B)  Filters 
C)  Symbols 
D)  Sparklines

Question 11

What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells > Insert tab > Charts group > Insert Combo Chart symbol > Create Custom Combo Chart > Insert Chart dialog box > All Charts > Series 1 > X (Chart type)> Series 2 > Y (Chart type)> OK?

Accepted Answer

A)  X - Scatter,Y - Stacked Bar 
B)  X - Clustered Column,Y - Line 
C)  X - Radar with Markers,Y - Area 
D)  X- Clustered Bar,Y- Stacked Line

Question 12

Marcos wants to refresh the data in a Pivot table manually.He clicks on the PivotTable to show the PivotTable Tools on the ribbon.Which combination of keys should he press next to complete the procedure?

Accepted Answer

A)  Alt + F9 
B)  Alt +F5 
C)  Ctrl + K 
D)  Shift +Tab

Question 13

To use more than one filters per field,one can right-click a cell in the pivot table,and click PivotTable Options,then click the Layout & Format tab.Finally,under Filters,add a check mark to "Allow multiple filters per field" and click OK.

Accepted Answer

A) True 
 B)False

Question 14

Ingrid wants to change the name associated with a Pivot Chart in Excel.To do so,she right-clicks on the pivot table and then selects X from the popup menu.She then enters the new name for the Pivot Chart in the Name field in the window that appears and clicks the OK button.What can X be in this procedure?

Accepted Answer

A)  Hide Field List 
B)  Number Format 
C)  PivotTable Options 
D)  Value Field Settings

Question 15

Ricki wants to apply a particular chart style to a PivotChart she has created.Which of these tabs will help her apply it?

Accepted Answer

A)  Layout tab 
B)  Format tab 
C)  Design tab 
D)  Analyze tab

Question 16

Which of the following will you do in step X in the following series of clicks to change the bounds of a chart axis: Chart > Chart Tools > Format tab > Current Selection > Format Selection > Format Axis > Axis Options > Vertical Axis crosses > At Category number > X?

Accepted Answer

A)  Expand Tick Marks,and then select the options that you want in the Major type and Minor type boxes. 
B)  Type the number that you want in the text box. 
C)  Expand Tick Marks,and then in the Interval between tick marks box,and type the number that you want. 
D)  Expand Labels,then under Interval between labels,select Specify interval unit and type the number you want in the text box.

Question 17

Katrin has created a new table with only data for sale of products in the East region of her company.She wants to change the pivot table showing the sale of products in both East and West regions of the country to use that source,so that it can be sent to a manager in the West region,without revealing the East region's data.To do so,she can follow the following series of clicks/ entries/ selections: Cell > PivotTable Tools tab > Data group > Top section of the Change Data Source command > Change PivotTable Data Source dialog box > Select a new data source range > OK.

Accepted Answer

A) True 
 B)False

Question 18

When we add fields to the Column Labels area,they appear as headings on the left of the table.

Accepted Answer

A) True 
 B)False

Question 19

Salena has created a chart to show the sale of products of her firm in different cities during different years.The chart has only one series with all the columns of the same color.The Year and Location fields are both in the Rows area.Now,she wants to create columns with different colors,for which she will have to move one of the fields into the Column area in the PivotTable Field List.To do so,Salena can follow the following series of clicks/ entries/ selections to do so: Pivot Chart > Pivot Chart Field window > Drag the Year field from the Axis box (Categories)to the Legend (Series)box.This will create a series for each city,and show the city's columns in a different color.

Accepted Answer

A) True 
 B)False

Question 20

Izzy wants to move a pivot table to a new worksheet.Which of these should she select after the following clicks to do so: PivotTable > Analyze tab > PivotTable tools > Move PIvotTable > Move PivotTable dialog box > Choose where you want the PivotTable to be placed?

Accepted Answer

A)  New Worksheet 
B)  Blank Worksheet 
C)  Fresh Worksheet 
D)  Create Worksheet

Exam 8: Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

To clear all the data from a PivotChart,click the PivotChart.Then on the Analyze tab,in the Data group,click Clear,and then click Clear All.

One can use the areas section (at the bottom)of the Field List to rearrange fields the way they want by dragging them between the four areas.

Which of these steps will you choose to refresh data in a Pivot Chart?

Edwin wants to insert a Pivot Chart to summarize raw data.Which of the following combination of clicks/selections/entries should he use to do this?

Which of these tabs will you select to alter the font as desired while changing the slicer style?

Which of these functions will you use to find the variance of a population of all of the values to be summarized?

Marcos wants to refresh the data in a Pivot table manually.He clicks on the PivotTable to show the PivotTable Tools on the ribbon.Which combination of keys should he press next to complete the procedure?

To use more than one filters per field,one can right-click a cell in the pivot table,and click PivotTable Options,then click the Layout & Format tab.Finally,under Filters,add a check mark to "Allow multiple filters per field" and click OK.

Ricki wants to apply a particular chart style to a PivotChart she has created.Which of these tabs will help her apply it?

Which of the following will you do in step X in the following series of clicks to change the bounds of a chart axis: Chart > Chart Tools > Format tab > Current Selection > Format Selection > Format Axis > Axis Options > Vertical Axis crosses > At Category number > X?

When we add fields to the Column Labels area,they appear as headings on the left of the table.

Izzy wants to move a pivot table to a new worksheet.Which of these should she select after the following clicks to do so: PivotTable > Analyze tab > PivotTable tools > Move PIvotTable > Move PivotTable dialog box > Choose where you want the PivotTable to be placed?