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

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!