Question

1.if the cell B2 is 68, and you enter the formula =IF (B2>60, ''Pass'', ''Fail'') what would be printed as the result?
2.Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function? *

Answer 1

a microscopic membrane of lipids and proteins which forms the external boundary of the cytoplasm of a cell or encloses a vacuole, and regulates the passage of molecules in and out of the cytoplasm.

Answer 2

1. If the cell B2 is 68, and you enter the formula

=IF (B2>60, ''Pas'', ''Fail'')

The printed result will be "Pas".

Here in the given formula first we have a conditional operator that will check whether the value of B2 is greater than 60 or not.

If the value is greater than 60 then it will print "Pas" or else it will print "Fail".

Here, in this case, it is given that the value of B2 is 68 which is greater than 62 therefore it will print "Pas".

2. The correct syntax for the VLOOKUP function is:

=VLOOKUP(H2, B2:G3,7, FALSE)

Here,

H2 is in the place where we enter the blank cell where we want our value to be stored.

B2:G3 denotes the table range in which the value is to be searched for.

7 is the column index.

Then TRUE or FALSE signifies partial or exact matches respectively.