or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01

 Flashcards Matching Hangman Crossword Type In Quiz Test StudyStack Study Table Bug Match Hungry Bug Unscramble Chopped Targets

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

NP Excel 8

New Perspectives in Microsoft Office 2013 Excel 8

TermDefinition
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.
Created by: skindawg