Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is anassignment thatyou will prepare an Excel Workbook for an existing or fictional organization of Teslacompany information and statisticssuch as: inventory human resources sales

This is anassignment thatyou will prepare an Excel Workbook for an existing or fictional organization of Teslacompany information and statisticssuch as:

  • inventory
  • human resources
  • sales and revenue
  • budgets
  • financial analysis and forecasting
  • other topics as discussed with your Professor

Refer to the Projects on SAM for examples. Both documents must be created from scratch. The documents will be submitted both electronically and in printed form as indicated below. In addition, you will make a short Presentation to your Professor and possibly your class introducing your organization, yourselves and your project.

Higher Marks for proper use and presentation/explanation of one or more of the following (up to 5 marks):

  • What-If Analysis (Goal Seek)
  • 3d References
  • functioning Data Table(s)
  • Amortization Table(s)
  • Named Reference Formulae

Excel Document

  • includes at least two Tables (1 mark)
    • on separate sheets presenting different information (1 mark)
    • properly formatted, labeled and titled (2 marks)
    • a non-default Table Style is applied to each (2 marks)
  • includes at least two different types of Charts (2 marks)
    • on separate sheets presenting different information (1 mark)
    • properly formatted, labeled and titled (2 mark)
    • a non-default Chart Style is applied to each (1 mark)
  • use of proper Cell Styles and Borders (4 marks)
  • use of Structured (Named) References where appropriate (2 marks)
  • include at least three different AutoFunctions in your tables (Sum, Average, Min, etc.) (3 marks)
  • includes at least three, different, hand-written Formulae of at least intermediate complexity in your tables (6 marks)
    • formulas should display
      • complex calculations using multiple operations and parentheses and/or
      • non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.)
  • make sure that Formulae and other information is properly produced in Series by using the Fill Handle (2 marks)
  • use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables (3 marks)
  • use Conditional Formatting at least twice in your Tables (2 marks)
  • Use Page Layout tab to do the following.
    • apply the most appropriate page orientation(s) (portrait or landscape) for easy reading (1 mark)
    • set proper Print Areas to fit your tables and charts neatly on the pages without making them too small to read (1 mark)
    • in the headers of the printed pages, include the project title with the name of the organization (1 mark)
    • in the footers of the printed pages, include your names and titles, the date and the correct page numbers (2 marks)
  • Save the file with yourfirst name andlast name in the title(1 mark).
Use Excel

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

Intro Stats

Authors: Richard D. De Veaux, Paul F. Velleman, David E. Bock

3rd edition

321533283, 321533289, 9780321463708, 9780321503848, 9780321503800, 9780321499431, 9780321499417, 978-0321500458

More Books

Students also viewed these Mathematics questions

Question

What are the uses of performance appraisal?

Answered: 1 week ago

Question

Explain why needs motivate our behavior.

Answered: 1 week ago

Question

Describe visualization and how it can boost motivation.

Answered: 1 week ago

Question

Cite ways to overcome fear of success.

Answered: 1 week ago