Advanced Filter Scenarios In Excel, pt 2

In which we make a named criteria range grow and shrink, in order to incorporate it into our solution of the Scenario manager and Advanced Filtering. We take care NOT to name this range Criteria, but rather some other name, so that it is not replaced when the Advanced Filtering happens.

To understand this, you probably want to view the preceding post first.

Advanced Filter Scenarios In Excel

This makes use of things covered during class, but puts them together nicely.
Part 1 of X

Excel Final Review

Here is a review of the Microsoft Excel final, explaining in detail what I was looking for.

Question 1:


Question 2:


Question 3:



Question 4:



Question 5:


Question 6, 7:


Question 8:


Question 9:


Question 10:


Question 11:


Question 12:


Question 13: