Quiz 2 - Excel

There is an IF statement in cell C2 that enters a text string No Action if the Systolic blood pressure reading in column B is less than 130.  If it is not less than 130, the formula enters the text string Monitor.

What is the condition of this IF statement?

• B1 < 176

• B2 < 176

• B1 < 130

• B2 < 130

Given the IF statement shown in E2, what will appear in E2?

• 10

• 880

• 890

• Yes

Choose the IF statement in cell C2 that enters a text string of "No Commission" if the sales amount in column B is less than $250 dollars; and if sales are at least $250, enters 10% of the sales amount.

• =IF(B2>=250,10%*B2,"No Commission")

• =IF(A2>=250,"No Commission",10%*B2)

• =IF(B2>=250,"No Commission",10%*B2)

• =IF(B2>=250,"No Commission",10%*B2)

Given the IF statement shown in D2, what will we see in D2?

• Yes

• No

Pick the correct IF statement for cell D2 that enters a text string Make Appointment if the Systolic blood pressure reading in column B is greater than or equal to 135.  If it is not greater than or equal to 135, create another IF statement that examines the Diastolic blood pressure in column C.  If the Diastolic reading is greater than 100, enter the text string Make Appointment.  If the Diastolic reading is not greater than 100, enter the text string Monitor.

• =IF(B2>=135,”Monitor”,IF(C2>100,” Monitor”,”Make Appointment”))

• =IF(B2>=135,”Make Appointment”,IF(C2>100,” Make Appointment”,”Monitor”))

• =IF(B2>=125,”Make Appointment”,IF(C2>100,” Make Appointment”,”Monitor”))

• =IF(B2>=135,”Make Appointment”,IF(C2>102,” Monitor”,”Make Appointment”))

Pick the formula (for cell A8) that will provide the retail price of any product appearing in cell A2.

• =vlookup($A$2, $C$2:$E$13, 3, FALSE)

• =vlookup($A$8, $C$2:$E$13, 2, FALSE)

• =vlookup($A$8, $C$2:$E$13, 3, FALSE)

• =vlookup($A$5, $C$2:$E$13, 2, FALSE)

Formula in A5:=VLOOKUP(A2,$C$2:$H$9,3,FALSE)What number appears in A5?

• 252

• 356

• 397

• 667

• #NA (Error Message)

The lookup formula for cell A4 is shown. What value will appear in cell A4?

Hint: Remember that the default value for Range_Lookup is TRUE, meaning it will look for an approximate match.

• 9

• 11

• 12

• 15

• 21

Given the sheet protection configuration shown, which of the following statements is true after sheet protection is applied? 

• Users can make any cell active, edit the sheet, and see formulas as normal

• Users can make cells active, and see formulas in those cells, but cannot click in any other cells in the worksheet

• Users can see formulas for all cells in the worksheet but cannot edit them

• Users cannot make any worksheet cells active, nor see any formulas in them

In the figure shown, which checkboxes should be checked to allow users to access only specific spreadsheet cells?

• Select locked cells

• Select unlocked cells

• Format cells

• Format columns