Question 1

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

The statement is true.

Question 2

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?

Accepted Answer

To hide field headers in a PivotTable, after clicking on "Analyze" in the ribbon, Horatio should click on "Field Headers" in the "Show" group. This option toggles the display of field headers on or off.

Question 3

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.

Accepted Answer

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.

Question 4

Right-click the pivot item,then click Collapse to collapse a field in a PivotTable.

Accepted Answer

This is a correct statement. Right-clicking on a pivot item and selecting "Collapse" will collapse the field in the PivotTable to show only the summarized data for that field.

Question 5

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

Accepted Answer

This is the correct way to display the PivotTable Field list.

Question 6

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

Accepted Answer

Varp should be used to find the variance of a population since it divides by the total number of values in the population, while Var divides by the sample size (n-1) to obtain an unbiased estimate of the population variance. StDev and StDevp are used to find the standard deviation of a sample and population, respectively.

Question 7

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.

Accepted Answer

The question specifically asks about changing the color of the Pivot Chart, so the best choice is B, which refers to changing the color scheme of the chart. The other options, such as Style, Fonts, and Effects, may also have an impact on the appearance of the chart, but they are not directly related to changing the color.

Question 8

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

Accepted Answer

The default layout for a newly created PivotTable is the Compact Form. This layout groups data in a way that helps to save space and allows for easier reading of grouped information.

Question 9

To insert a scroll bar (form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "A."

Accepted Answer

To insert a scroll bar (form control) into a worksheet, you would click the Developer tab > Insert > Form Controls, and then select the scroll bar option, not a button labeled as "A."

Question 10

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

The option "New Worksheet" should be selected to move the pivot table to a new worksheet. This will create a new worksheet and place the pivot table in it.

Question 11

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the years from 2010 to 2019. Cell range B2 to B10 in column B lists the types of food items sold during each year: Tomatoes, Oranges, Pears, Pineapples, Potatoes, and Onions. Cell range C2 to C10 in column C lists the sale of each item in each year. If we insert the formula =COUNTIFS("=Onions","B2:B10") in cell A11, it will give us the count of the number of times "Onions" has been listed in the worksheet.

Accepted Answer

The formula should be =COUNTIFS(B2:B10,"Onions") to count the number of times "Onions" has been listed in column B. The formula in the given format will result in an error.

Question 12

Luca wants to insert a pivot table.He clicks on 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?

Accepted Answer

Step 2 is to click on the PivotTable button in the Tables group under the Insert tab, which will open the Create PivotTable dialog box.

Question 13

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

This statement is true. To clear all the data from a PivotChart, one needs to click on the PivotChart, then on the Analyze tab, in the Data group, click Clear, and then click Clear All.

Question 14

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?

Accepted Answer

PivotTable group refers to options related to PivotTable only. Therefore, X can only represent the PivotTable name as Chastity wants to rename her PivotTable1 to ProductData.

Question 15

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

Accepted Answer

When Ingrid right-clicks on the pivot table and selects X from the popup menu, she will be presented with the PivotTable Options window. In this window, there is a field where she can enter the new name for the Pivot Chart. Therefore, the best choice is C for PivotTable Options. A, B, and D are not relevant to changing the name of a Pivot Chart.

Question 16

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?

Accepted Answer

Step 2 should be to click on "Recommended PivotTables" on the Insert tab in the Tables group, as this is the option for inserting a recommended pivot table. Option A is for inserting a pivot chart, not a pivot table. Option B is for inserting a regular pivot table, not a recommended one. Option D is not a valid option, as there is no "Pivot Chart" option under the Charts group on the Charts tab.

Question 17

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

To insert a Pivot Chart, Edwin should select a cell in the data, go to the Insert tab, choose PivotChart, and then click OK.

Question 18

To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.

Accepted Answer

This series of selections is correct for filtering data in a PivotTable using slicers.

Question 19

Right-click the pivot item,then click Expand to expand a field in a PivotTable.

Accepted Answer

When you right-click a pivot item in a PivotTable, you can select "Expand" to expand a field and show its subfields in the PivotTable.

Question 20

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.

Accepted Answer

To insert an option button into a worksheet, you should click on Developer tab > Insert > Form Controls, and then choose the option button (circle with a dot inside), not an image with a tick inside a rectangular box.

Quiz 7: Summarizing Data With Pivottables