True/False
Amin wants to extract data from a Pivot table he has created for items sold in the East region of his company in a year. The table contains the following entries: Cells A1, B1, A3 and B3 have the headings "Region," "East", "Items" and "Sum" in them respectively. Cells A4 to A6 has the names of Items: A3 sheets, A4 sheets and A5 sheets in them, respectively. Cells B4 to B6 had their respective selling prices. Cells B7 has the title "Grand Total" and cell C7 has the grand total of all selling prices in the table. To calculate the total for the item, A4 sheets, Amin can use the formula: =GETPIVOTDATA("Total","Product","A4 sheets").
Correct Answer:

Verified
Correct Answer:
Verified
Q4: In which of these boxes will you
Q5: How can one filter a PivotTable using
Q6: To illustrate different data levels using small
Q7: After drilling down,Esteban wants to drill up
Q8: Ned wants to calculate the total sale
Q10: Which of the following will you select
Q11: If Power View is enabled,one can create
Q12: Portia wants to create a calculated measure
Q13: Marcos wants to refresh the data in
Q14: A student creates data for trees in