Excel Final Iii

Front 1

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

Back 1

relational operator

Front 2

If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1 results in a value of _____.

Back 2

FALSE

Front 3

To apply "Cell Value Is" conditional formatting, first _____.

Back 3

select the cells you want to conditionally format

Front 4

Relational expressions are not case sensitive

Back 4

True

Front 5

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

Back 5

FALSE

Front 6

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

Back 6

FALSE

Front 7

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

Back 7

"Only"

Front 8

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

Back 8

True

Front 9

The relational operator for "not equal" is _____.

Back 9

<>

Front 10

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.

Back 10

False

Front 11

Relational operators can be used to evaluate _____.

Back 11

All three of the listed answers (text, dates, numbers)

Front 12

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

Back 12

"None Of"

Front 13

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

Back 13

AND

Front 14

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

Back 14

False

Front 15

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

Back 15

OR

Front 16

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.

Back 16

False

Front 17

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

Back 17

False

Front 18

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

Back 18

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

Front 19

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

Back 19

True

Front 20

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.

Back 20

false

Front 21

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

Back 21

False

Front 22

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

Back 22

False

Front 23

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

Back 23

NOT

Front 24

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

Back 24

False

Front 25

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.

Back 25

False

Front 26

The formula =OR(45<44,MIN(1,10)<2,3<=2+1) returns a value of ______.

Back 26

True

Front 27

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

Back 27

True of false

Front 28

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

Back 28

the beginning of the formula

Front 29

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

Back 29

TRUE

Front 30

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

Back 30

OR

Front 31

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

Back 31

True

Front 32

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

Back 32

AND

Front 33

TRUE and FALSE are Boolean values.

Back 33

True

Front 34

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

Back 34

True

Front 35

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

Back 35

set lower and upper limits inclusive of the specified values

Front 36

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

Back 36

FALSE

Front 37

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

Back 37

False

Front 38

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

Back 38

False

Front 39

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

Back 39

#NAME?

Front 40

Relational operators can be used to evaluate dates.

Back 40

True