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

To see the data source for the selected chart,click the Design tab,then under PivotChart Tools click Select Data to open the Select Data Source window.

One can rearrange fields in the PivotTable by clicking the field name in one of the areas,and then selecting Move Up command to move the field up one position in the area.

Jin wants to insert a recommended pivot table.He clicks a single cell inside the data set,then proceeds to step X and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?

Which of the following will you select as X in the given series of clicks to add a legend to the bottom of a chart: Chart > + sign > X > Bottom?

Horatio wants to hide field headers in a Pivot table to increase the display of the screen.He clicks on a cell in the pivot table,then clicks on ANALYZE in the ribbon.What should he do next to complete the procedure?

Che wants to change the chart type of the whole chart to give it a different look.To do this,he follows the following steps: 1.X 2.He clicks Change Chart Type On the Design tab in the Type group.3.Che clicks the chart type that he wants to use in the Change Chart Type dialog box.What was step 1 in his procedure?

Hari wants to connect a slicer to three pivot tables so that he can control the entire dashboard with a single slicer.To do so,he selects the pivot tables to connect a slicer,then selects a cell in any of them,then clicks on three group/tab/button in a series.Next from the "Insert Slicer" dialog box,he selects the column to use as a filter in the slicer and clicks OK.What can be the three clicks he made during the procedure?

Anne has created a chart and wants to apply a different fill color to a chart element.Which of these will she choose after selecting the chart element and clicking on Chart Tools under Format tab?

Rainn wants to switch rows to column in his chart.To do so,he can click on the following series: chart with data series that he wants to plot on different axes > Chart Tools > Design tab > Data group > Switch Row/Column.

Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable?

In which of these dialog boxes will you select the font,border,and fill settings for an element in a PivotTable?

To insert a Sunburst chart for a data set,we can click on the following series: Range of cells > Data tab > Charts group > Insert Hierarchy Chart > Sunburst.

To add fields to a PivotTable,one can use the field section of the Field List and tick the box next to field names to place them in the default area of the Field List.

To display the PivotTable Field list,right-click any cell in the pivot table and select Show Field List from the menu.

Helen wants to resize slicer buttons to exact dimensions.She selects the slicer,then clicks the Slicer Tools under Options tab.What should she select next to reset the slicer buttons to exact dimensions?

Nolan wants to group data in a Pivot table to analyze a subset of data.Which of these series of clicks/ selections/ entries should he follow to do so?

Chastity wants to rename her pivot table from PivotTable1 to ProductData.She clicks the Pivot table then goes to PivotTable Tools > Analyze,and clicks the X text box in the PivotTable group.She then types a new name and presses ENTER.What can X be in the procedure?