Hillary wants to use excel to export data as an xml file. she first inserts all of her data into excel. then she creates a schema and saves it as an xsd file. hillary then opens excel and begins working, using the developer tab to export her excel data. which steps must hilary perform before she can export the data?

a. she must add the schema to excel, and then she must map the elements from the tree onto the worksheet.
b. she must map the elements from the tree onto the worksheet, and then she must add the schema.
c. she must import the xml file, and then she must add the schema to the excel file.
d. she must add the schema to the excel file, and then she must import the xml file.

Hilary must add the schema to the Excel file, and then she must import the XML file before she can export the data.

D. She must add the schema to the Excel file, and then she must import the XML file.

Explanation:

In excel where data are stored and referenced with rows and column, for example D4 referred as “D” is column and “4” is rows.

So end user can enter the data or import data or copy and paste in each cells or selected cells.

To save excel to xml format is just click “FILE” menu and select “SAVE AS” and select the file type and select xml it will prompt for filename and save. Note that cell to me mapped properly before saving the data.

Xml is format where data is stores in flat file or plain files. Where or rows first under columns are stored.

b. related objects

explanation:

data is stored in related objects in an access database.