Question: 1.8 Another rewards program that Aleeta is considering includes a way for non-club members to also earn a discount. On the Transactions worksheet, in cell

1.8 Another rewards program that Aleeta is

1.8 Another rewards program that Aleeta is considering includes a way for non-club members to also earn a discount. On the Transactions worksheet, in cell P10, create a formula that will return 0.1 if the customer is a member and they spent more than $200 or if the customer simply purchased a promotional item, otherwise return a blank value (""). Format the cell as Percentage with 0 decimal places. Use the fill handle to copy the formula down through P30. 1.5 Aleeta had a new Point of Sale system installed at the Pro Shop and training has been ongoing. She would like to know which of her employees are beginners, proficient, or experts on the new system based on the number of training hours completed. On the Employee Analysis worksheet, in cell D14, use the IFS function to return Expert for training hours at least 40, return Proficient for training hours at least 25, otherwise return Beginner. Use the fill handle to copy the formula down through D18. 1.8 Aleeta would like to reward her customers with a coupon to celebrate the upcoming Customer Appreciation Day. There are three different coupons and each customer will receive one of them. On the CustomerAnalysis worksheet, in cell G4, enter a Nested IF function that will return values based on the following: If a customer is a club member and has been deemed a high value customer based on their last transaction, she would like them to get 20% off. If they are not a member but are still deemed a high value customer, she would like them to get 15% off. All other customers will receive a 10% off coupon

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!