The question is

In cell K2, write a formula which can be copied down to cells K3:K8, to determine if the cards credit limit

is within 20% (inclusive) of the Average credit card limit. Display the word, ACCEPTABLE if it is,

otherwise display the word, NA.

Now we need to use an IF statement because we are not displaying the words true or false in the cells.

=IF(AND( ___ >= AVERAGE(___:___) * 0.8 , ___

A B D E F G H L M Acceptable Not a Credit Limit? Visa Card? No Introductory Rate of 0%? Credit Annual 1 Credit Card Type Limit Fee 2 Capital One Venture Visa $5,000 3 Bank Of America Visa $9,000 4 Fifth Third Mastercard $2,500 5 Discover Discover $4,000 6 Slate Visa $6,000 7 U.S. Bank Mastercard 8 Simmons First Visa $4,500 9 10 All Cards have an Introductory Rate of 0% (T/F)? 11 At least one Card has an Introductory Rate of 0% (T/F)? 12 0 59 29 25 59 20 Lowest Highest Introductory Credit Card Limit Acceptable Lowest APR APR Rate of 0% >$5000? APR? APR? 11.90% 19.90% TRUE FALSE 13.74% 22.74% TRUE TRUE 7.00% 21.99% FALSE FALSE 10.99% 22.90% FALSE FALSE 10.99% 18.99% FALSE TRUE 11.99% 21.99% TRUE FALSE 10.99% 20.99% FALSE FALSE $2,000 0