Exam 7: Summarizing Data With Pivottables

To select the Row Labels in a PivotChart,point to the bottom border of a Row Label heading and click to select the row labels for that field when the pointer changes to a thick black arrow.

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

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.

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?

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.

Warren creates a table listing the height and weight of students in his class.He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9,the heading "Height" in cell B3 and the height of students in cells B4 to B9,the heading "Weight" in cell C3 and the weight of students in cells C4 to C9.What formula can he use to look up the height of one of the students,Sari,whose name,height,and weight are mentioned in cells A7,B7,and C7,respectively?

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the categories of food items in a store: Vegetables and Fruits.Cell range B2 to B10 in column B lists the types of food items for each category: Cucumbers,Corn,Pears,Lettuce,Potatoes,and Scallions.Cell range C2 to C10 in column C lists the sale of each item during the month.If we insert the formula =SUMIFS(A2:A10,B2:B10,=P* )in cell A11,it will give us the total sale of products that begin with the letter P.

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?

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.

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.

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?

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?

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?

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.

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

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

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.

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.

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?

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?