What is automatically added after formatting data as a table? Data bars Filter drop-downs at top of columns Alternate light/dark rows Column headers
The Correct Answer and Explanation is:
Correct Answer: Filter drop-downs at top of columns
Explanation
When you format data as a table in programs like Microsoft Excel, filter drop-downs are automatically added at the top of each column. This feature is one of the key benefits of using the “Format as Table” tool in Excel.
These filter drop-downs allow users to easily sort and filter the data in each column. For instance, if you have a table of sales data, you can quickly sort the values from highest to lowest or filter to show only entries from a particular region or salesperson. This makes it much easier to manage and analyze large datasets without manually applying filters.
Although other features like alternate row shading (banded rows) and bold column headers are typically applied when you format data as a table, they can be customized or removed. However, the filter buttons are always included by default and are a defining characteristic of a table in Excel.
To further clarify why the other options are not the correct automatic feature:
- Data bars are a type of conditional formatting that must be applied manually. They visually represent the value of a cell using bars, but they are not added automatically when formatting a table.
- Alternate light/dark rows (also called banded rows) do usually appear with default table styles, but they can be turned off and are more of a visual style than a functional tool.
- Column headers are typically assumed to be the first row in the selected range, but if they don’t exist, Excel will prompt the user to specify whether the table has headers or not. They are not always created automatically.
Thus, the most consistent and functional feature automatically added is the filter drop-downs at the top of columns.
