12
QuizMultiple Choice

Unit Test — Unit test

Question 12 • Business Information Management

Where is the SUBTOTAL function located?

Answer
A
under the Formula tab on the ribbon in the Function Library group
B
under the Home tab on the ribbon in the QuickSum group
C
under the Insert tab on the ribbon in the Outlining group
D
under the Data tab on the ribbon in the Outlining group

Explanation

In Excel, the SUBTOTAL command is found on the Data tab in the Outline group (sometimes labeled Outlining in course materials). It lets you calculate a subtotal for a list, such as a sum or average, and can work with filtered data. Therefore, the correct choice is “under the Data tab on the ribbon in the Outlining group.”

AI-written and checked against the verified answer.

Previous
Next