Answer to Question #30921 in Management for Bob

Question #30921
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.
1
Expert's answer
2013-05-22T09:10:21-0400
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.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS