ISYS Chapter 2

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. TRUE OR FALSE

TRUE

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

TRUE

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 OR FALSE

TRUE

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

TRUE

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. TRUE or FALSE

TRUE

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? a. =AND(B2>=70, C2>=80) b. =OR(B2>=70, C2>=80) c. =IF(B2>=70, C2>=80) d. =NOT(OR(B2>=70, C2>=80))

a. =AND(B2>=70, C2>=80)

The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE? a. =OR(B2>=60, C2>=60) b. =NOT(OR(B2>=60, C2>=60)) c. =AND(B2>=60, C2>=60) d. =IF(B2>=60, C2>=60)

a. =OR(B2>=60, C2>=60)

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? a. Click PivotTable on the Insert tab, in the Tables group. b. Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. c. Select a pivot table under Pivot Chart in the Charts group on the Charts tab. d. Click Recommended PivotTables on the Insert tab, in the Tables group.

a. Click PivotTable on the Insert tab, in the Tables group.

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? a. Chart Name b. PivotTable Name c. Pivot Chart Name d. Table Name

b. PivotTable Name

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? a. Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. b. Click PivotTable on the Insert tab, in the Tables group. c. Click Recommended PivotTables on the Insert tab, in the Tables group. d. Select a pivot table under Pivot Chart in the Charts group on the Charts tab.

c. Click Recommended PivotTables on the Insert tab, in the Tables group.

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. What can X be in the series of clicks? a. Effects b. Style c. Color d. Fonts

c. Color

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? a. Create Worksheet b. Blank Worksheet c. Fresh Worksheet d. New Worksheet

d. New Worksheet