Quiz 5 Flashcards
True or False?
Arguments to the AND or OR functions may consist of any combination of cell references, values, and ranges such that each reduce to a single TRUE or FALSE value
True
Evaluate this function:
=”CSE”=”cse”
True
True or False?
The formula:
=OR(D2:D6 <= C2:C6)
is not valid syntax and will result in a #VALUE! error or an incorrect result from Excel
True
A1=TRUE, A2=FALSE, A3=TRUE
What is the result of =NOT(A1,A2,A3)
A. True
B. False
C. None of the above
C
Evaluate the following function:
NOT(30<35)
FALSE
Which of the following keywords or phrases would NOT be used to indicate the use of an OR function in the answer
A. or
B. any
C. at least one
D. all
E. All of the above
D
True or False?
The logical value TRUE is treated the same as the text string “TRUE”
False
What types of questions do Boolean functions answer?
A. Is travel the largest component of the total cost of the trip?
B. Does the Boston trip cost more than the New York trip?
C. Was last year’s income greater than this year’s income?
D. Is the total cost of the trip within budget?
E. All of the above
E
Which of the following is an example of a relational expression that equates to TRUE or FALSE?
A. =SUM(A2:A20)
B. =COUNT(B5, D2, C3)
C. =3+5
D. =A4>=COUNT(A3:A10)
E. All of the above
D
Which formula below equates to FALSE?
A. “Dimple” >= “Crack”
B. “Apple” > “Big”
C. “Big” > “Apple”
D. “BIG” = “big”
E. None of the above
B
