This preview shows page 1. Sign up to view the full content.
Unformatted text preview: considered . Assume the columns are named as shown. Years Rating Bonus 12 acceptable NO 3 excellent YES 2 good NO 10 good YES 15 poor NO 4) Which formula could have been used to calculate the values in the Bonus column. A) =IF(OR(AND(Years>=10, Rating="good"),Rating="excellent"),"YES","NO") B) =IF(Rating="excellent","YES",IF(Rating="good",IF(Years>=10,"YES", "NO"),"NO")) C) =IF(Rating="good" AND IF (Years>=10," YES "," NO"))) D) =IF(Years>=10 AND (Rating="excellent" OR Rating="good"),"YES","NO") E) =IF(Years>=10 AND (Rating>="good"),"Yes","No") 5) Excel's IF function can often be used to replace the use of A) the SUMIF function B) the LOOKUP function C) the FREQUENCY function D) the COUNTIF function E) none of the above E2...
View
Full
Document
This note was uploaded on 12/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.
 Spring '09
 PAUL

Click to edit the document details