Question

Which function enables you to group and summarize your data?

A. AND



B. SUBTOTAL



C. ROUND



D. SUMIF

Answer 1

B. subtotal ur welcome

Answer 2

B. SUBTOTAL

Step-by-step explanation:

The SUBTOTAL function in Excel helps us calculate the subtotal of a list of values. The interesting thing is that we can indicate to the SUBTOTAL function the type of operation that we want to apply on the values.

Remember that the SUBTOTAL function in Excel will always apply the function indicated on the ranges of cells provided as arguments.