Question

List out different tabs available in the subtotals dialog box?​

Answer 1

Answer:

Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total. You can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max. This video show how to use SUBTOTAL or the newer AGGREGATE function, to work with filtered data

Answer 2

Answer:

$\huge \sf\purple{\colorbox{white}{✴Answer✴}}$

The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data. For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order.