Chapter 4

The relational operator for "not equal" is _____.

<>

An equivalent formula for =IF(G3=0,C3,C3+G3+25) is _____.

=IF(G3<>0,C3+G3+25,C3)

To find whether the value in cell A1 is between 5 and 10 (inclusive), what function could you use?

AND

For the expression =A5=B5, the first equal sign is interpreted as _____.

Beginning of formula

=AND(FALSE,FALSE,FALSE,FALSE,FALSE,FALSE) evaluates to _____.

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 B3 contains the date 12/31/2006 and C3 contains the date 12/31/2005, then =B3<C3 is _____.

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

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

The AND function results in a FALSE value if either Condition #1 or Condition #2 is _____.

False

The logical construct =AND(A3:A30) is used when only one item must be TRUE to return a TRUE value.

False

The result of the formula =SUM(4,7)<>11 is _____.

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

Relational operators can only be used to evaluate numbers...not text

False --- can evaluate values, text labels, and dates.

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......15 would work for this but doesn't fall under 20-29.

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: Use a formula to determine which cells to format."

To change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____ function.

NOT

=AND(NOT(F3),NOT(G3),NOT(H3)) is an example of a(n) _____ construct

None of

A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.

OR

=AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct.

Only

For the expression =B2=C2, the second equal sign is interpreted as a _____.

Relational operator

(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

A(n) _____ function returns a value of TRUE only if all arguments in the function are TRUE.

True

For the formula =3+7=10, the resulting value is _____.

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 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

And function

Used to determine if all arguments are true

Or function

Used to determine if either argument is true

To apply "Cell Value Is" conditional formatting, first ___

select the cells you want to conditionally format

The comparison phrase of "between" is used to _____.

set lower and upper limits inclusive of the specified values

Relational operators can be used to evaluate _____.

text, date, values

Not function

Evaluates only one logical argument to determine if it is false

The syntax of the NOT function can evaluate a range of values.

False --- evaluates only one logical argument: NOT (Logical1)

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-----formula is incorrect. Or function can't evaluate a range of values to one value.

A(n) _____ function returns a value of TRUE if at least one argument is TRUE.

OR

If a cell contains the formula =Goodbye<Hello the resulting value is _____. (Assume no range names have been defined.)

#NAME?