Discuss and compare the data consolidation and What-If analysis Excel tools.Unde

Discuss and compare the data consolidation and What-If analysis Excel tools.Under what circumstances would you use each of these tools? Do they both serve the same purpose or is each one used under different scenarios? Give examples of how each can be usedWe will be talking about grouping worksheets; WHAT IS A MAJOR FACTOR OF IMPORTANCE WHEN GROUPING OR UNGROUPING WORKSHEETS? Remember you when you make a change in one worksheet it changes EVERY WORKSHEET in the group you have selected. In other words what are some of the pitfalls to avoid when grouping worksheets?WHAT IS THE DIFFERENCE BETWEEN A WORKBOOK AND A WORKSHEET GROUP? WHY MIGHT YOU WANT TO GROUP WORKSHEETS? CAN YOU GIVE SOME EXAMPLES WHERE GROUPING SHEETS CAN BE HELPFUL?