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

Correct order for importing XML data to an Excel worksheet click Import → click the Developer tab → in the XML group, click Import → select the desired XML file

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

Explanation:

Xml is file which contains multiple tag contains, Normal format of xml is <named tag> data or value </named tag>.

Xml editor or notepad++ or internet edge been used to open xml file. Xml file mostly a text files. Where it user for configure the software or using in programming language. Some programming languages use most effective the xml for storing the some data.

Xml file has also have some limitations and search name tag will slow the access of xml file’s.

End user has to open MS-excel or office 365. Click on developer and click on import and select the xml file, MS-excel will import the files.