Case-Based Critical Thinking Questions
Case 11-2
Sadra works for a local travel agency.She uses the agency's Web site to promote the latest tours.She uses Access to store information concerning the tours and Excel to analyze the data.Fall tours include trips to Honolulu,Seattle,Chicago,and Denver.Spring tours include trips to Washington,D.C. ,New Mexico,Alaska,and Montana.Summer tours include Paris,Rome,Denmark,and Australia.
-Sadra learns that an advantage of using XML elements in a worksheet is that it allows the user to attach elements to specific cells.To map an XML document directly into an Excel table,Sadra should click the From Other Sources button in the Getting External Data group on the Data tab,and then click ____.
A) From XML Document
B) From XML Source
C) From XML Documentation
D) From XML Data Import

Question

Quizplus · Accepted Answer

The correct option is "From XML Data Import" because it allows users to import XML data directly into Excel, which is what Sadra needs to do to map an XML document into an Excel table.