click below
click below
Normal Size Small Size show me how
NP Excel 8
New Perspectives in Microsoft Office 2013 Excel 8
Term | Definition |
---|---|
AND function | A logical function that returns a TRUE value if all of the logical conditions are true, and a FALSE value if any or all of the logical conditions are false. |
AVERAGEIF function | A function that calculates the average of values in a range that match criteria you specify. |
calculated column | A column in an Excel table in which a formula entered or edited in one cell of the column is automatically copied into to all cells in that column. |
COUNTIF function | A function that calculates the number of cells in a range that match criteria you specify. |
conditional formatting rule | A rule that specifies the condition, the formatting, and the cell or range to apply the rule to. |
SUMIF function | A function that adds the values in a range that match criteria you specify. |
DATEDIF function | A function that calculates the difference between two dates and shows the result in months, days, or years. |
HLOOKUP function | A lookup function that searches across the first row of the lookup table until the lookup value exactly matches a value in the first row, and then retrieves the corresponding value from the second row of the lookup table. |
IFERROR function | A function that can determine if a cell contains an error value and then display the message you choose rather than the default error value. |
logical condition | An expression that returns either a TRUE value or a FALSE value. |
nested IF function | One IF function placed inside another IF function to test an additional condition |
OR function | A logical function that returns a TRUE value if any of the logical conditions are true, and a FALSE value if none of the logical conditions are true. |
structured reference | The Excel table name or column header that you can use in a formula in place of its cell or range reference. |
TRANSPOSE function | A function that changes the orientation of a range—that is, return a vertical range of cells as a horizontal range, or vice versa. |