Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q4 (18 points). You are given the following unit sales data for five sales associates from Monday to Saturday. Please set up a worksheet (name
Q4 (18 points). You are given the following unit sales data for five sales associates from Monday to Saturday. Please set up a worksheet (name the worksheet your last name_Q4) to complete the following tasks: 1. Rank your employees by units of product sold for each day during the week (descending order). Hint: use the "rank function to complete the performance ranking. 2. Use the icons introduced in class to track the daily change in performance ranking over the week (up, down, or stays the same) for each individual sales associate. Hint: use IF statement to complete this question. name Vivian Liz Sharon Sam Joe sales Monday Tuesday Wednesday Thursday Friday 58 55 70 89 75 69 60 55 69 78 90 67 45 78 130 145 160 120 110 40 64 79 89 100 Saturday 100 90 110 190 105 90
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