Creating Web Queries in Excel 2010

Introduction: Excel provides a tool, called Web queries, that allows users to import live Web data and chart this information in an Excel spreadsheet. Although this tool might look complicated, Web queries are fairly simple to use.

Find out more about Web queries and how to create them.

This activity contains 13 questions.

	A Web query is an Excel tool that __________.   allows you to import the Google query tool into a spreadsheet allows you to export data to a Web page from within a spreadsheet allows you to import Web data and chart information into a spreadsheet interacts with the query language of Microsoft Access

	Web queries are useful because __________.   Web-based analysis tools can be used to analyze the Excel data the data from the Web is updated easily they require only that you know Perl the data from the Web is entered manually

	Which of the following features can be used on imported Web data?   Functions pivot tables Charts all of the above

	Which of the following statements about Web queries is FALSE?   Web queries can be set to automatically refresh periodically. Web queries can be saved only in XML format. Imported data can be reorganized. A query can be imported into a workbook.

	When importing Web query data, the data on the Web page that can be imported is indicated with a(n) __________.   arrow green border red border dashed border

	When importing Web query data, the data on the Web page that is selected for import is indicated with a(n) __________.   check box blinking border plus sign arrow

	When viewing a Web page in Internet Explorer, you can import all the data by right-clicking and selecting the __________ option.   Copy Page Export to Microsoft Excel File/Import Web data Select Data

	When using Web query data, you should __________.   refresh the data every week pay the data use royalty fee specified on the Web site delete the query data from your spreadsheet after 30 days comply with any applicable terms and conditions of the Web site owner

	Imported data in a Web query can be refreshed __________.   only at specific time intervals only when the workbook is closed when the workbook is opened or at specific time intervals only when the workbook is opened

	To create a Web query __________.   you must have knowledge of Web page design you need to create an Excel macro you should be a programmer you need no knowledge of Web page design or programming

	Microsoft Office Tips Task: View information on managing Web queries. Assignment: Visit www.microsoft.com, and use the Search feature to find information on how to manage Web queries. Read one article, and summarize your findings.   To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

	More About Web Queries Task: Learn more about Excel's Web queries. Assignment: Visit www.homeandlearn.co.uk/excel2007/excel2007s8p5.html and answer the following questions. In addition to From Web, what are two other external data sources in Excel? What are the three formatting options displayed in the Web Query Options dialog box? What are the four viewing options displayed in the Import Data dialog box? What did the Web site say was the problem with using the importing full HTML option in the second example?   To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

	Test Excel's Refresh Feature Task: See if data imported from a Web site can be updated. Assignment: Use Excel's Web query feature by going to CNN's Market Web site, money.cnn.com/data/markets. Select the table showing the Dow, NASDAQ, S&P, and so on, import it into Excel, and print the spreadsheet. Note the time indicated in cell B1. After waiting a few minutes, click the Refresh All button located in the Connections group on the Data toolbar. The time will change, and the values in Columns C, D, and E might change as well. Once again, print the spreadsheet, and compare the two printouts. Submit the printouts to your instructor.   To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

Copyright © 1995 - 2012 Pearson Education . All rights reserved. Pearson Prentice Hall is an imprint of Pearson . Legal Notice | Privacy Policy | Permissions