Question

Which step should ong follow before using the Subtotal option? a. Consolidate b. Rename Data C. Filter Data d. Sort Data​

Answer 1

Answer:

sort data is the correct answer for this question

Answer 2

Sort data option.

Explanation:

The SUBTOTAL function in Excel allows one to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc.

Thus, the SUBTOTAL  in Excel helps in analyzing the data provided.

One can go and click on the Data tab.

Then Go to the Outline group.

Then one can view the Subtotal button there.

One can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max.