Quiz 4

Question 1

If a cell contains the formula =Goodbye

Answer 1

NAME?

Question 2

If B3 contains the date 12/31/2006 and C3 contains the date 12/31/2005, then =B3

Answer 2

FALSE

Question 3

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

Answer 3

NOT

Question 4

If you want apply formatting to G3 based on the value in cell F3, use conditional formatting’s “Format only cells that contain” option.

Answer 4

False

Question 5

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

Answer 5

OR

Question 6

Relational operators can be used to evaluate dates.

Answer 6

True

Question 7

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

Answer 7

TRUE

Question 8

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.

Answer 8

False

Question 9

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

Answer 9

FALSE

Question 10

To apply “Cell Value Is” conditional formatting, first _____.

Answer 10

select the cells you want to conditionally format

Question 11

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

Answer 11

relational operator

Question 12

The comparison phrase of “between” is used to _____.

Answer 12

set lower and upper limits inclusive of the specified values

Question 13

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

Answer 13

AND

Question 14

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

Answer 14

True

Question 15

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

Answer 15

FALSE

Question 16

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

Answer 16

=IF(G30,C3+G3+25,C3)

Question 17

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

Answer 17

FALSE

Question 18

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

Answer 18

“Only”

Question 19

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

Answer 19

“None Of”

Question 20

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

Answer 20

AND

Question 21

To evaluate a logical test and return a TRUE or FALSE value, you need to use an IF function.

Answer 21

False

Question 22

The relational operator for “not equal” is _____.

Question 23

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

Answer 23

False

Question 24

The OR function evaluates logical arguments to determine if at least one argument is TRUE.

Answer 24

True

Question 25

In Excel, relational operators can be used to determine if an expression is _____.

Answer 25

TRUE or FALSE

Question 26

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

Answer 26

False

Question 27

Relational expressions are not case sensitive.

Answer 27

True

Question 28

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.

Answer 28

False

Question 29

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

Answer 29

the beginning of the formula

Question 30

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

Answer 30

False

Question 31

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

Answer 31

False

Question 32

With regards to relational operators and text values, a greater value is one that appears earlier in the alphabet.

Answer 32

False

Question 33

Relational operators can be used to evaluate _____.

Answer 33

All three of the listed answers.

Question 34

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

Answer 34

TRUE

Question 35

The formula =OR(45

Answer 35

TRUE

Question 36

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

Answer 36

FALSE

Question 37

The comparison phrase of “not between” means to identify values outside of lower and upper limits.

Answer 37

True

Question 38

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.

Answer 38

False

Question 39

The formula =OR(B5:B25) returns a value of _____ if any of the values in B5 through B25 contain the value TRUE.

Answer 39

TRUE

Question 40

TRUE and FALSE are Boolean values.

Answer 40

True

Question 41

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.

Answer 41

False

Question 42

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

Answer 42

OR

Question 43

If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1

Answer 43

FALSE