Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Spreadsheets Un 6
Unit 6 Spreadsheets vocabulary
| Question | Answer |
|---|---|
| AND function | A logical function that returns a TRUE value if all the logical conditions are true a FALSE value if any or all of the logical condtions are false |
| AVERAGEIFS function | A function that calculates the average of values within a range of cells that meet multiple conditions |
| COUNTIF function | A function that calculates the number of cells in a range that match criteria you specify (Conditional Count) |
| Criteria range | An area in a worksheet, separate from the range of data or table, used to specify the criteria for the data to be displayed after the filter is applied to the table |
| IFERROR function | The function used to determine if a cell contains an error value and displays the message you chose rather than the default error value |
| Lookup value | The value you are trying to find or retrieve from a lookup table |
| OR function | A logical function that returns a TRUE value if any of the logical conditions are true or FALSE value if all the logical condtions are false |
| Structured reference | Table name or table column header that you can use in a formula in place of its cell or range reference |
| SUMIF function | A function that adds the values in a range that meet criteria you specify; also called conditional sum |
| VLOOKUP function | – A function that searches vertically down a lookup table to retrieve a value from that table; used when the compare values are stored in the first column of the lookup table |
Created by:
judyshipp
Popular Business sets