Filter the Participants table to display only records with a Atlanta in the city field on excel.
To filter the Participants table in Excel and display only records with "Atlanta" in the city field, you can follow these steps:
1. Select the entire table, including the headers.
2. Go to the "Data" tab in the Excel ribbon.
3. Click on the "Filter" button, which will add filter arrows to the headers of each column.
4. Click on the filter arrow on the "City" column header.
5. In the dropdown menu, uncheck the "(Select All)" option to clear all selected options.
6. Scroll down and check only the box beside "Atlanta" to filter for that city.
7. Click on the "OK" button to apply the filter.
8. The table will now display only the records with "Atlanta" in the city field.
Note: If the Participants table is not a table format, you can select the range manually and follow the same steps.