click below
click below
Normal Size Small Size show me how
Excel Lesson 10
Using Advanced Formulas
Question | Answer |
---|---|
Arguments | The parameters of a funtion |
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 wen filtering data |
Lookup Funtion | 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 |