Chapter 4 Quiz
=AND(NOT(F3),NOT(G3),NOT(H3)) is an example of a(n) _____ construct.
"None Of"
Relational operators can be used to evaluate _____.
numbers, text, dates
For the expression =B2=C2, the second equal sign is interpreted as a _____.
relational operator
To apply "Cell Value Is" conditional formatting, first _____.
select the cells you want to conditionally format
The relational operator for "not equal" is _____.
<>
=AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct.
"Only" (The formula =AND(F3,NOT(OR(G3:H3))) is an example of an "only" construct. (There's no such thing as an AND construct.) That formula would return TRUE only when F3 is TRUE and the other cells (G3:H3) are false. (ONLY F3 is true.) If F3 is TRUE and any (at least one) of the cells in G3:H3 are TRUE, the OR function in that formula would return TRUE. The NOT function would flip that TRUE to a FALSE. The AND function would then return a FALSE (since the result of the NOT function is FALSE). If F3 is TRUE and both of the cells in G3:H3 were FALSE, the OR function in that formula would return FALSE. The NOT function would flip that FALSE to a TRUE. The AND function would then return a TRUE (since the result of the NOT function is FALSE).)
If a cell contains the formula =Goodbye<Hello the resulting value is _____. (Assume no range names have been defined.)
#NAME?
An equivalent formula for =IF(G3=0,C3,C3+G3+25) is _____.
=IF(G3<>0,C3+G3+25,C3)
A(n) _____ function returns a value of TRUE only if all arguments in the function are TRUE.
AND
To find whether the value in cell A1 is in the twenties (between 20 and 29, inclusive), what function could you use?
AND
=AND(FALSE,FALSE,FALSE,FALSE,FALSE,FALSE) evaluates to _____.
FALSE
If B3 contains the date 12/31/2006 and C3 contains the date 12/31/2005, then =B3<C3 is _____.
FALSE
If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1 results in a value of _____.
FALSE
If the values in cells F3, F4, F5, and F6 are all less than 100, the function =OR(F3>100,F4>100,F5>100,F6>100) returns a value of ______.
FALSE
The AND function results in a FALSE value if either Condition #1 or Condition #2 is _____.
FALSE
The result of the formula =SUM(4,7)<>11 is _____.
FALSE
Be sure to always include an = sign in front of any formulas inserted within the Value_if_true or Value_if_false argument of an IF function.
False
If you want apply formatting to G3 based on the value in cell F3, use conditional formatting's "Format only cells that contain" option.
False
It's usually okay to hard-code (enter) text phrases in IF functions and Conditional formatting rules in order to make the formulas more flexible.
False
Relational operators can only be used to evaluate numbers...not text.
False
The logical construct =AND(A3:A30) is used when only one item must be TRUE to return a TRUE value.
False
The syntax of the NOT function can evaluate a range of values.
False
To evaluate a logical test and return a TRUE or FALSE value, you need to use an IF function.
False
When using a IF function, formulas can be used within a Value_if_true or Value_if_false argument if the formula is enclosed within quotation marks.
False
With regards to relational operators and text values, a greater value is one that appears earlier in the alphabet.
False
To find whether an integer in cell A1 is in the 20's (20, 21....29), you could use the following formula: =OR(A1>=20,A1<=29).
False (Enter the formula in Excel and try some following values in cell A1: 25 gives an answer of TRUE...but so do the values of 15 and 35. 15=29 therefore the first argument of the OR function produces TRUE. 35=20 therefore the second argument of the OR function produces TRUE. =AND(A1=20,A1=29) is the correct formula to use.)
If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula =OR(F3:F6>100) will always return a value of TRUE.
False (The answer to the question is FALSE. The result cannot be relied upon to be correct since the formula above is invalid...it incorrectly uses the syntax of the OR function. You cannot compare a range of values (i.e. F3:F6) to a single value, as shown by the formula =OR(F3:F6gt;100).nbsp; If you do, Excel calculates something along the lines ofnbsp; =OR(F:Fgt;100), just evaluating the value in column F in the same row as the formula.nbsp; You could use a formula like this =OR(F3gt;100,F4gt;100,F5gt;100,F6gt;100)...but you'd have to use an extremely longnbsp; formula if you want to evaluate 100 cells.nbsp; Another way is to use an extra column of formulas which test each individual cell, and then use an OR to evaluate the extra column (as shown in the Ch4 Demo file).nbsp; OR, you could use Array formulas, also shown in the Demo file./p pPlease refer to the Ch4 Demo file for examples of why the formula =OR(F3:F6gt;100) is an invalid use of the function. (Note: The Best Practice box on page 226 of the textbook also gives further explanation.)
To change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____ function.
NOT
A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
OR
A(n) _____ function returns a value of TRUE if at least one argument is TRUE.
OR
For the formula =3+7=10, the resulting value is _____.
TRUE
The formula =OR(45<44,MIN(1,10)<2,3<=2+1) returns a value of ______.
TRUE
The formula =OR(B5:B25) returns a value of _____ if any of the values in B5 through B25 contain the value TRUE.
TRUE
When using an OR function, if only one of two arguments equals FALSE (and the other argument equals TRUE), an OR function results in a value of _____.
TRUE
In Excel, relational operators can be used to determine if an expression is _____.
TRUE or FALSE
(Ignoring the initial = that precedes a formula,) you cannot use two operators (<=, >=, =, etc.) within the same logical_test argument of an IF function unless you also use an additional function such as OR or AND.
True
Relational expressions are not case sensitive.
True
Relational operators can be used to evaluate dates.
True
TRUE and FALSE are Boolean values.
True
The OR function evaluates logical arguments to determine if at least one argument is TRUE.
True
The comparison phrase of "not between" means to identify values outside of lower and upper limits.
True
The comparison phrase of "between" is used to _____.
set lower and upper limits inclusive of the specified values
For the expression =A5=B5, the first equal sign is interpreted as _____.
the beginning of the formula
