Question

Q-1

Prepare worksheet as given below and do as directed:

2. Data for Consolidation

1. Add two worksheets in the file and modify the data for all

4 quarters.

2. Rename all worksheets like sheet1 – 2018, sheet2 – 2019

and sheet3 – 2020.​

Answer 1

Answer:

The smell of the melted butter tickled my nostrils.

Answer 2

The worksheet prepared is given below:

The same steps are as follows:

1. Open all workbook files containing the data one wants to compile.

2. Make sure the data is organized in the same way.

3. For Data Ribbons one must select Data Tools and Merge.

4: Then one can choose the combination method.

For example, in the case of a budget, Excel can be used to compile financial statements for multiple departments and then combine the statistics into a single centralized entity or finance employer.

Data aggregation is an in-house Excel tool that allows you to compile statistics in different workbooks and combine them into a single workbook.