Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Microsoft Office Excel

Computing

Quiz 7 :

Summarizing Data With Pivottables

Quiz 7 :

Summarizing Data With Pivottables

search
arrow
Which of these functions will you use to find the variance of a population of all of the values to be summarized?
Free
Multiple Choice
Answer:

Answer:

B

arrow
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.
Free
True False
Answer:

Answer:

True

arrow
Which of these is the default layout for a newly created Pivot table?
Free
Multiple Choice
Answer:

Answer:

A

arrow
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?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
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.
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
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.
True False
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
Right-click the pivot item, then click Expand to expand a field in a PivotTable.
True False
Answer:
arrow
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
Multiple Choice
Answer:
arrow
To display the PivotTable Field list, right-click any cell in the pivot table and select Show Field List from the menu.
True False
Answer:
arrow
Right-click the pivot item, then click Collapse to collapse a field in a PivotTable.
True False
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
To insert a scroll bar (form control) into a worksheet, click the Developer tab > Insert > Form Controls > Button labeled as "A."
True False
Answer:
Showing 1 - 20 of 39