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?

Supporting image for quiz question

Answer 1

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

Answer 2

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 3

It is not possible to do this easily

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

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

Answer 10

Delete the original data table

Answer 11

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

Answer 12

Don’t know

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?

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

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?