Consider the following code:

Result= input_number Mod 7

If (Result > 0) Then

Cells(1,1).Value = 3

Else

NextResult = input_number Mod 5

If (NextResult > 0) Then

Cells(1,1).Value = 2

Else

Cells(1,1).Value = 1

End If

End If

What will be the content of cell A1 if input_number equals 56?

a. 3

b. 2

c. 1

d. 6

I picked A, am I right??

Consider the following custom function:

Public Function Discount(quantity As Integer) As Single

IF (quantity <= 5) Then Discount = 0

Else

IF (quantity <= 10) Then Discount = 0.1

Else

Discount = 0.15

End IF

End IF

End Function

Suppose you enter the following formula in B1: =Discount(12). What will be the result in B1?

a. 5

b. 0.1

c. 0.15

d. 0

I picked C, am I right?

Consider the following code segment:

SumTotal = 1

IF (SumTotal < 5) Then

SumTotal = SumTotal + 3

End IF

What will be the value of SumTotal when the program comes out of the loop?

a. 5

b. 7

c. 3

d. 10

I picked B, am I right??

thanks for all your help