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

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?

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?

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

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.

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

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?

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?

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.

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?

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?

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.

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

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.

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?