1:00
en
CR
16
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
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 |
| |
© 2013
PuzzleFast.com, Noncommercial Use Only
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 |
| |
© 2013
PuzzleFast.com, Noncommercial Use Only