Question

tell true false. Consolidation helps in combining the data of multiple worksheets​

Answer 1

Answer:

TRUE

To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks.....

Answer 2

Answer:

Consolidation helps in combining the data of multiple worksheets​-TRUE

Explanation:

If you receive information in multiple sheets or workbooks that you want to summarise, the Consolidate command can assist you in gathering data onto a single sheet. If you have a sheet of expense figures from each of your regional offices, you could use a consolidation to roll these figures up into a corporate expense sheet. This sheet could include sales totals and averages, current inventory levels, and the top selling products for the entire company.

Examine the sheets you're combining to determine which type of consolidation to use. Consolidate by position if the sheets have data in inconsistent positions, even if their row and column labels are not identical. If the sheets' row and column labels for their categories are the same,

#SPJ3