Posted: February 9th, 2015

Excel Functions

Paper, Order, or Assignment Requirements

In this assignment you explore Microsoft Excel’s functions using the Insert Function tool from the Formulas menu. Begin by opening the Excel Math Features workbook you created during Unit 6. Save a copy as “lastname_excelfunctions.xlsx.” Keep your name in cell A1, but change the title to “Unit 7: Excel Functions.” In the title row (cell G3), enter the term “Bank Balance.” For each person in your table, calculate the current bank balance of $1000 deposited when he or she was born. Use Excel’s Future Value function (FV) and these values:

Rate: 5%
Nper/Period: Each person’s Age
Payment: 0
PV: -1000 (minus because we put the money in the bank)
Type: 0

Next, add the following labels below your Total row in column A, one per row: SUM, AVERAGE, and MEDIAN. Then using Excel’s functions that correspond to these row labels, compute the SUM, AVERAGE, etc. for the Age, Height, Weight, Height per Year, Pounds per Inch, and Bank Balance.