# Using Nested Functions Test

## Free Online Microsoft Excel Tests Excel 2010 Training - Formulas and Functions

### Using Nested Functions Test

1) Study the screenshot above.  Which of the formulas listed in the options below, if entered into cell B1, will return the value FALSE?
a) =AND(A1>0,A2="Gold")
b) =OR(A1>3000,A2="Gold")
c) =AND(A1>3000,A2="Gold")
d) =NOT(A1>1500)

2) Study the syntax for the formulas in the options below.  Which one contains an error?

a) =IF(OR(Logical_1, Logical_2, Logical_3) value_if_true, value_if_false)
b) =IF(OR(Logical_1, Logical_2), value_if_true, value_if_false)
c) =IF(AND(Logical_1, Logical_2), value_if_true, value_if_false)
d) =AND(IF(Logical_1, Logical_2), value_if_true, value_if_false)

3) Study the screenshot above.  What value will cell B1 contain when the above formula is executed?
a) It will contain the phrase No Bonus.
b) It will contain the value TRUE.
c) It will contain the value FALSE.
d) It will contain the phrase Bonus Paid.

4) Which of the following statements are true about the OR function?
a) All conditions must be met for an OR function to return a TRUE value.
b) One of the conditions must be met for an OR function to return a TRUE value.
c) None of the conditions need to be met for an OR function to return a TRUE value.
d) The OR function always evaluates to TRUE.

5) How many logical conditions can a NOT function contain?
a) It can contain up to four logical conditions.
b) It can contain an unlimited number of logical conditions.
c) It can contain only one logical condition.
d) It can contain up to 22 logical conditions.

6) An IF statement can be nested within another IF statement to evaluate multiple conditions.  Study the formulas in the options below. Which one is correct?
a) =IF(A1>=150,"Bonus Paid",IF(A1>=100,"Voucher Given",IF(A1<99,"Further Training","Error")))
b) =IF(IF(IF(A1>=150,"Bonus Paid", A1>=100,"Voucher Given",A1<99,"Further Training","Error")))
c) =IF(A1>=150,"Bonus Paid"),IF(A1>=100,"Voucher Given"),IF(A1<99,"Further Training","Error")))
d) All of the formulas listed above are incorrect.

7) Study the screenshot above.  What will the result in cell B2 be when this formula is executed?
a) Testing Complete
b) Further Testing
c) FALSE
d) TRUE

8) Which of the following statements are true about the AND function?
a) All logical conditions that have been included in an AND function must be met for the function to evaluate to TRUE.
b) All logical conditions that have been included in an AND function must be met for the function to evaluate to FALSE.
c) At least one of the logical conditions that have been included in an AND function must be met for the function to evaluate to TRUE.
d) None of the logical conditions that have been included in an AND function has to be met for the function to evaluate to TRUE.

9) Study the screenshot above.  When this AND formula is executed, what value will it return?
a) It will return Yes.
b) It will return FALSE.
c) It will return TRUE.
d) None of the options listed above are correct.

10) Study the screenshot above.  When this OR formula is executed, what value will it return?
a) It will return TRUE.
b) It will return an error.
c) It will return Class D2.
d) It will return FALSE.