Reference no: EM13771300
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 Activity
Excel Formulas and Functions (Excel Activity Walk Through document).
For spreadsheet options, go to the Productivity Software module introduced earlier in the course.
Workbook Requirements
Label all values and name the worksheet tabs.
Apply formatting such as bold text, colors, etc. as appropriate.
Save your workbook in .xslx or .xls format.
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.). (Viewing other titles on the webpage is optional).
Spreadsheet Functions Part 1:
Create a new spreadsheet that contains three separate data sets. Place each data set onto its own worksheet. See the list of example data sets:
Temperature of your city for the past 5-10 days
Scored points per game of your favorite sports team for their past 5-10 games
Amount you paid for gas for the past few months
Miles flown/ driven per day/trip etc. for the past month
Most anything else you can tabulate or can track
Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set. You choose which to use.
Spreadsheet Functions Part 2:
On another sheet 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.
|
Explain elements and defenses for each of common law torts
: Explain elements and defenses for each of common law torts. UCC contract law, including contract formation and appropriate remedies for a breached contract.
|
|
Which kinds of information systems do users really need
: the personal computer marketplace became fragmented around choices about which operating system people thought was best or coolest, or about which choice of systems offered users the best integrated and reliable options versus price.
|
|
Examining your community source of energy
: It is easy to criticize society for not using renewable resources, but in reality, how difficult would this transition be? What processes and procedures would be involved? How would such a transition be made?
|
|
Assignment on cash management
: Norma's Cat Food of Shell Knob ships cat food throughout the country. Norma has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by two and one-half days.
|
|
Create spreadsheet that contains three separate data sets
: 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..
|
|
Capital separate from earned capital
: a. Why is it important to keep paid-in capital separate from earned capital? b. As an investor, is paid-in or earned capital more important? Why?
|
|
Recycling-reducing and reusing
: In the Working Ahead section in Modules 1, 2, and 3, you were informed to collect items to be recycled and log a journal of these items. You were also instructed to select either Module 2 or Module 3 to collect these items.
|
|
What effect will such a drastic measure
: What effect will such a drastic measure have on the personnel's families? If you keep them, will it affect the overall credibility of your agency
|
|
Problem regarding the product description
: Using the WileyPlus resources, go to the "Forensic Accountants: Fraud Busters" example.
|