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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started