Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
|
is a financial function that calculates the payment for a loan based on constant payments and a constant interest rate. |
PMT |
|
|
Syntax / Formula of PMT |
=PMT(rate, nper, pv) =PMT(B2/12, B3*12, B1) |
|
|
a statistical function that returns the correlation coefficient between two data sets. |
CORREL |
|
|
This is particularly helpful when conducting researches. |
CORREL |
|
|
Syntax / Formula of CORREL |
=CORREL(B2:B16, C2:C16) |
|
|
used to count the number of cells specified by a given set of conditions or criteria. |
COUNTIFS |
|
|
Syntax / Formula of COUNTIFS |
=COUNTIFS(range 1, range 2) =COUNTIFS(B2:B16,”>50”,C2:C16,”>80”) |
|
|
returns the average of the cells specified by a given set of conditions |
AVERAGEIFS |
|
|
returns the sum of the cells specified by a given set of conditions. |
SUMIFS |
|
|
search for a value either from a one-row or one-column range or from an array. |
LOOKUP |
|
|
Syntax / Formula of LOOKUP |
=LOOKUP (lookup_value, lookup_vector,[result_vector]) |
|
|
converts a vertical range of cells to a horizontal range, or vice versa. |
TRANSPOSE |
|
|
Syntax / Formula of TRANSPOSE |
=TRANSPOSE(range) |
|
|
an object that allows you to jump to another file or within the existing file. |
Linked Object |
|
|
an object created with a dynamic link between the content of the destination file and the content of the source file. |
EMBEDDED OBJECT |
|
|
The data is stored in the source file |
LINKED OBJECT |
|
|
Destination file stores only the location of the source file. |
LINKED OBJECT |
|
|
The data can be updated whenever the source file is updated. |
LINKED OBJECT |
|
|
Information can be updated if the source file is modified. |
LINKED OBJECT |
|
|
The destination file where you put the object contains a static copy of the object’s data. |
EMBEDDED OBJECT |
|
|
Information in the destination file doesn’t change if you modify the source file. |
EMBEDDED OBJECT |
|
|
After they are inserted, they are no longer part of the source file. |
EMBEDDED OBJECT |
|
|
become part of the destination file. |
EMBEDDED OBJECT |
