click below
click below
Normal Size Small Size show me how
TDA Spreadsheets
TDA Spreadsheets terms
| Term | Definition |
|---|---|
| Complex table | a complex table may contain elements like formulas, nested tables, merged/split cells, captions or may be a table comprised of multiple tables merged into one or formatting a multi-page table |
| Embed | to place a file from a source file to a destination file without maintaining a connection between the two files |
| Nested table | a table inserted within the cell of another table |
| Form | an area of a web page that allows the viewer to enter data and information to be sent back to the web server |
| Table of contents | a listing of the major entries in a publication |
| Index | an alphabetical listing of key words, phrases or topics that includes the page numbers where the items are found in the publication |
| IF | a logical function that returns one value if the statement is true and another value if the statement is false |
| PMT | a spreadsheet financial function used to calculate the amount paid into an investment or loan during each payment period |
| Lookup | a spreadsheet function that looks up a value in a defined range of cells located in another part of the workbook to find a corresponding value. The lookup function can be vertical (VLOOKUP) or horizontal (HLOOKUP) |
| Conditional formatting | a setting that applies formatting only when a cell's value meets a specified condition |
| Macro | a series of stored commands that can be executed whenever the user needs to perform a special task |
| Linking | placing a copy of an object or data in a destination file that will automatically update when changes are made to the source file |
| Filter | a process used to temporarily hide data that does not meet the specified criteria |