Discuss and compare the group summations and What-If analysis (Consolidation) for Excel tools. (google group summations and What-if Analysis for Excel) to answer the questions:

Under what circumstances would you use each of these features? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.

Please include your research references in APA format.

This comes from our book but need to find other examples to answer the above questions:

This week, we will also be looking at What-If Analysis. In addition to the functionality we experienced using our Excel calculator; we can take advantage of several tools Excel provides to do What-If analysis. To illustrate, let's take a look at planning a dream vacation to Hawaii. What-If analysis begins with setting up a set of data. Within that set of data, there will be multiple dependencies. For example, our trip to Hawaii will include airfare for all of the travelers. It may later be possible to change the number of travelers. Therefore, we want to split apart the cost of airfare from the number of travelers. Later, we will be able to change the number of travelers and see how that impacts the overall cost of the trip. We can set up a budget for lodging, new clothes, food, and entertainment based on the number of days or nights we are staying. The total cost of the trip will vary depending on how many days we stay in Hawaiiand perhaps the amount of money we allocate