Exam 7: Summarizing Data With Pivottables

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.

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

To remove a field, in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.

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.

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?

Which of these is the default layout for a newly created Pivot table?

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

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

To hide the PivotTable Field list, right click on any cell of the pivot table, and select Hide Field List option from the context menu.

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.

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?

To insert an option button into a worksheet, click on the following series: Developer tab > Insert > Form Controls > Image with a tick inside a rectangular box.

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?

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?

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

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?

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?