Question

Which statement best describes an advantage of using the Subtotal dialog box?

1)Only one function, Add, can be used to combine data quickly.
2)Data from multiple workbooks can be combined in a single step.
3)An option is available that can customize any function available in Excel.
4)Data can be summarized using a single step rather than by writing multiple formulas.

Answer 1

I think it's 2 i'm not sure

Answer 2

The Correct Answer is

Data from multiple workbooks can be combined in a single step.

Step-by-step explanation:

• The Microsoft Excel semi-total work exchanges the subtotal of the characters in a string in a table or database.
• The SUBTOTAL work is an in-built office in Excel that is characterized as a Math Function.
• As a worksheet role, the SUBTOTAL function can be accessed as the portion of a method in a group of a worksheet.