Answer to Question #30921 in Management for Bob

Question

One of the resulting actions of converting a table to a range is:


A. the cells clear themselves of the table data.

B. the cell data can now be sorted.

C. the cells can no longer have formulas created for them.

D. list arrows are removed from the column titles.

Answer 1

The correct answer is C. After converting the table to a range table functions are not available. For example, the row headers no longer include arrows for sorting and filtering, as used in formulas structured references (references that use table names) will be converted to regular cell references.