Chapter 4 - Decision Logic Flashcards Preview

Quantitive Analysis with Excel > Chapter 4 - Decision Logic > Flashcards

Flashcards in Chapter 4 - Decision Logic Deck (12)
Loading flashcards...
1

What is the key to statements?

The expressions they contain

2

True or False:

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

True

3

What is the format of the IF Formula?

IF(condition,true,false)

4

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

True or False conditions

5

What are created when conditions are evaluated?

Boolean variables

6

Fill in the Blanks:

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

1. OR
2. AND

7

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

D. All of the above

8

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

A compound condition

9

What is a compound condition's order of evaluation?

Evaluate ANDs before ORs

10

Which type of statements handle more complex logic?

Nested IF statements

11

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?

=IF(AND(A1=1, B3>1000), b3*.9, b3*1.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

12

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?

=IF(A1=1, IF(B3>1000, b3*.9, b3*1.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