Quiz

  1. 1
    Advanced

    You have the PivotTable showing below and create a new formula by clicking = then selecting B4. What will the formula look like?

  2. 2
    Advanced

    You have the PivotTable showing below and create a new formula by clicking = then selecting B4. You then select Accessories from the Slicer. What will the formula return?

  3. 3
    Advanced

    Which formula would return 0 if the required components were filtered out of the source Pivot Table?