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 3 excellent YES 15 poor NO 12 acceptable NO 2 good NO 10 good YES 4) Which formula could have been used to calculate the values in the Bonus column. A) =IF(Rating="good" AND IF (Years>=10," YES "," NO")) B) =IF(Years>=10 AND (Rating="excellent" OR Rating="good"),"YES","NO") C) =IF(Years>=10 AND (Rating>="good"),"Yes","No") D) =IF(Rating>="good",IF(Years>=10,"YES", "NO"),"NO")) E) =IF(OR(AND(Years>=10, Rating="good"),Rating="excellent"),"YES","NO") 5) Excel's LOOKUP function is often used to replace the use of A) the FREQUENCY function B) the SUMIF function C) the COUNTIF function D) the IF function E) none of the above E1...
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