What function does Excel insert at the end of a column in a table to add the column if you tick the TOTALS option on the TABLE DESIGN tab?

(A) =SUM()

(B) =COUNT()

(C) =AVERAGE()

(D) =SUBTOTAL()

Explanation

Excel inserts =SUBTOTAL() function at the end of a column in a table to add the column if you tick the TOTALS option on the TABLE DESIGN tab. The SUBTOTAL function adds the values of all visible cells.

Conclusion

This question is from the Quiz section of the second lesson “Analyzing Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap