Which list shows the correct order for importing XML data to an Excel worksheet?

A. in the XML group, click Import → click the Developer tab → select the desired XML file → click Import

B. click the Developer tab → in the XML group, click Import → select the desired XML file → click Import

C. select the desired XML file in the XML group → in the XML group, click Import → click the Developer tab → click Import

D. click Import → click the Developer tab → in the XML group, click Import → select the desired XML file

Question

Computers & Technology

Gillespie

12 January, 06:26

Which list shows the correct order for importing XML data to an Excel worksheet?

A. in the XML group, click Import → click the Developer tab → select the desired XML file → click Import

B. click the Developer tab → in the XML group, click Import → select the desired XML file → click Import

C. select the desired XML file in the XML group → in the XML group, click Import → click the Developer tab → click Import

D. click Import → click the Developer tab → in the XML group, click Import → select the desired XML file

+3

Answers (1)

Know the Answer?

Dayanara · Answer 1

In the XML Map, select one of the mapped cells.

Click Developer > Import.

If you don't see the Developer tab, see Show the Developer tab.

In the Import XML dialog box, locate and select the XML data file (. xml) you want to import, and click Import.