21. What is the number of times the statements in the above loop run? a. 22 c. 1

Question

21. What is the number of times the statements in the above loop run? a. 22 c. 11 b. 3 d. 13

22. The condition in the Do Until (Row = 14) is a. checked before the other statements are run c. is not a logical condition b. checked after the other statements are run d. is never checked

23. When the code is run, the final value of the variable Row calculated is a. 11 c. 13 b. 12 d. 14

24. if the variable Row =5, Cells(Row, 3).Value refers to Excel cell a. C6 c. C7 b. C5 d. B5

Suppose sheet 1 of the Excel book the program refers too looks like that 2 Name 3 Namel $ 4 Name2$ 5 Name3 $ 6 Name4 $ 7 Name5 $ 8 Name6 $ 9 Name7$ 10 Name8 $ 11 Name9 $ 2 Name10 $ 13 Name11 $ 14 Total Sales Bonus 11,500 10,000 13,000 7,000 9,000 8,800 12,000 6,500 6,700 5,000 7,900 Option Explicit Dim Total _Sales As Currency, Commission_Amount As Currency Dim Row As Integer, Counter As Integer, Sum As Integer Private Sub Calculate_1_Commission() initialized to Row # 3 Row 3 Do Until (Row 14) Total_Sales Cells (Row, 2).Value If Total Sales> 10000 Then Commission. Amount Total-Sales * (6 / 100) Elself Total Sales> 9000 Then Commission_Amount Total Sales (5 /100) Else Commission AmountTotal Sales (4 /100) End If Cells(Row, 3).Value Commission Amount Row Row +1 Loop End Sub

Explanation / Answer

21-The loop will run for 11 times.as the value of row at start =3,it will run unless row value become 14.therefore from 3-4 no of loop =1.go on increasing step we will get 11as answer.

22-statement will be checked before the operation of other statement

23-final value of variable row=14

Since it's value is calculated first and checked at last.

24-c5.because row 3 denotes c

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.