Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

Digital Marketing, Fiverr Microsoft Excel Test Answers

Are you looking for an answer to the question “Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?”? If that’s the case, congratulations! You’ve arrived to the right place. Throughout this post, I will help you by answering your question correctly.

Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

Options

· If a calculated item is contained by a field, then the subtotal summary function cannot be changed.

· Sum, count and average functions can be used as a subtotal.

· Var and Varp functions cannot be used as a subtotal.

· None of the above.

The Correct Answer Is:

· Sum, count and average functions can be used as a subtotal.

Warming Up

I hope I was able to provide you with the correct answer to your question “Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?”. The above question was asked in the Fiverr Microsoft Excel Test. I appreciate your trust in this website. Additionally please keep checking back to this site for more answers to questions from more other certification exams.