Knowee
Questions
Features
Study Tools

Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.Font Size

Question

Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here are the steps to use AutoFilter in Microsoft Excel to filter your query results:

  1. Open your Excel workbook and navigate to the worksheet that contains your data.

  2. Click anywhere inside the data set that you want to filter.

  3. Go to the "Data" tab on the Ribbon, then in the "Sort & Filter" group, click "Filter". This will add drop-down arrows to each column header.

  4. Locate the column labeled "StaffID". Click the drop-down arrow next to the column header.

  5. In the drop-down menu, uncheck the "Select All" box to remove all current filters.

  6. Scroll through the list and check the boxes next to "Mo" and "Shannon".

  7. Click "OK". The data in your worksheet will now be filtered to show only records where the StaffID is either "Mo" or "Shannon".

Remember, the filter will remain in place until you clear it. To clear the filter, click the "Filter" button in the "Sort & Filter" group on the "Data" tab.

This problem has been solved

Similar Questions

Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.Font Size

Use AutoFilter to filter the query results first to show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.

From the current view (Design view), change the Field Size property for the StaffID field to 7.

How do you select all the records from a table named staff where the value in last_name column begins with "Stark"?

Write a query to display all the customers whose ID is 2001 below the salesperson ID of Mc Lyon.

1/1

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.