Question

where is the subtotal function located?
under the formula tab on the ribbon in the function library group
under the home tab on the ribbon in the quicksum group
under the insert tab on the ribbon in the outlining group
under the data tab on the ribbon in the outlining group

Explanation:

In Microsoft Excel, the SUBTOTAL function is used for calculating subtotals in a list or database. It is located in the Function Library group under the Formula tab on the ribbon. This is where various functions for calculations (like mathematical, statistical etc.) are grouped. The Home tab's QuickSum group mainly has basic sum - related quick operations (not the SUBTOTAL function). The Insert tab's Outlining group is for tasks like inserting outlines, not functions. The Data tab's Outlining group is for data - related outlining operations (like grouping data) and not for the SUBTOTAL function.

Answer:

under the Formula tab on the ribbon in the Function Library group