Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with a test I have to make this excel workbook. And I am having trouble getting the right help. This is the

I need help with a test I have to make this excel workbook. And I am having trouble getting the right help. This is the scenario:

Scenario: International Express, Ltd. International Express, Ltd. manufactures electronic and computer components for sports cars. At the upcoming annual sales meeting sales managers will present sales performance reports. Before the annual meeting the Branch Sales Manager, Tom Ferguson for the Ohio branch, needs to analyze the sales figures generated by each sales representative, as well as sales generated per quarter. A Sales worksheet you create will represent the sales dollar levels for each sales representative for the year. In order for Tom to complete all the analysis additional calculations will need to be completed. Tom needs to create a workbook and enter the sales figures for the past year, because his Excel skills are very limited, he needs your help. Tom wants a number of different calculations regarding total sales and increase in sales. He also wants you to make the data more readable and informative by giving the spreadsheet a professional look. International Express, Ltd. is also involved with charitable activities. Currently International is working with Mary Chambers who is the director of fundraising for the Hogwartz Zoo. The zoo relies on donations to fund its operations, temporary exhibits, and special programs. International Express Ltd., has been very successful in helping Mary raise funds for the Zoo. Mary would like to review the fundraising data with Tom so that he can present this information at the annual sales meeting. Your task will be to assist Tom with the necessary Ohio branch sales analysis he needs for the annual sales meeting. You will also be assisting Mary with the Hogwartz Zoo charitable donations data

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_step_2

Step: 3

blur-text-image_step3

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

ISBN: 0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

How does accounting help the capital allocation process?

Answered: 1 week ago

Question

18. If you have power, then people will dislike and fear you.

Answered: 1 week ago

Question

How do modern Dashboards differ from earlier implementations?

Answered: 1 week ago