Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

02 Jan 2022

1

Question 9 of final for Data Analysis of Excel Pivot Tables

I looked in the Q&A trying to find any one else who may have asked the same question.

Also just noted that the automatic "Category" drop-down of the course name the value needs to be extended for the max name's of the course's.
I had to manually shorten the title to less  than 25 characters. I had to change to 'Other'

I don't understand how the correct anser is "None of the above"; for Question 9 of the Final Test.

Using the 'Wholesale database.xlsx; I created the pivot table and slicers for '2019' and the Manufacturer of Barilla getting the following: =GETPIVOTDATA("Revenue",$A$3,"Year",2019,"Manufacturer","Barilla")
Looking at the Pivot table the first cell of it is clearly A3 and not A1 as explained
in the answer, can someone explain what I am having trouble understanding?

I am trying to understand how the start  of the Pivot table starts with A1 vs A3? It appears to start with A3.

Snapshot:
image.png

0 answers ( 0 marked as helpful)

Submit an answer