Please show how you got the results for each question.

The bottom image is an example of what it should look like.

Please use conditional formatting where necessary.

1. Rule #1: Display TRUE in column K if the customer's Past Due Balance as a percentage of the Current Year's Sales is less than 10% 2. Rule #2: Display TRUE in column L if the customer's D&B composite is 1 or the Paydex score is better than 90 3. Rule #3: Display TRUE in column M if the customer's Net Worth is over $500K, their D&B composite score is either a 1 or a 2, their Paydex score is better than 70, and their Stress Class is 1 4. Rule #4: Display TRUE in column N if the customer's Credit Limit exceeds 25K and they have passed Rule #1 5. In row 23, determine whether any customer meets rules 1-4 6. In row 24, determine whether no customer meets rules 1-4 7. If Net Worth is less than 1,000 (without the multiplier), highlight the customer orange; if it is greater than 10,000, highlight in green 8. Boldface and italicize customers that satisfy rules 1-4. 9. Hide the Current Credit Limit amounts and display them graphically instead. 10. Display D&B Stress Risk Class as stop signs. Accounts Receivable Department - Customer Credit Analysis Rule#3 (Risk Analysis 2: Net Rule#2 (Risk Worth>500K AND Analysis 1: Composite=1 or 2 Composite=1 AND Paydex>70 Rule#4 (Credit Limit OR Paydex AND Stress > 25K AND Rule#1 ls >90) Class=1) True) Previous Current Current Year's Year's Past Due Net Worth Customer Name Credit Limit Sales Sales Balance in (000) Athletic Gear Corp. $9,000.00 $ 15,382 $11,952 $ 0 $ 450 Baltimore O's $39,000.00 10,033 7,789 0 1,950 Baseball & More $75,000.00 60,009 55,342 13,892 37,500 Canadian Ski Club $33,000.00 35,039 50,921 495 1,650 Concord Pro Shop $24,000.00 30,000 20,000 300 10,000 Everything Golf $25,000.00 15,221 9,483 2,899 1,250 Lake Pro Shops $42,000.00 80,498 81,126 0 2,100 Mars Dept. Store $27,000.00 35,354 20,666 0 213 RG Bradley $46,000.00 90,970 18,343 2,300 RX for Sports $15,000.00 5,663 3,014 0 750 School Sports Supply $45,000.00 50,278 32,338 0 2,250 Ski World $26,000.00 25,864 28,154 0 300 Sneaker Kingdom $45,000.00 40,157 25,379 0 2,250 Sports & Stuff $15,000.00 15,898 14,732 14,383 450 Toy Kingdom $22,000.00 10,073 1,047 0 1,100 Under the Sea $45,000.00 95,411 64,418 150 US Olympic Team $20,000.00 5,621 6,171 0 1,000 WWW Sports Inc. $100,000.00 60,009 60,354 0 500,000 Zip & Sons $10,000.00 15,490 22,760 0 620 D&B Credit Rating Class BA 3A 4A BA 4A 3A BB 2A 3A BA 3A BA 3A CB 5A 1A D&B Composite Credit Appraisal (1 = Best) 4 1 2 2 1 3 2 3 1 1 3 2 2 1 3 4 1 2 2 D&B D&B Stress Rule#1 PAYDEX Risk Class (%Past (100 = Best) (1= Best) Due 90) FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE TRUE Rule#3 (Risk Analysis 2: Net Worth>500K AND Composite=1 or 2 AND Paydex>70 Rule#4 (Credit Limit AND Stress > 250K AND Rule#1 Class=1) Is True) FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE TRUE TRUE TRUE FALSE Do any meet the rule? Do none meet the rule? TRUE FALSE TRUE FALSE TRUE FALSE TRUE FALSE 1. Rule #1: Display TRUE in column K if the customer's Past Due Balance as a percentage of the Current Year's Sales is less than 10% 2. Rule #2: Display TRUE in column L if the customer's D&B composite is 1 or the Paydex score is better than 90 3. Rule #3: Display TRUE in column M if the customer's Net Worth is over $500K, their D&B composite score is either a 1 or a 2, their Paydex score is better than 70, and their Stress Class is 1 4. Rule #4: Display TRUE in column N if the customer's Credit Limit exceeds 25K and they have passed Rule #1 5. In row 23, determine whether any customer meets rules 1-4 6. In row 24, determine whether no customer meets rules 1-4 7. If Net Worth is less than 1,000 (without the multiplier), highlight the customer orange; if it is greater than 10,000, highlight in green 8. Boldface and italicize customers that satisfy rules 1-4. 9. Hide the Current Credit Limit amounts and display them graphically instead. 10. Display D&B Stress Risk Class as stop signs. Accounts Receivable Department - Customer Credit Analysis Rule#3 (Risk Analysis 2: Net Rule#2 (Risk Worth>500K AND Analysis 1: Composite=1 or 2 Composite=1 AND Paydex>70 Rule#4 (Credit Limit OR Paydex AND Stress > 25K AND Rule#1 ls >90) Class=1) True) Previous Current Current Year's Year's Past Due Net Worth Customer Name Credit Limit Sales Sales Balance in (000) Athletic Gear Corp. $9,000.00 $ 15,382 $11,952 $ 0 $ 450 Baltimore O's $39,000.00 10,033 7,789 0 1,950 Baseball & More $75,000.00 60,009 55,342 13,892 37,500 Canadian Ski Club $33,000.00 35,039 50,921 495 1,650 Concord Pro Shop $24,000.00 30,000 20,000 300 10,000 Everything Golf $25,000.00 15,221 9,483 2,899 1,250 Lake Pro Shops $42,000.00 80,498 81,126 0 2,100 Mars Dept. Store $27,000.00 35,354 20,666 0 213 RG Bradley $46,000.00 90,970 18,343 2,300 RX for Sports $15,000.00 5,663 3,014 0 750 School Sports Supply $45,000.00 50,278 32,338 0 2,250 Ski World $26,000.00 25,864 28,154 0 300 Sneaker Kingdom $45,000.00 40,157 25,379 0 2,250 Sports & Stuff $15,000.00 15,898 14,732 14,383 450 Toy Kingdom $22,000.00 10,073 1,047 0 1,100 Under the Sea $45,000.00 95,411 64,418 150 US Olympic Team $20,000.00 5,621 6,171 0 1,000 WWW Sports Inc. $100,000.00 60,009 60,354 0 500,000 Zip & Sons $10,000.00 15,490 22,760 0 620 D&B Credit Rating Class BA 3A 4A BA 4A 3A BB 2A 3A BA 3A BA 3A CB 5A 1A D&B Composite Credit Appraisal (1 = Best) 4 1 2 2 1 3 2 3 1 1 3 2 2 1 3 4 1 2 2 D&B D&B Stress Rule#1 PAYDEX Risk Class (%Past (100 = Best) (1= Best) Due 90) FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE TRUE Rule#3 (Risk Analysis 2: Net Worth>500K AND Composite=1 or 2 AND Paydex>70 Rule#4 (Credit Limit AND Stress > 250K AND Rule#1 Class=1) Is True) FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE TRUE TRUE TRUE FALSE Do any meet the rule? Do none meet the rule? TRUE FALSE TRUE FALSE TRUE FALSE TRUE FALSE