Lab Excel

Excel file with questions. Make sure to open the file and finish it at one time. Because the number will change after you close and reopen.

Lab 1 S5 T

Year Customer # Number of orders per year $ Sales per year Coupon Value SCENARIO & QUESTIONS
2018 123228 215 $ 308,202
2018 190347 822 $ 271,848 The Excel table shows years 2018 and 2019 data related to the number of orders and $ sales per customer for a certain company. The manager asked you to perform the following analysis related to sending discount coupons.
2018 103339 377 $ 384,960
2018 121959 682 $ 324,685
2018 145784 750 $ 105,331 Q1- (2 points) Develop a pseudo code that will offer the following discounts:
2018 185008 734 $ 159,702 10% coupon for those customers whose $ Sales per year were less than $200,000
2018 135101 286 $ 147,704 20% coupon for those customers whose $ Sales per year were between $200,000 and $300,000
2018 180643 972 $ 203,781 30% coupon for those customers whose $ Sales per year exceeded $300,000
2018 150454 495 $ 354,516
2018 142618 825 $ 140,862 Provide your answer below
2018 178586 728 $ 273,881
2018 153882 959 $ 197,774
2018 154210 429 $ 289,290
2018 170639 649 $ 287,928
2018 108237 756 $ 406,182
2018 185934 932 $ 267,018
2018 135464 730 $ 445,120 Q2- (4 points) Develop your if statements in column E so that E2 … E49 will show the coupon value based on Q1:
2018 192185 666 $ 111,456
2018 196741 194 $ 326,290
2018 137436 280 $ 315,003
2018 152854 461 $ 312,765 Q3- (2 points) Format $ Sales per year column have a graded color scale (do not manually highlight).
2018 185096 742 $ 273,152
2018 142718 912 $ 206,862
2018 198289 930 $ 301,515 Q4- (1 point) Edit your work so that random number generations stops in both Number of orders and $ Sales per year columns
2018 163071 806 $ 101,804
2018 198012 269 $ 204,116
2018 147668 686 $ 459,485 Q5- (1 point) Rearrange your spreadsheet so that listing will be orgnized based on coupon value.
2018 117799 209 $ 241,132
2018 113916 816 $ 368,371
2018 181187 289 $ 205,592 Make sure you keep saving your file and submit to Blackboard before time is up.
2018 199516 771 $ 394,963 You may email me your file as a last resort; however, it won’t be considered submitted on time and therefore graded if modifications took place past due date (submit as is).
2018 135059 374 $ 202,612
2018 158257 798 $ 331,345
2018 190495 399 $ 227,039
2018 194305 640 $ 101,145
2018 173213 279 $ 200,098
2018 163640 641 $ 392,383
2018 199029 970 $ 219,672
2018 152551 452 $ 442,009
2018 188212 410 $ 476,326
2018 193239 108 $ 350,255
2018 133758 110 $ 182,638
2018 136788 299 $ 417,104
2018 150143 189 $ 318,837
2018 172593 945 $ 179,311
2018 156038 420 $ 246,124
2018 183858 910 $ 203,426
2018 138926