{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# E2 - considered Assume the columns are named as shown Years...

This preview shows page 1. Sign up to view the full content.

Part E – Multiple Choice [5 points] Circle the letter representing the best choice for each of the following questions. 1) A column in an Excel worksheet named Letter Grade contains the formula =IF(Score>=80,"A",IF(Score<50,"F",IF(Score<60,"D",IF(Score>=70,"B","C")))) What will appear in Letter Grade when Score is 75? A) A B) B C) C D) D E) F 2) Referring to the formula in the previous question, what will appear in Letter Grade when Score is 55? A) A B) B C) C D) D E) F 3) Which of the following expressions could NOT be the first argument in an Excel IF function? A) A1 < C1 B) "A1" < "C1" C) "A1 < C1" D) ISEMPTY(A1) E) NOT(A1<C1) A company decides to give some of its employees a holiday bonus. Those who have been employed at the company for at least 10 years get a bonus if their performance is considered either good or excellent . Those who have not been employed at the company that long get a bonus only if their performance is
This is the end of the preview. Sign up to access the rest of the document.

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

{[ snackBarMessage ]}