Unit 2, Lesson 1 Key Terms

1. Column Index: The column number in the table array from which the matching value must be returned when using a LOOKUP function.
2. Comment: Text in Visual Basic added to code that explains how the code works. It begins with an apostrophe.
3. Conditional Formatting: A format such as a cell shading or font color, that Excel 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 labels for the columns.
6. Document Element: The top-most element in an XML file; it is used to name the table when imported into an application.
7. End Tag: The tag that specifies the end of an element; it is case-sensitive.
8. Export: To use data in another program.
9. Extensible Markup Language: 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 users 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 or string of characters that represents a cell range of cells, formulas, 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.
18. Static Data: Data appears as it would in Excel, including tabs that users can click to switch between worksheets; however, users cannot change or interact with the data in the browser.
19. Table Array: The table of information in which data is looked up when using a LOOKUP function.
20. VLOOKUP: A function 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.