enCR16
LogicalTest: it is a value or expression that can be evaluated to true or false
Sum: this function adds a value in a range
Lower: this function will convert all text into lower case letters
Function: it is a built in formula in Excel
Count A: this function counts the number of cells which contains data and are not empty in a given range
Upper: this function will change all selected text into capital letters
AverageIf: this function is used to get the average of values in cells within a range that meets the specific criteria
Sum If: this function is used if you want to add up the values in a given range that meets a certain criterion
FV: this function returns the future value of the investment at the end of the term using calculated interest rate
Min: this indicates the lowest value in a range
PMT: this function is the payment made each period
Vlookup: this function will search for specific information which have been stored in a spread sheet
Autosum: allows you to quickly add a range of cells together
Rate: this function will return interest rate per period of an annuity
Count: this function adds up the number of cells that contains numbers in a given range
Proper: this function is used to change the case of the selected text to all proper case letters
NPER: this is the total, number of payment periods in a year
Substitute: this function will replace a set of characters with another character or text
Max: indicates the highest value in a range
Median: it returns the median of a given numbers
PV: this function will given you the present value
If: this function returns one value if a conditions you specific evaluates True and another value if that condition evaluate false
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Across:
1.
this function returns the future value of the investment at the end of the term using calculated interest rate
4.
this function will replace a set of characters with another character or text
9.
this function adds a value in a range
10.
this function counts the number of cells which contains data and are not empty in a given range
11.
this function is the payment made each period
12.
this indicates the lowest value in a range
14.
it returns the median of a given numbers
Down:
2.
this function will search for specific information which have been stored in a spread sheet
3.
allows you to quickly add a range of cells together
4.
this function is used if you want to add up the values in a given range that meets a certain criterion
5.
this function returns one value if a conditions you specific evaluates True and another value if that condition evaluate false
6.
it is a built in formula in Excel
7.
this function adds up the number of cells that contains numbers in a given range
8.
this function will return interest rate per period of an annuity
13.
this is the total, number of payment periods in a year
15.
this function is used to get the average of values in cells within a range that meets the specific criteria