please and thank you!!

i apologize for the long data sheet.

thank you!!

Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 100 $215 101 200 $195 $175 201 400 401 $155 and up Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders $215 100 1 $195 101 200 $175 400 201 $155 401 and up 172 for order 21 3 B D G H E F Quantity Ordered From To 1 100 101 200 201 400 401 and up Price per Roll $215 $195 $175 $155 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 86 452 492 191 356 148 342 382 276 118 464 188 25 427 30 111 161 314 442 429 451 32 181 22 23 Data Page: 1 of 4 Paste Format Painter Clipboard Font f Order A1 C D A 24 25 26 27 28 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 B 163 336 240 68 317 435 211 76 374 415 408 196 302 312 co 31 317 394 348 49 500 490 Click to adi 14 Ready Data Page 1 of 4 Times New Rom12 Wrap Cut Copy Paste Format Painter Clipboard B U Merge Font Alignment A1 fx Order B D E Click to add header 94 285 237 101 53 257 273 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 415 346 133 287 431 113 197 6 328 114 207 273 Data Ready Format Painter Clipboard Font A1 f Order A B D 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 KM Ready 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 257 113 400 324 500 60 117 466 370 293 164 63 SS SS 252 394 109 233 340 430 210 363 120 429 113 Data D E 88 89 90 87 88 89 391 375 487 Click to add fc Click to add hea 91 92 93 94 95 96 97 98 90 91 92 93 94 95 96 97 98 99 100 101 102 11 264 14 177 193 427 320 347 64 430 282 66 457 99 100 101 102 103 Data Ready ferat Allom Order Al D E C 03 104 105 106 107 108 109 110 102 103 104 105 106 B 457 377 15 333 23 230 378 108 109 136 250 377 388 256 EEEEEEEEEEEEEEEE 112 113 114 115 116 117 118 119 120 121 122 123 337 115 116 117 118 119 419 171 278 184 359 368 109 100 154 160 122 Data U 2 2 3 m S 3 4 % 5 W 6 E Times New Rom 12 FF Copy Paste BT Format Painter Clipboard Font A1 fi Order A B D 126 127 128 129 130 131 132 133 125 126 127 128 129 130 131 132 133 134 239 186 383 156 217 452 111 208 317 60 134 135 Click to ad Click to add 136 137 138 139 140 135 136 137 185 383 52 282 188 52 138 139 140 141 Data Ready Copy BU Paste Format Painter Clipboard Font A1 fx Order D B 188 52 106 346 277 484 208 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 139 160 229 311 450 304 379 15 99 324 151 179 460 441 309 37 305 348 162 161 Data Ready 8 163 164 165 166 167 168 169 170 171 172 173 162 163 164 165 166 167 168 169 170 171 85 135 288 454 238 38 451 374 437 184 455 172 Data Ready SIS O PREMIUM SOUND