A | B |
arguments | The parameters of a function |
conditional formula | A formula in which the result is determined by the presence or absence of a particular condition |
criteria | A condition you specify to limit which records are returned when filtering data |
lookup functions | An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook |
table | A range of cells in a worksheet that contains related data and can be used by a lookup function |
table array | Data in a table arranged in rows and columns |