What is a web query? How is it used to import data into Excel?
What will be an ideal response?
A web query allows you to import web data directly into an Excel spreadsheet. The web query also creates an active link to the website so the data can be easily refreshed as it changes. This is especially useful for financial or statistical data that changes frequently. By going to the Data tab and using the From Web button in the Get External Data group, you can access predefined web queries or create your own. These queries can be edited and filtered to customize the results as they appear in Excel.
You might also like to view...
Answer the following statements true (T) or false (F)
1. External output differs from internal output in its distribution, design, and appearance. 2. Display screen output has a distinct advantage over printed output because of the quietness and potential for interaction. 3. If many users in the business need different output at different, short periods of time, and they need it quickly, then printed output is the best alternative. 4. Output is best thought of as a neutral product to be subsequently analyzed and acted upon by decision makers.
An administrator has received a call indicating that some users are having difficulty logging on after a password change. Which FSMO role should be investigated?
A. Schema master B. PDC emulator C. RID master D. Infrastructure master