TO: MEATELCO FM: MEATELCO
Vocabulary
1.) Argument - a value, cell reference, range or text that acts as an operande in a function formula
2.) Financial Function - used to analyze loans and investments
3.) Function Formula - special formula that doesnt use operators to calculate a result
4.) Logical Function - used to display text or values if certain conditions exist.
5.) Mathematical Function - manipulate quantitative data in the worksheet
6.) Statistical Function - used to describe large quantities of data.
7.) Trigonometric Function - same as mathematical
True/False
1.) Function formulas do not have operators. T
2.) The AutoSum button creates the function formula =SUM in the highlighted cell T
3.) The SMALL function formula displays the smallest number contained in the range identified in the argument. F
4.) It is necessary to use the Function Arguments dialog box to insert a function formula in a worksheet F
5.) The NOW() function will insert either the current date or time in a worksheet cell. T
Fill In The Blank
1.) The equation is enclosed in parentheses in a function formula.
2.) The =SUM function formula is inserted in a cell when you click the AutoSum button.
3.) The InsertFunctions dialog box specifies elements to be inluded in the function formula.
4.) Logical functions perform various operations, such as finding present and future values.
5.) Statistical functions describe large quantities of data, such as the average, standard deviation, or variance of a range of data.
Project 5-1
1.) Determine the smallest value in A4:A90 Logical
2.) Determine the standard deviation of the values in K6:K35 Logical
3.) Determine the average of the values in B9:B45 Statistical
4.) Determine the yearly payments on a $5,000 loan at 8% for 10 years Financial
5.) Determine the value of a savings account at the end of 5 years after making $400 yearly payments; the account earns 8% Financial
6.) Round the value in C3 to the tenths place Mathematical and Trigonometric
7.) Determine the present value of a pension plan that will pay you 20 yearly payments of $4,000; the current rate of return is 7.5% Financial
8.) Determine the square root of 225 Mathematical and trigonometric
9.) Determine the variance of values in F9:F35 statistical
10.) Add all the values in D4:D19 mathematical and trigonometric
11.) determine how many cells in H7:H21 are filled with data logical
12.) Determine the largest value in E45:E92 logical
1.) Argument - a value, cell reference, range or text that acts as an operande in a function formula
2.) Financial Function - used to analyze loans and investments
3.) Function Formula - special formula that doesnt use operators to calculate a result
4.) Logical Function - used to display text or values if certain conditions exist.
5.) Mathematical Function - manipulate quantitative data in the worksheet
6.) Statistical Function - used to describe large quantities of data.
7.) Trigonometric Function - same as mathematical
True/False
1.) Function formulas do not have operators. T
2.) The AutoSum button creates the function formula =SUM in the highlighted cell T
3.) The SMALL function formula displays the smallest number contained in the range identified in the argument. F
4.) It is necessary to use the Function Arguments dialog box to insert a function formula in a worksheet F
5.) The NOW() function will insert either the current date or time in a worksheet cell. T
Fill In The Blank
1.) The equation is enclosed in parentheses in a function formula.
2.) The =SUM function formula is inserted in a cell when you click the AutoSum button.
3.) The InsertFunctions dialog box specifies elements to be inluded in the function formula.
4.) Logical functions perform various operations, such as finding present and future values.
5.) Statistical functions describe large quantities of data, such as the average, standard deviation, or variance of a range of data.
Project 5-1
1.) Determine the smallest value in A4:A90 Logical
2.) Determine the standard deviation of the values in K6:K35 Logical
3.) Determine the average of the values in B9:B45 Statistical
4.) Determine the yearly payments on a $5,000 loan at 8% for 10 years Financial
5.) Determine the value of a savings account at the end of 5 years after making $400 yearly payments; the account earns 8% Financial
6.) Round the value in C3 to the tenths place Mathematical and Trigonometric
7.) Determine the present value of a pension plan that will pay you 20 yearly payments of $4,000; the current rate of return is 7.5% Financial
8.) Determine the square root of 225 Mathematical and trigonometric
9.) Determine the variance of values in F9:F35 statistical
10.) Add all the values in D4:D19 mathematical and trigonometric
11.) determine how many cells in H7:H21 are filled with data logical
12.) Determine the largest value in E45:E92 logical