Unit 2 lesson 1 vocab.

• column index-the column number in the table array from wich the matching value must be returned.
• comment- text in visual basic added to code that explains how thw code works.
• conditional formatting- format such as cell shading or font color.
• custom filter- a list taken from within a larger lists where the only records shown are the rows that meet the criterria you specify for a column.
• data list- worksheets rows that contain related data.
• document element- top most element ina XML file.
• end tag- specifies the end of a element.
• export- to use data in another program.
• extensible markup language-strutured data from an application in a standard, consistent way.
• filter- list taken frrom within a larger list where the only records shown are the rows that meet the criteria you choose from a dro down list for a column.
• HLOOKUP- 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.
• interactive data- html file that contains special components that allow browser users to interact with the workbook.
• lookup value- value to be found in the first column of the table array when using a lookup function.
• named range- word or string of characters that represent a cell, range of cells, formula, or constant value.
• start tag-the tag that begins an XML statement.
• static data- data appears as it would in excel, including tabs that users can click to switch the worksheets.
• table array- the table information in wich data is lookedup when using LOOKUP function.
• VLOOKUP- a function that searches for a value in the left most column of a table.
• world wide web consortium- a consurtiom of commercial and educational institutions that oversees research and promotes standards in all areas related to the world wide web.