Multiple Choice Identify the choice that best completes the statement or answers the question. Questions 18-24, refer to the following VBA program 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 22. If the value entered is 1000, what is the value of the variable Commission_Amount? a. 4

c. 40

b. 400

d. 60 23. What would be the value of Cells(6, 7).Value if the value entered is 1000?

a. 4

c. 60

b. 40

d. 400 24. Cells(6, 7).Value refers to Excel cell

a. F6

c. G6

b. H6

d. F7