Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Highlight Product cells with green color based on Change Product and Highlight Amount cells with red color which are less than Change Amount. Change

image text in transcribedimage text in transcribed

1) Highlight Product cells with green color based on Change Product and Highlight Amount cells with red color which are less than Change Amount. Change Product and Change Amount are dynamically changed text value and number. 2) Find the Shipping Amount of OrderID 2361 using Index, match functions both. So that we can find the value of another OrderlD. 3) Create a User Form with Combo box to store student database. Including: - First Name Last Name Email Department (Combo Box) Street City Country Buttons (Add, Close) N 0 P Q R S S T INDEX-MATCH 2361 4. A B 1 Order ID Customer D Sales Person 2 947 CSOB Bob 3 3237 C372 John 4 363 C212 Bob 5 452 0015 Bob 6 4363 0015 Bob 7 3202 0015 Richard 8 1657 0256 John 9 4203 C256 John 10 1531 C089 John 11 8244 COB9 John 12 2952 0591 Richard 13 435 C591 John 14 1289 0036 John 15 49128 0036 Bob 16 1293 0036 Richard 17 2966 0023 en we Richard 18 1283 C453 Bob 19 4124 0042 John 20 1770 CZAS Bob 21 4240 C735 John 22 373 C206 Bob 23 5092 0731 Richard 24 6034 C507 Richard 25 11148 C507 CSOZ Bob 26 557 0495 Bob 27 2156 0502 John 28 4183 0602 John 29 33123 0602 John 30 4365 C199 Richard 31 2954 C199 Richard 32 4802 C199 Richard 33 4951 C199 Richard 34 25143 0199 Bob 35 2478 0241 John 36 4337 C780 Richard 37 2367 0648 Bob 38 3022 C408 John 39 2308 C177 Richard 40 112 C784 Richard 41 1969 C794 Bob 42 2368 C181 Richard 43 4605 C181 Richard 44 2194 C181 John 45 1721 0555 Bob 46 2778 0771 John 47 3429 C771 John 48 4627 0493 Richard 49 663 0493 John 50 2901 C406 Bob 51 11209 0502 Richard 52 3033 (302 Richard 53 2022 C302 Bob 54 681 0411 Richard 55 359 C359 Richard 56 3074 C359 Richard 57 7130 C359 Bob 58 34209 0084 Richard 59 4699 C148 Bob 60 1613 0673 John 61 365 C673 John 62 2361 C4B2 Bob 63 2591 0662 Richard 64 901 0398 Richard 65 4734 CS84 Richard 66 2499 0498 Bob 67 3935 C794 John 68 1225 003 Bob 69 4350 C188 Bob 70 D F H K L Order Date Order Priority SKU Order Quantity Unit Sell Price Unit Sell Price Discount Shipping Amount Ship Mode Product Container 1/1/14 Not Specified SKU947 9 95.99 0.08 35 Express Air Large Box 1/1/14 High SKU937 32 5.98 0.1 4.69 Regular Air Small Box 2/1/14 Critical SKU363 3 40.98 0.06 2.99 Regular Air Small Box 2/1/14 Low SKUOS2 4 291.73 0.02 48.8 Delivery Truck Jumbo Drum 2/1/14 Low SKU063 43 100.98 0.07 45 Delivery Truck Jumbo Drum 2/1/14 Low SKU902 32 155,05 0.05 7.07 Regular Air Small Box 2/1/14 Critical SKU557 16 9.11 0.09 2.15 Express Air Wrap Bag 2/1/14 Critical SKU603 43 15.04 0.08 1.97 Regular Air Wrap Bag 3/1/14 Critical SKU731 15 5.28 0.03 5.66 Regular Air Small Box 3/1/14 Critical SKU1244 8 110.99 0.01 2.5 Regular Air Small Box 3/1/14 High SKU352 29 5.58 0.03 2.99 Regular Air Small Hox 2/1/14 High SKU235 4 212.6 0.09 S2.2 Delivery Truck Jumbo llox 3/1/14 Low SKU989 12 43.22 0.08 16.71 Regular Air Small Box 3/1/14 Low SKU1128 49 574.74 0.05 24.49 Regular Air Large Box 3/1/14 LOAN SKU593 12 10.14 0.04 2.27 Regular Air Wrap Bag 2/1/14 High SKU 766 29 4.26 0.03 1.2 Regular Air Wrap Bag 3/1/14 High SKUO83 12 20.98 0.05 21.2 Regular Air Medium Box 3/1/14 Not Specified SKU1124 4 213.45 0.02 14.7 Delivery Truck Jumbo Drum 4/1/14 Critical SKU370 17 3.36 0.03 6.27 Regular Air Small Hox want non 4/1/14 Critical SKU540 42 3.71 0.07 1.93 Express Air Wrap Bag 4/1/14 High SKUO73 350.98 0.06 30 Delivery Truck Jumbo Drum 5/1/14 High SKU1092 6 120.97 0.08 25.3 Delivery Truck Jumbo Drum Who 5/1/14 High SKU1034 6 28.48 0.03 1.99 Regular Air Small Pack 5/1/14 High SKU1148 11 205.99 0.01 5.99 Regular Air Small Box 5/1/14 Not Specified SKUOS7 51 243.98 0.08 43.32 Delivery Truck Jumbo Drum 5/1/14 Critical SKU156 21 194.3 0.01 11.54 Regular Air Large Box 5/1/14 Critical SKU183 41 209.84 0.02 21.21 Regular Air Large Hox 5/1/14 Critical SKU1123 33 145.45 0.02 17.85 Delivery Truck Jumbo Drum 5/1/14 Critical SKU065 43 1.81 0.08 0.75 Regular Air Jumbo Drum 5/1/14 Critical SKUO54 29 20.98 0.06 53.03 Delivery Truck Jumbo Drum 5/1/14 Critical SKU202 48 279.48 0.07 35 Regular Air Large Box 5/1/14 Critical SKU 251 49 4.91 0.08 5.68 Regular Air Jumbo Box 5/1/14 Critical SKU1143 25 125.99 0.04 5.26 Regular Air Small Box 5/1/14 Not Specified SKU578 24 7.64 0.05 5.83 Regular Air Wrap Bag 5/1/14 Medium SKU937 43 5.98 0.09 4.69 Regular Air Small Hox 5/1/14 High SKU567 23 30.98 0.02 5.76 Regular Air Small Box 6/1/14 Critical SKUO22 30 880.98 0.04 44.55 Delivery Truck Jumbo Box 6/1/14 Low SKUOCS 23 100.98 0.02 35.84 Delivery Truck Jumbo Box 6/1/14 Medium SKU412 1 1 7.68 0.07 6.16 Express Air Small Hox 6/1/14 Medium SKU169 19 6.64 4.95 Express Air dir 0.05 Small Pack 6/1/14 Not Specified SKU068 23 150.98 0.01 30 Delivery Truck Jumbo Drum 6/1/14 Not Specified SKU906 46 28.28 0.01 13.99 Express Air Medium Box 6/1/14 Not Specified SKU1194 2. 2 35.99 0.03 1.1 Regular Air Small Hox 6/1/14 Critical SKU821 17 2.1 0.03 0.7 Regular Air Wrap Bag 6/1/14 Not Specified SKU978 27 1.7 0.06 1.99 Regular Air Small Pack 5/1/14 Not Specified SKU629 34 30.98 0.01 5.09 Regular Air Small Box 6/1/14 Low SKU727 46 6.48 0.09 8.73 Regular Air Small Box 6/1/14 Low SKU963 6 20.34 0.05 35 Regular Air Large Box 6/1/14 High SKUB01 29 3.28 0.03 3.97 Regular Air Wrap Bag 7/1/14 High SKU1209 11 65.99 0.07 5.99 Regular Air Small Box 7/1/14 Medium SKL1433 30 20.98 0.09 8.83 Express Air Small Box 7/1/14 Medium SKU1022 2 73.98 0.03 14.52 Regular Air Small Box 7/1/14 Low SKU781 6 1.76 0.01 0.7 Regular Air Wrap Bag 7/1/14 Medium SKU359 3 1.98 0.05 4.77 Regular Air Small Box 7/1/14 Medium SKU1074 3 699.99 0.07 24.49 Express Air Large Box 7/1/14 Medium SKU1130 7 6783.02 lar 0.07 24.49 Regular Air Large Box 7/1/14 Low SKU1209 34 65.99 0.05 5.99 Regular Air Small Box 7/1/14 High SKU399 46 15.99 9.08 13.18 Regular Air Small Box 8/1/14 High SKU513 16 4.13 0.07 0.99 Regular Air Small Box 8/1/14 High SKU165 3 22.72 0.03 8.99 Regular Air Small Pack 8/1/14 Not Specified SKU261 23 14.56 0.07 3.5 Regular Air Small Box 8/1/14 High SKU391 25 896.99 0.03 19.99 Regular Air Small Box 9/1/14 Not Specified SKUS01 9 4.13 0.02 6.89 Regular Air Small Box 9/1/14 Low SKU734 47 2.6 0.1 2.4 Regular Air Wrap Bag 9/1/14 Not Specified SKU799 24 2.78 0.09 0.97 Regular Alr Wrap Bag 9/1/14 Not Specified SKUR35 39 3.29 0.07 1.35 Regular Air Wrap Bag 9/1/14 Low SKU1225 1 125.99 0.04 8.99 Regular Air Small Box 9/1/14 High SKU750 43 11.66 0.02 8.99 Express Air Small Pack M Ship Date 1/3/14 1/2/14 1/4/14 1/2/14 1/4/14 1/9/14 1/4/14 1/2/14 1/5/14 1/6/14 1/4/14 1/4/14 1/5/14 1/10/14 1/7/14 1/4/14 1/4/14 1/5/14 1/5/14 1/6/14 1/5/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/5/14 1/6/14 1/5/14 1/6/14 1/6/14 1/7/14 1/7/14 1/6/14 1/8/14 1/8/14 1/8/14 1/8/14 1/7/14 1/7/14 1/7/14 1/8/14 1/4/14 1/10/14 1/8/14 1/8/14 1/9/14 1/10/14 1/12/14 1/8/14 1/9/14 1/8/14 1/11/14 1/8/14 1/8/14 1/8/14 1/9/14 1/10/14 1/10/14 1/14/14 1/11/14 1/11/14 1/16/14 1/11/14

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

Students also viewed these Accounting questions