Let's break this down step-by-step. Here’s how you would solve this Excel scenario: ### **Step 1: Understand the Task** You need to filter a list of new hires (in the "IT and Marketing Hires" worksheet) to show: - **IT department hires** with base salaries **greater than $70,000** - **OR** - **Marketing department hires** with base salaries **greater than $60,000** You’ll use **Advanced Filter** in Excel, which requires setting up a **criteria range**. --- ### **Step 2: Locate Your Data** Suppose your data table (on the "IT and Marketing Hires" worksheet) looks like this: | Name | Department | Base Salary | Other Columns... | |--------|------------|-------------|------------------| | Anna | IT | 75000 | ... | | Bob | Marketing | 62000 | ... | | Carol | IT | 69000 | ... | | Dave | Marketing | 60000 | ... | | Eve | IT | 80000 | ... | | ... | ... | ... | ... | --- ### **Step 3: Set Up Criteria Range** You need to create a **criteria range** somewhere on your worksheet. This is usually done just above or to the side of your data. #### **a. Criteria Range for OR Conditions** For OR conditions in advanced filter, you need to put each OR group in a different row, but use the same column headers. **Set up like this:** | Department | Base Salary | |------------|-------------| | IT | >70000 | | Marketing | >60000 | - **First row:** IT department, salary >70000 - **Second row:** Marketing department, salary >60000 --- ### **Step 4: Apply the Advanced Filter** 1. **Select your data table** (including headers). 2. Go to **Data** > **Sort & Filter** group > **Advanced…** 3. In the **Advanced Filter** dialog: - **List range:** Your data table (e.g. `$A$1:$C$100`) - **Criteria range:** The criteria you set up (e.g. `$E$1:$F$3` if you set up criteria in columns E and F, and rows 1-3) - Choose **Filter the list, in-place** or **Copy to another location** (as desired) --- ### **Step 5: Check Your Filtered Results** You should now see only the rows that: - Are in the IT department and have Base Salary > 70000, **or** - Are in the Marketing department and have Base Salary > 60000 --- ### **Step 6: Final Answer / Summary** **Summary Table of Steps:** | Step | Action | |------|--------| | 1 | Create a criteria range with Department and Base Salary as headers. | | 2 | Enter `IT` and `>70000` in the first row under those headers. | | 3 | Enter `Marketing` and `>60000` in the second row under those headers. | | 4 | Use the Advanced Filter with your data as the List range and your criteria as the Criteria range. | | 5 | View the filtered results. | **EXAMPLE OF CRITERIA RANGE (Assume columns E and F):** | E | F | |---------------|---------------| | Department | Base Salary | | IT | >70000 | | Marketing | >60000 | --- ## **Final Answer (Summary of Actions):** > **To filter for new hires from the IT department with base salaries greater than $70,000 OR from the Marketing department with base salaries greater than $60,000, set up a criteria range with two rows as shown above, then use the Advanced Filter tool, setting your data range and criteria range accordingly.** **This will display only the five hires (if there are five matching) who meet either of the specified conditions.**