To prepare for this assignment, view Microsoft's introductory videos #1, 2, 3, and 10 on functions in the Excel 2013 Course: Excel Functions (Links to an external site.)Links to an external site.. (Viewing other titles on the webpage is optional).

Spreadsheet Functions Part 1:

• Create a new spreadsheet (workbook) that contains three separate data sets. Place each data set onto its own worksheet (three worksheets). See the list of example data sets:
• Temperature of your city for the past 5-10 daysScored points per game of your favorite sports team for their past 5-10 gamesAmount you paid for gas for the past few monthsMiles flown/ driven per day/trip etc. for the past monthMost anything else you can tabulate or can track
• Use at least four different functions (not formulas) (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set. You choose which to use. So each tab must have four different functions.

Spreadsheet Functions Part 2:

• On another worksheet of the same file, create a worksheet that contains data and a calculation determining monthly payments for a proposed purchase.
• Identify your dream vehicle (plane, automobile, boat, etc.) and estimate its cost and the interest rate if you financed its purchase.Enter data (loan amount, interest rate, term, etc.) onto spreadsheet and use the PMT function and cell references to determine the monthly payments

SuperTutor

(15)

Status NEW Posted 26 May 2017 05:05 AM My Price 8.00

-----------

Attachments

file 1495777373-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer