$$ IST $310$ Excel $5$ Instructions.pdf

File $|$ C:$/$Users$/14029/$Downloads$/$IST$\%20310\%20$Ex$...$

$$

$[]$

$4+\frac{10}{0}$

K

work aays blank in c

Figure: Cell D$12=90$

Figure Sense: What Excel functions are needed to accomplish the required task?

How should you use those functions to complete the task for the first cell?

Rules Worksheet

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 bidder's D&B PAYDEX score is greater than $65.$

The bidder's D&B Composite Credit Appraisal value is less than or equal to $2.$

The bidder's Net Worth is greater than $$500,000.$

Rule #$3$: Consider a bidder if any of the following criteria are met:

The bidder's D&B Stress Risk Class is equal to $1.$

The bidder's Previous Experience Grade is Satisfactory.

In column G$,$ calculate whether or not $($TRUE$/$FALSE$)$ the various bidders meet the criteria for Rule #$1.$ Do not use an IF statement.

Figure Sense: What Excel expression is needed to accomplish the required task?

Excel $5$

IST $310$: Introduction to Information and Management Productivity Systems

Page $1$

Check that your answers in column $G$ are correct by visually checking to see if the $D$&$B$ PAYDEX score is at least $90$ for each row.

$5.$ In column $H,$ calculate whether or not $($TRUE$/$FALSE$)$ the various bidders meet the criteria for Rule #$2.$ Do not use an IF statement.

Figure Sense: What Excel function is needed to accomplish the required task?

How should you use that function to complete the task for the first cell?

One way to check that your answers are correct is to copy the columns of the Rules worksheet into the Figure Sense worksheet. In column K$,$ enter your expression for D&B PAYDEX score is