Answer to Question #30921 in Other Management for Bob
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.
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.
I think I'm satisfied. I didn't really understand the last 2 projects you completed for me so i don't know if they were missing anything. I will note that the first 4 projects did contain small errors or did not incorporate all the instructions but these were easy fixes and helped with my learning experience. i will use your service again if the need ever arises.