facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Free Excel Tests – Using Nested Functions Test – Excel 2010 – Formulas and Functions

Using Nested Functions Test

Free Online Microsoft Excel Tests
Excel 2010 Training – Formulas and Functions

* Using a Nested IF function
* Using the OR function
* Using the AND function
* Using the NOT function

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Using Nested Functions Test

Question 1 - Using Nested Functions Excel 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)



Question 3 - Using Nested Functions Excel Test

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.


Question 7 - Using Nested Functions Excel Test
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.


Question 9 - Using Nested Functions Excel Test
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.


Question 10 - Using Nested Functions Excel Test
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.



* More from TestsTestsTests.com