Quiz 6 Flashcards
Evaluate the following function:
=IF(AND(10<20, 20>5, 30<10), C$2*D$3, 0)
0
True or False?
The IF function evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE
True
True or False?
The logical value TRUE is treated the same as the text string “TRUE”.
False
Nesting can be used with an IF function to decide between more than two different results. According to the course notes, how many levels of nesting can be used with the IF function in Excel 2019?
64
What will happen if, in an IF function, you accidentally omit the quotes from the value_if_true and value_if_false arguments as follows?
=IF(C4, eligible, ineligible)
A. Excel will automatically put quotes around these for you and the function will execute without an error
B. Excel will default to putting in 0 for the if_value_true argument and = for the if_value_false argument when the condition is met
C. Excel will look for a range named eligible or ineligible (depending on which condition was met) and either returns the value from that range or gives a #NAME? error if the named range does not exist
D. Excel will not allow you to complete the function
C
What is the answer to this function?
A1 = FALSE
=IF(A1=”False”, 20, 0)
0
The logical IF function takes a Boolean value as its first argument. This value can be:
A. The result of a Boolean function
B. A reference to a cell containing a Boolean value
C. The result of a relational expression
D. All of the above
D
True or False?
It is not possible to nest Boolean logical functions for a logical testin the logical_test argument of the IF function in Excel.
False
True or False?
Constructing a decision tree to visually represent the logic in a multi-outcome IF problem is often recommended before translating it into Excel pseudo code and then the nested IF function
True
Which of the following is true about the IF function in Excel?
A. If the value_if_false argument of the IF function is omitted, it will return a 0 when the condition is met
B. If the value_if_true argument of the IF function is omitted, it will return a 0 when the condition is met
C. Only the first argument to the IF function is required
D. You can perform a corresponding math operation in the if_value_true or if_value_false arguments by using arithmetic operators or other Excel functions
E. All of the above
E
