Question

When you convert a data set to an Excel Data Table, it automatically does the following except?

1) Applies formatting to the data
2) Creates a table with headers
3) Adds filter and sort options
4) Calculates formulas automatically

Answer 1

Converting a dataset to an Excel Data Table adds formatting, headers, and filter and sort options, but does not automatically calculate formulas.

Step-by-step explanation:

When you convert a data set to an Excel Data Table, the following actions occur: The data is formatted, a table with headers is created, and filter and sort options are added. However, Excel Data Tables do not automatically calculate formulas. Formulas in Excel tables will update automatically when new data is added to the table, but the initial act of converting to a table does not by itself trigger any calculations.