7 – Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?
A. If a calculated item is contained by a field, then the subtotal summary function cannot be changed.
B. Sum, count, and average functions can be used as a subtotal.
C. Var and Varp functions cannot be used as a subtotal.
D. None of the above.
Answer:B
7 – Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?
A. If a calculated item is contained by a field, then the subtotal summary function cannot be changed. B. Sum, count, and average functions can be used as a subtotal. C. Var and Varp functions cannot be used as a subtotal. D. None of the above.