CS 150 Saginaw Valley State University Chapter 14 Advanced Filtering Problem

Problem 1) Build an advanced filter that brings back only certain people from Saginaw (zip code of 48603), certain people from Bay City (zip code of 48706) and anyone from the city of Frankenmuth. This query for the filter (including the heading row), should be from row 1 through row 4.

Problem 2) Copy over the filter from Problem 1. We now want to only find people that are from the desired cities but that also hold job codes 104 or 203. The query portion will now be on rows 1 through 7.

Problem 3) Copy over the filter from Problem 2. We now only want to bring back the employees matching the city and job code criteria that were hired anytime between the start of 1995 and the end of 1998. This criteria is more complicated that the one in the notes and simply sequencing the dates in a specific order isn’t going to work. What we need to do is have two Original_Hire_Date columns, so copy the cell contents from cell J1 to cell I1. You will then put the beginning date criteria (>=1/1/1995) in column I and the ending date criteria (<=12/31/1998).

Once you have the filtering for this problem working, add a comment to cell I1 that tells why the column name was changed from Home_Phone_Number to Original_Hire_Date. When I say comment this time, I mean New Comment from under the Review tab.