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.

Computer Science & Information Technology

You might also like to view...

Smith decides that every thread in his processes ought to have its own protected stack – all other regions in a process would be fully shared. Does this make sense?

What will be an ideal response?

Computer Science & Information Technology

Changing the features of a theme can be done through the ________ tab

Fill in the blank(s) with correct word

Computer Science & Information Technology

What type of network connects containers to the same network as the host so that a container's network adapter will have an IP address in the same IP subnet as the host's network adapter?

What will be an ideal response?

Computer Science & Information Technology

A search engine lists the hits in a search results list in a certain order, usually with more relevant hits at or near the top of the list.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology