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