Question: please help me Question 11, Problem G.3 Question Help Using the Thompson Industries' supplier file provided below, enter 85% into cell H11. In that spreadsheet,

please help me

please help me Question 11, Problem G.3 Question Help Using the Thompson

Question 11, Problem G.3 Question Help Using the Thompson Industries' supplier file provided below, enter 85% into cell H11. In that spreadsheet, any highly rated supplier (with 5 in column F) should have its percentage returns in column H less than 10%. Analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to identify any highly rated suppliers whose purchases do not meet that condition. What formula should go into the box Format values where this formula is true:? Click the icon to view the raw data for Thompson Industries' Suppliers. X More Info Choose the correct formula below O = AND(F6=5,H6 =0.1) Thompson Industries Monthly Supplier Report - April O = OR(F6 =5,H6> =0.1) = AND(F6 =5,H6> =0.1) Supplier Change from No, of New O Supplier Category Total Previous Quality On-time Percentage Rejected Supplier SupplierName Name (P.S) Purchases Month Rating (1-5) Percentage Returns Shipments (Y.N) Maverick Supplies 6071 $40,327 $15,068 100% 076 Cowboy Pete's Lumber 6894 $24,182 $635 90% 0% ABC Metals 5054 $24,147 $24,147 0% 759% Perkins Plastics 6528 $29.068 $37,154 100% 3%% Everything Brass $413 $29.111 ($3,650) 100.0% 0% Jones Aluminum & Copper 5858 $16,776 $ 16,776 50% 5% 12 Rick's Wrought Iron 9733 $28,020 ($3,813) 60% 80% z z > z z > z z z z > Z > Z Z Penelope's Paper Products 4718 $25,384 $8,053 100% 12% 9944 $21,705 $13,462 90% 14 Anthony's Adhesives 1343 $20,009 100% 15 Columbus Manufacturing $8,386 16 Smart Electronics, Inc. 4785 $31,729 $31,729 33% 50% 17 Watson Woodworking 2730 $31 218 ($5.908) Good 25% 1% 18 Fred's Foam Molding 2949 $27 268 $27 268 100% 0.50% 4% 19 impenetrable Insulation, Inc. 1443 $24 796 $6,564) 15% 20 Suzy's Shipping Supplies 8039 $23,512 $1 229 50% your answer and then click Check Answer Print Done

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!