Excel Chapter 11

3. set of guidelines that specify what values to retrieve from a database and in what order the values should be retrieved
6. contains only text and numbers without any formulas, graphics, special fonts, or formatted text
12. contains each piece of data in an XML document that includes an opening tag, the element content, and a closing tag
13. lists all of the connections in the workbook
14. data in a database is stored in this and arranged in columns and rows
16. displays a collection of characteristics of a particular person, place, or thing
18. contains commands for retrieving and refreshing data from external sources
19. application that creates queries to retrieve data from multiple database tables and stores the data in a workbook
20. collection of data values organized in such a way that they can be easily retrieved and manipulated by the end user
21. marks the beginning of the data value and is represented as <

1. text file stored which each column starts at the same location in the text file
2. stores information about a specific characteristic of a person, place, or thing
4. provides location of a webpage
5. talbes are joined by common fields
7. structures data in text files that can be read by a wide variety of programs including Excel
8. displays the high, low, and closing values of a stock
9. defined process for retrieving data from an external file
10. text files stored which a special character such as a space, comma, or tab marks the beginning of each colummn
11. specifies which data should be retrieved from different section of a webpage
15. shows the structure of an xml document in a schematic diagram
17. marks the end of the data value and is represented as >