Question

6.Click subtotals option is available under __________ menu to open subtotals dialog box.

(1 Point)


​

Answer 1

Answer:

the answer is data

Explanation:

Please Mark as Brianlist

Answer 2

Answer:

Click the subtotals option available under the data menu to open subtotals dialog box.

Explanation:

The Subtotal option of Microsoft Excel allows us to automatically group our data and use common formulas like Sum, Minimum, Maximum, Average, Count, etc. Provides the facility to analyze data. It is more commonly used for making sales reports and for financial activities.

These commands simplify our analysis by summarizing our data

Use Subtotal Option

• We will select the data in which the subtotal option is to be used or will activate the data by clicking there with the mouse.
• Click on the Data Tab on the Ribbon. All the commands related to this tab will be displayed on the screen.
• Here you will see the Outline Group on the right side. Where the Subtotal option will be displayed.
• On clicking Subtotal, the Subtotal dialog box will appear on the screen.
• Add the details and you will get the subtotal.

#SPJ3