Chapter 5

Question 1

1. A worksheet contains a list of graduates at your university. The worksheet contains these columns in this sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by College, then by Major, and then by Student Last Name. What is the default At a change in setting within the subtotal dialog box, and what would be a more appropriate setting?

Answer 1

Student Last Name (default field), GPA (correct field)

Question 2

You created an outline within a worksheet. What does the (-) button indicate in the left of a row heading?

Answer 2

you can click it to collapse the details of that category

Question 3

A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields have been added to the PivotTable yet. If you click the College Major field check box in the PivotTable Fields List, where does excel place this field?

Answer 3

ROWS area

Question 4

You created a PivotTable to summarize commissions earned by employees in each department. What is the default summary for the commissions field when you add it to the PivotTable?

Answer 4

sum

Question 5

You have created a PivotTable and made some changes to values in the original dataset from which the PivotTable was created. How does this affect the PivotTable?

Answer 5

changes in the dataset do not affect the PivotTable until you refresh the PivotTable

Question 6

What settings should you select for a PivotTable if you want to apply a different color scheme and display different fill colors for main category rows and horizontal lines within the PivotTable

Answer 6

a different PivotTable Style only

Question 7

You have just created a slicer for the State field in a PivotTable. Which of the following does not characterize the initial slicer?

Answer 7

the slicer may display on top of the PivotTable data

Question 8

Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a meal at a restaurant?

Answer 8

=”Meal Cost” * .2

Question 9

You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice the name of a rep who has since been fired. How do you remove this rep from the chart without deleting the data?

Answer 9

filter the sales rep field in the pivotchart and deselect the employee’s checkbox