Question
For this assignment, you will create several spreadsheets in an Excel workbook and demonstrate different functions. Read all the instructions in this module item before
For this assignment, you will create several spreadsheets in an Excel workbook and demonstrate different functions. Read all the instructions in this module item before you begin. If you are unfamiliar with Excel functions, thoroughly read the Excel Activity Walk Through document provided. If you are familiar with functions used in Excel, you will still want to review the document to see what is expected.
- Excel ActivityWorkbook RequirementsExcel Formulas and Functions(Excel Activity Walk Through document).
- For spreadsheet options, go to theProductivity Softwaremodule introduced earlier in the course.
- Labelall values and name the worksheet tabs.
- Applyformatting such as bold text, colors, etc. as appropriate.
- Saveyour workbook in .xslx format.
To prepare for this assignment, view Microsoft's introductory videos #1, 2, 3, and 10 on functions in theExcel 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 anduse the PMT function and cell referencesto determine the monthly payments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started