Question

What do you mean by consolidating data? Write the options available in

consolidate dialog box.

plz tell answer for me ...
​

Answer 1

${ \huge{ \fcolorbox{pink}{pink}{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

Answer 2

If you have a group of tables (or lists) it is possible to combine (or consolidate) all this data into one table (or list). This can be done using the (Data > Consolidate) dialog box. You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet.