- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
25 Cards in this Set
- Front
- Back
|
INDIRECT
|
Returns the reference specified by a text string.
|
|
MATCH
|
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
|
|
INDEX
|
Returns a value or the reference to a value from within a table or range. There are two forms of the INDEX function: the array form and the reference form.
|
|
ROUND()
|
1. Rounds a numeric value to whatever level of precision you choose.
|
|
MROUND()
|
Rounds to the nearest specified multiple.
|
|
CEILING()
|
Combines the MROUND() and ROUNDUP() functions.
|
|
FLOOR()
|
Combines the MROUND() and ROUNDDOWN() functions.
|
|
INT()
|
Removes extra digits without performing any rounding.
|
|
TRUNC()
|
Removes extra digits except you can specify the number of decimal places you want to preserve.
|
|
EVEN()
|
Rounds up to the nearest even number.
|
|
ODD()
|
Rounds up to the nearest odd number.
|
|
SUM()
|
Adds the arguments contained in it.
|
|
COUNT()
|
Counts the number of cells that contain numbers, and counts numbers within the list of arguments.
|
|
COUNTA()
|
Counts the number of cells that are not empty in a range.
|
|
COUNTBLANK()
|
Counts empty cells in a specified range of cells.
|
|
MAX()
|
Returns the largest value in a set of values.
|
|
MIN()
|
Returns the smallest value in a set of values.
|
|
LARGE()
|
Returns the k-th largest value in a data set. Use this function to select a value based on its relative standing.
|
|
SMALL()
|
Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.
|
|
IF function:
|
Returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
*arguments = 3 *total allowable nested IF functions = 64 *If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out. |
|
OR function:
|
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
*arguments = 1 minimum |
|
AND function:
|
Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
*arguments = 1 minimum *a common use of AND is to expand the usefulness of other functions that perform logical tests. |
|
HLOOKUP
|
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
*four arguments, 3 required. |
|
VLOOKUP
|
Used to search the first column of a range of cells, and then return a value from any cell on the same row of the range.
*four arguments, three required. |
|
Array:
|
Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.
*An orderly arrangement. *Lay out orderly or logically in a line or as if in a line. |
