To detach an Excel table from its data source,select a cell in the table,click the Table Tools Design tab,and then,in the External Table Data group,click the ____ button.
A) Unlink
B) Detach
C) Remove Source
D) Embed

Question

Quizplus · Accepted Answer

To detach an Excel table from its data source, we need to unlink it. Hence, option A) Unlink is the correct choice. Option B) Detach and option D) Embed are not the correct choices, as there is no specific command in Excel with these names. Option C) Remove Source is not the correct choice, as it only removes the data source link, not the link between the table and the data source.

To Detach an Excel Table from Its Data Source,select a Cell