Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Legaltech Book

Authors: Susanne Chishti ,Sophia Adams Bhatti ,Akber Datoo ,Drago Indjic

1st Edition

1119574277, 978-1119574279

More Books

Students also viewed these Finance questions