Description

For this assignment, you will create several spreadsheets in an Excel®workbook and demonstrate different functions. Read all the instructions in this module item and view the required tutorials before you begin. If you are familiar with functions used in Excel, you will still want to review these to see what is expected

Your workbook requirements are as follows:

• Labelall values and name the worksheet tabs.
• Applyformatting such as bold text, colors, etc. as appropriate.
• Saveyour workbook in .xlsx format.

View each section and complete both parts.

Spread sheet 1

1. Create a new spreadsheet that contains three separate data sets. Place each dataset onto its own worksheet. Example lists of datasets are the following:
   1. Temperature of your city for the past 5-10 days
   2. Scored points per game of your favorite sports team for their past 5-10 games
   3. Amount you paid for gas for the past few months
   4. Miles flown/driven per day/trip etc. for the past month
   5. Most anything else you can tabulate or can track
      
2. Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set. You choose which to use, but be sure each worksheet has at least four. It is acceptable if the functions are common between the three sheets.

Spreadsheet 2

On another sheet of the same file, create a worksheet that contains data and a calculation determining monthly payments for a proposed purchase. Include the following:

• 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 the spreadsheet and use the PMT function and cell references to determine the monthly payments