Quiz

  1. 1
    Advanced

    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. 2
    Advanced

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

  3. 3
    Advanced

    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?