Question

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

Answer 1

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters to filter a list so it shows only those items you are interested in seeing and you can create PivotTables to look at your data in different ways. You can also consolidate large amounts of data into a summary form which can show you as much or as little of your data as you want to see. In this post, I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets - or workbooks - and summarize them into a single worksheet.