Question: Option Explicit Dim Total _ Sales As Currency, Commission _ Amount As Currency Private Sub Calculate _ Commission ( ) Total _ Sales = InputBox

Option Explicit
Dim Total_Sales As Currency, Commission_Amount As Currency
Private Sub Calculate_Commission()
Total_Sales = InputBox("enter the total sales in $")
If Total_Sales >10000 Then
Commission_Amount = Total_Sales *(6/100)
ElseIf Total_Sales >9000 Then
Commission_Amount = Total_Sales *(5/100)
Else
Commission_Amount = Total_Sales *(4/100)
End If
Cells(6,7).Value = Commission_Amount
End Sub
18. When the code is run, what is the message displayed?
a. enter the total sales c. enter the total sales in
b. enter the total sales in # d. enter the total sales in $
19. If the value entered is 5000, what is the value of the variable Commission_Amount?
a.220 c.250
b.300 d.200
20. If the value entered is 9999, what is the value of the variable Commission_Amount?
a.599.94 c.399.96
b.499.95 d.299.96
21. If the value entered is 20000, what is the value of the variable Commission_Amount?
a.1200 c.600
b.800 d.650

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!