Multiple Choice
In terms of importing data from a website,which of the following is not true?
A) Excel has had a Web query tool since at least version 2010,but this option has been greatly improved in Power Query.
B) If you can see data of interest on a website,Power Query will always enable you to import the data into Excel.
C) Some websites have what look like tables of data,obvious candidates for importing into Excel.But even the new Web query tools in Power Query are not guaranteed to be able to import such data; it depends on how the website was created.
D) Once you find a URL with interesting data and you use Power Query to import the data,the steps to do so (navigate,edit,load) are basically the same as those for importing data from any other (non-Web) source.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: Business intelligence refers to the insights gained
Q12: Primary and foreign keys relate information between
Q13: Suppose you try to create a pivot
Q14: The flexibility of the measures created by
Q15: The pivot table functionality that has been
Q17: When there is a many-to-many relationship,it is
Q18: Which of the following most accurately explains
Q19: Excel Data Model is a recent Microsoft
Q20: A hospital has a database for which
Q21: Microsoft refers to the role of add-ins