Question

State the name of the function using which Consolidate performs addition​

Answer 1

Answer:

We’ve created a step-by-step guide to help you create your own consolidation by combining similarly organized data across multiple worksheets and workbooks.

The screenshots below will help you see an example of how to use the Excel consolidate function:

Step 1: Open all files (workbooks) that contain the data you want to consolidate.

Step 2: Ensure the data is organized in the same way (see example below).

Step 3: On the Data ribbons, select Data Tools and then Consolidate.

Step 4: Select the method of consolidation (in our example, it’s Sum).

Step 5: Select the data, including the labels, and click Add

Step 6: Repeat step 5 for each worksheet or workbook that contains the data you need included

Step 7: Check boxes “top row”, “left column”, and “create links to data source” (note you don’t have to tick these boxes if you don’t want labels or don’t want live links) and click the OK button.

Explanation:

Answer 2

Answer:

Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

Explanation:

mark me brainleist