40 q multiple chose in BISM1200

creating_web_queries_soundbyte1.docx

Home >Computer Science homework help >40 q multiple chose in BISM1200

BISM 1200 Introduction to Computing Sound Byte Lab Chapter 4

Creating Web Queries in Excel 2010

Introduction: Excel provides a tool, called Web queries, that enables 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.

1. A Web query is an Excel tool that __________.

a. enables you to export data to a Web page from within a spreadsheet

b. enables you to import the Google query tool into a spreadsheet

c. interacts with the query language of Microsoft Access

d. enables you to import Web data and chart information into a spreadsheet

2. Web queries are useful because __________.

a. the data from the Web is entered manually

b. the data from the Web is updated easily

c. Web-based analysis tools can be used to analyze the Excel data

d. they require only that you know Perl

3. What statement about exporting data directly from a Web page is TRUE?

a. This feature works in Firefox or Internet Explorer.

b. Excel doesn’t need to be opened prior to exporting the data.

c. The data on the page using this method is NOT refreshable.

d. All of the above

4. Which of the following statements about Web queries is FALSE?

a. Web queries can be saved only in XML format.

b. A query can be imported into a workbook.

c. Imported data can be reorganized.

d. Web queries can be set to automatically refresh periodically.

5. Which of the following statements about Web queries is FALSE?

a. They were introduced into Excel in the 1997 version.

b. They enable you to import live Web data and chart information into your Excel spreadsheet.

c. Once data is imported, the data becomes static.

d. Web queries are like having mini-browsers inside your Excel workbook.

6. When importing Web query data, the data on the Web page that is selected for import is indicated with a(n) __________.

a. check box

b. arrow

c. blinking border

d. plus sign

7. If you start with the Web page open and find something you want to convert to an Excel spreadsheet, you can right-click on the Web data and choose ________.

a. Copy to Microsoft Excel

b. File/Import Web data

c. Export to Microsoft Excel

d. Link to Microsoft Excel

8. Which statement is TRUE regarding Web queries and ethics?

a. Once data has been exported, you become the owner of that data.

b. Some data is protected and blocked by Websites from the use of Web queries.

c. If you retrieve data from a Website, there are no regulations that you need to follow.

d. If data is loaded onto a Website, it means that the owners expect you to use the data as you choose.

9. Which tab do you use to start a Web query?

a. Data

b. Insert

c. Web

d. Formulas

10. To create a Web query, __________.

a. you must have knowledge of Web page design

b. you should be a programmer

c. you need to create an Excel macro

d. you need no knowledge of Web page design or programming