Question

Which of the following functions are available in consolidate window?* a. Max b. Min c. Count d. All of the above​

Answer 1

Explanation:

option d is correct✅ answer

Answer 2

Option (d): All of the above functions are available in the consolidate window.

Explanation:

• If you have a collection of tables (or lists), you can merge (or consolidate) all of the data into a single table (or list). The (Data > Consolidate) dialogue box can be used for this.
• You can aggregate the corresponding values from up to 255 distinct worksheets into a single worksheet using (Data > Consolidate).
• Data from many sources can be combined on the same worksheet, on different worksheets within the same workbook, or even in different workbooks.