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 AgePayment: 0PV: -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.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]