Term
|
Definition
Payment of a loan based on constant payments/rate
=PMT(rate,nper,pv) |
|
|
Term
|
Definition
Mean list of values
=median(range) |
|
|
Term
|
Definition
Count non empty cells
=counta(range) |
|
|
Term
|
Definition
Most frequently occurring number in a list
=mode(range) |
|
|
Term
|
Definition
Change the contents of a cell based on criteria
=if(logical test, (true value), (false value) |
|
|
Term
|
Definition
Information returned from a table
=vlookup(lookup value, table array, independent number) |
|
|
Term
|
Definition
| Change the appearance of a cell based on criteria |
|
|
Term
|
Definition
Eliminate a decimal part of a number
=trunc(number) |
|
|
Term
|
Definition
Displays date and time
=now() |
|
|
Term
|
Definition
find the lowest number in a range
=min(range) |
|
|
Term
|
Definition
find the highest number in a range
=max(range) |
|
|
Term
|
Definition
Displays date and time
=today() |
|
|
Term
|
Definition
Count cells based on criteria
=countif(range,criteria) |
|
|
Term
|
Definition
Return the sum of products of the corresponding ranges or arrays
=sumproduct(range,range) |
|
|
Term
|
Definition
Count the number of cells that contain numbers
=count(range) |
|
|
Term
|
Definition
Format number to specific digits
=round(number,number) |
|
|
Term
|
Definition
| Finding the right insput when you know the result you want |
|
|
Term
|
Definition
Join several text strings together
concatenate=(text 1, text 2, text 3) |
|
|
Term
|
Definition
| The unique address of a cell |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Join several cells into one |
|
|
Term
|
Definition
| A prewritten formula built into excel |
|
|
Term
|
Definition
| Check which cells are reference sin the formula assigned to the active cell |
|
|
Term
|
Definition
| Allows you to select cells for use in formula with a mouse |
|
|
Term
|
Definition
| Format for fixed dollar sign |
|
|
Term
|
Definition
| Format for Floating dollar sign |
|
|
Term
|
Definition
| Allows you to create or modify a worksheet while viewing what it looks like printed |
|
|
Term
|
Definition
| Display the formulas version |
|
|
Term
|
Definition
| Clears date and resets format when used |
|
|
Term
|
Definition
| Leaves format and data intact |
|
|
Term
|
Definition
|
|
Term
|
Definition
| ___ is inserted to the left |
|
|
Term
|
Definition
| Keeps titles on the sreen no matter how far you scroll |
|
|
Term
|
Definition
| A date is just a ___ since 1/1/1900 |
|
|
Term
|
Definition
| Addressing mode that keeps the column and row the same as you copy the formula |
|
|
Term
|
Definition
| Addressing mode that keeps the column the same as you copy the formula |
|
|
Term
|
Definition
| Addressing mode that adjusts the column and row as you copy the formula |
|
|
Term
|
Definition
| Feature that scrutinizes the impact of changing values in cells mthat are references by a formula in another cell |
|
|
Term
|
Definition
| Black square located in the lower right corner of an active cell |
|
|
