Hello, Can I get some help on my assignment ? Thank you !1) Management has tasked you with the

annual sales forecast analysis for its products, people, and territories. You are to use last year’s data and a sales forecast from Marketing to produce a report that can be used by upper Management and the Board of Directors to make decisions for major changes for next year and beyond to meet your market challenges. The data is presented to you in text files, spreadsheets, and Word documents. What Excel tools will you use to prepare the data for analysis? What steps will you use to analyze the data? Identify and explain the Excel features (a minimum of four) that you will use to analyze the data. What graphics will you include in the report? How will you insure that you present an objective analysis?

2. (TCO 3) You are a current student with DeVry University and a potential candidate being interviewed by the Dean for the College of Business and Management to help with common administrative services and tasks to support the department. The Dean is most especially interested in your knowledge and skills with Microsoft Excel to visually analyze and present data in charts and has asked you the following skill-based interview question: How and what would you look for to determine whether any given data set is best suited for the following chart types and why?

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"