Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Difficulty: Level 3 The purpose of this exercise is to analyze a worksheet to determine whether there are any integrity flaws. First, read the
Difficulty: Level 3 The purpose of this exercise is to analyze a worksheet to determine whether there are any integrity flaws. First, read the scenario below. Then, open the file that is related to this exercise and analyze the worksheets contained in the workbook. Use the AnswerSheet worksheet for any written responses required for this exercise. Scenario Your coworker provides you with sales data in an Excel workbook which you intend to use for a sales strategy meeting with your client. The workbook was attached to an email with the following points stated in the message. The data represents the top selling items for the company last year with respect to sales dollars. I received the data from an analyst in my department who insisted the cost data for each item was included. However, I don't see it. You might have to manually enter this yourself. I included the cost for each item below. The original data I received is in Sheet1. I copied this data and pasted it into Sheet2. I thought you might like to see this sorted. Cost per item data: Item Black Flat Cost Item Cost Item Cost $35.00 Daisy Print Bracelet $30.00 Gray Stripe $40.00 Navy Pinstripe $125.00 $110.00 Navy Wool $135.00 Brown Pump $25.00 Jersey Knit $80.00 Quartz Watch $80.00 Sandal $45.00 Tan Trench $115.00 Topaz $50.00 Assignment 1. Analyze the data in this workbook carefully. Would you be comfortable using this data in a professional meeting? Use the AnswerSheet worksheet to briefly list a few concerns you have with this 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