1. Explain why it is better to utilize the Function Dialog box versus direct keyboard entry for some formula creations. Provide one specific function example of when you would use the Function Dialog box.
2. Provide a specific example of when you would use static data consolidation over dynamic data consolidation. Do not just explain the differences between the two, but provide a specific example of when you would use one over the other.
3. Now that you've learned some new functions in Chapter 6, which single function could you use for this task: Suppose you have a worksheet with cash amounts you have received for a fundraiser. You need to add up all of the amounts over $100 from donors living in Pennsylvania because your company will get a special tax break. Which function is best for this task and how would you use it?