Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed Weather Report : Mami Florida High Low 20-May 80 72 Brandon 21-May 88 80 22-May 89 78 23-May 87 79 24-May 89 81 25-May 90 80 100 90 80 70 60 50 40 30 20 10 0 20-May 21-May 22-May 23-May 24-May 25-May 26-May 27-May 26-May 88 78 27-May 90 79 28-May 89 76 29-May 89 77 30-May 80 77 31-May 88 76 High Low 25-May 26-May 27-May 28-May 29-May 30-May 31-May Mileage log Total mileage Date 5/15/2017 5/15/2017 5/16/2017 5/17/2017 5/17/2017 5/18/2017 5/18/2017 5/19/2017 5/20/2017 5/21/2017 5/22/2017 5/23/2017 5/24/2017 5/25/2017 5/26/2017 5/27/2017 5/28/2017 5/29/2017 5/30/2017 5/31/2017 6/1/2017 Time 9:00 AM 5:00 PM 3:00 PM 9:00 AM 3:00 PM 9;00 AM 12:00 PM 107.5 DescriptionPurpose Work Business Work Busines groceries Personal Work Business Lunch Personal Work Business From Home Work Home Home Work Home To Work Home Publix Work CAF Work Odometer Start 33,489.1 33,521.4 33,543.8 33,550.5 33,582.8 Odometer Finish 33,521.4 33,543.8 33,550.5 33,582.8 33,587.6 Mileage 32.3 22.4 6.7 32.3 4.8 5.0 4.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra C Jeter, Paul K Chaney

5th Edition

1118022297, 978-1118022290

More Books

Students also viewed these Accounting questions

Question

=+b) Which model do you prefer? Explain briefly. Section 18.4

Answered: 1 week ago

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago