Question 1 of 3

Question

1. Something doesn’t seem right to you when you’re looking at the $74.15 for the Korean Beef Satays shown in the PivotTable below. How would you go about inspecting the records that contributed to this value?

Answer 1

Go back to the source data table and filter the records consistently to show only Appetizers for the Category column, Korean Beef Satays for the Item Name column and 2 for the Week column.

Answer 2

It is not possible to do this easily.

Answer 3

Double click the cell that contains the $74.15 value (highlighted in yellow).

Answer 4

Don’t know

Answer 5

Right click any value in the PivotTable and choose “Show Details”.

Answer 6

Remove all row, column and report filters, remove all but one field from the values area of the PivotTable, and double click that value cell.

Answer 7

You couldn’t.

Answer 8

Don’t know

Answer 9

Turn on Excel’s worksheet protection feature to protect the PivotTable.

Answer 10

Go to PivotTable Options > Data > uncheck the “Enable Show Details” checkbox.

Answer 11

Delete the original data table.

Answer 12

Don’t know

Question 1 of 3

1. Something doesn’t seem right to you when you’re looking at the $74.15 for the Korean Beef Satays shown in the PivotTable below. How would you go about inspecting the records that contributed to this value?

2. If someone sent you a PivotTable, but deleted the original data source, how could you go about re-creating that data source?

3. The Show Details feature is very useful, but easy to accidentally trigger when using a PivotTable. If you wanted to prevent your users from accidentally drilling in to a data set and littering the workbook with extra worksheets, how would you do it?