Key Words, Unit 2, Lesson One

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. Conditonal formatting: A format, such as cell shading or font color, that Excel automatically applies to a cell if a specified condition is true.

4. Custom filter: A list taken from with in 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 worksheets rows that contain realted 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 the 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. Extensible Markup Language: A format for delivering rich, structures 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 your 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 if the table array when using a LOOKUP function.

15. Named range: A word or string of characters that represents a cell, range of cells, formula, or constant value.

16. Processing statement: A statement in XML format that provides additional applications-specific information about the document; it begins and ends with a question mark.

17. Start-tag: The tag that begins an XML staement; for example, begins the Name field.

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: Afunction that searches for a value in the lefr-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: A consortium of commercial and educational insitutions that overseees research and promotes standards in all areas related to the World Wide Web.