Question

Rudra has last year’s sales report of North, East, West, and South zones. He wants to combine all the data to view the total sales of every month. Which feature of Spreadsheet will he use?

Macros

Goal Seek

Sub Total

Consolidate​

Answer 1

Consolidate feature will be use.

Consolidate is used to merge the spreadsheets.

Answer 2

Consolidate.

Explanation:

Data consolidation is useful in cases where you want to summarize data from more than one source.

This source data could be within the same Excel workbook on different worksheets.

It could also be in one or more different workbooks altogether. 'Consolidate' allows one to merge data from several worksheets and files.

Steps:

1. First press Alt + F8 to open the Macro dialog.

2. Then under the under Macro name, select MergeExcelFiles and click Run.

3. The standard explorer window will open, one has to select one or more workbooks they want to combine, and then click Open.