Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!