hello, I saw that you have already done what I need it. Could you please answer: 2. (TCO 3) You are a current student with DeVry University and a

hello,

I saw that you have already done what I need it.

Could you please answer:

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?Column ChartsLine ChartsPie ChartsBar ChartsXY (Scatter Charts)3. (TCO 4) Jessica is an entry point student at DeVry University. In her BIS155 class, she has been provided a table including customer and sales data from an online e-business selling bait and tackle for both fresh and saltwater fishing. The layout of the table is organized with customer names in column A, purchase items in column B, purchase prices in column C, and phone numbers in column D. To assist Jessica, you as a tutor, agreed to help her with the following questions below: If asked to provide a sales report for one specific customer including all purchase items in the report, which Excel function or tool should be used and why?If asked to provide a sales report of all customers summarized to the level of totaled purchase prices, which Excel function or tool should be used and why?If asked to visually represent the answer to question “2,” which Microsoft Excel tool should be used and why?Would a Pivot table be feasible based on the table of data provided to Jessica? Why or why not?4. (TCO 5) You are a Loan Officer at a bank with several branches. You are responsible for managing the main bank and two satellite locations for reporting loan data to the bank manager. You receive monthly loan figures that cover the loan amounts requested, loan amounts approved and the percentage rates that may apply to the loan. You are tasked with creating a report that shows which location has the most loans requests, the amounts of the loans, including any necessary data that would impact a loan approval or rejection.Explain in detail how you would prepare a weekly summary report for the three locations including: Part 1: Describe the process needed to place the three locations data into one workbook. Part 2: Explain how the data from each location would best be summarized in the workbook. Part 3: Explain how to update the variable loan percentage rates (provided by the bank manager on a weekly basis). Part 4: Describe how to update the color formats and tab names in the quarterly report.5. (TCO 9) 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?