Unit 2, Lesson 1 Key Terms

1. Column index-The index number in the table array from which the matching value must be turned when using LOOKUP function.
2. Comment- Text in visual Basic added to code that explains how the code works. It begins with an atmosphere.
3. Conditional formating- A format, such as cell shading or font color, that Exel automatically applies to a cell or group of cells if a specified condition is true.
4. Custom filter- A list taken from within a larger list where the only records shown are the rows that meet the criteria you specify for a column.
5. Data list- A series of worksheet rows that contain related data. The first row of the list has levels for the columns.
6. Document element- The top-most element in an XML file; it is used to name the table when import into an application.
7. End-tag- The tag that specifies the end of an element; it is case-sensitive. For example, is an end-tag for the Name field
8. Export- To use data in another program
9. Extensive Markup
   Language (XML)- A format for delivering rich, structured data from an application in a standard, consistent way.
10. Filter- A list taken from within a larger list where the only records shown are the rows that meet the criteria you choose from a drop-down list for a column.
11. HLOOKUP- A function that searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table.
12. Import- To use data from another program
13. Interactive data- An HTML file that contains special components that allow browser user to interact with the workbook.
14. Lookup value- The value to be found in the first column of the table array when using a LOOKUP function.
15. Named range- A word string of characters that represent a cell, range of cells, formula, or constant value.
16. Processing statement- A statement in XML format that provides additional application-specific information about the document; it begins and ends with a question mark.
17. Start-tag- The tag that begins an XML statement; for example, begins the Name file.
18. Static data- Data appears as it would in Exel, including tabs that users can click to switch between worsheets; howeve, the users cannot change or interact with the data in the browser.
19. Table array- The table of imformation in which data is looked up when using a LOOKUP function.
20. VLOOKUP- Afunction that searches for a value in the left-most column of a table, and then returns a value in the same row from a column you specify in the table.
21. World wide Web Consortium (W3C)- A consortium of commercial and educational institutions that oversees research and promotes standards in all areas related to the World Wide Web.