Question: Bidder List Previous Experience Grade Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) D&B Stress Risk Class (1 Best) Rule
| Bidder List | Previous Experience Grade | Net Worth (Dollars) | D&B Composite Credit Appraisal (1 Best) | D&B PAYDEX (100 Best) | D&B Stress Risk Class (1 Best) | Rule #1 | Rule #2 | Rule #3 |
| Ribba Technology | Satisfactory | $ 5,000,000 | 1 | 89 | 1 | FALSE | TRUE | TRUE |
| TDR Corporation | Satisfactory | 286,000 | 2 | 79 | 1 | FALSE | FALSE | TRUE |
| ComputerX Assoc. | Satisfactory | 4,560,000 | 1 | 93 | 3 | TRUE | TRUE | TRUE |
| Exceed WR | None | 1,089,000 | 3 | 45 | 1 | FALSE | FALSE | TRUE |
| Roberts Inc. | Unsatisfactory | 23,459,000 | 2 | 68 | 2 | FALSE | TRUE | FALSE |
In these steps, you will help complete the credit analysis by applying the following set of rules:
Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90.
Rule #2: Consider a bidder if all of the following criteria are met: The company's D&B PAYDEX score is greater than 65. The company's D&B composite credit appraisal value is less than or equal to 2. The company's net worth is greater than $500,000. (Net worth values are listed in dollars on the worksheet.)
Rule #3: Consider a bidder if any of the following criteria are met: The company's D&B stress risk class is equal to 1. The company's previous experience grade is Satisfactory.
Question- below
Using conditional formatting, highlight the cells in the range G3:I7 that contain a value of FALSE with light blue shading, and highlight all the cells that contain a value of TRUE with light yellow shading. (Note: choose any standard light blue and yellow colors from the gallery.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
