Another benefit of working with an Excel table is the built-in filters. When the column headers replaced the column letters, drop-down arrows appeared next to the names. These drop-down menus can be used to filter and sort the data in the table.
Filters can be used to show only the data that a user wants to see. For example, someone working with this budget data may want to see how much was spent on a specific category such as supplies or payroll or maybe how much income was received within a specific time frame.
In this exercise, you will filter the table to see only the Advertising expenses and then adjust the Total Row to show the sum.