Chapter 4 - Decision Logic Flashcards

1
Q

What is the key to statements?

A

The expressions they contain

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False:

Some condition must be true before the specified action may be taken

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the format of the IF Formula?

A

IF(condition,true,false)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which conditions are created when comparing variables with relational operators by evaluating a Boolean variable?

A

True or False conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are created when conditions are evaluated?

A

Boolean variables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Fill in the Blanks:

The ___ statement is considered data expanding while the ___ is data reducing

A
  1. OR

2. AND

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following is an example of how the NOT statement should be used in a function?

A. (NOT(T and F) or (T and F))
B. NOT( F or F )
C. Not(F)
D. All of the above

A

D. All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What do you create when you join separate conditions with the ‘AND’ and the ‘OR’?

A

A compound condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a compound condition’s order of evaluation?

A

Evaluate ANDs before ORs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which type of statements handle more complex logic?

A

Nested IF statements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Give returning customers who have spent more than $1000, a 10% “loyalty discount.” If the customer is a returning customer, there is a 1 in the A column of the customer’s row. The amount owed is in B3.

What would this formula look like using the compound condition format?

A

=IF(AND(A1=1, B3>1000), b3.9, b31.00)

If Returning Customer (A1 = 1) AND
Spent more than $1000 (B3 > $1000) Then
provide discount (Multiply B3 by .90)
Else
provide no discount (Multiply B3 b 1.00)
End If

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Give returning customers who have spent more than $1000, a 10% “loyalty discount.” If the customer is a returning customer, there is a 1 in the A column of the customer’s row. The amount owed is in B3.

What would this formula look like using the nested IF statement format?

A

=IF(A1=1, IF(B3>1000, b3.9, b31.00), b3*1.00)

If Returning Customer (A1 = 1) AND
If Spent more than $1000 (If B3 > $1000) Then
provide discount (Multiply B3 by .90)
Else
provide no discount (Multiply B3 b 1.00)
End If
Else
provide no discount (Multiply B3 b 1.00)
End If

How well did you know this?
1
Not at all
2
3
4
5
Perfectly