Where is the subtotal function located? (in excel 2016)

1. under the formula tab on the ribbon in the function library group
2. under the home tab on the ribbon in the quicksum group
3. under the insert tab on the ribbon in the outlining group
4. under the data tab on the ribbon in the outlining group

The subtotal function is located at under the Data tab on the ribbon in the outlining group ( 4 )

Explanation:

The subtotal function in excel is used to calculate/return the subtotal of numbers in a column, in a list or in a database. the subtotal function is an in-built function in excel and it falls under the category of math/trig function

while using a worksheet you can enter the subtotal function like a formula in a cell of which you intend the return the subtotal of its column or line.

excel worksheet makes inputting and presentation of data that deals with figures easier than any other form of data presentation.

4

Explanation:

i think it is 4. well atleast for the Excel that i have on my laptop