discussion data consolidation

1. Discuss and compare the group summations and consolidation tools used with Excel. You may need to look up (research) the group summations.
2. 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.