Here is the display of a worksheet. 1 Name Monthly Salary HK$12,265 2 Peter 3 Ann...

Transcribed Image Text:

Here is the display of a worksheet. 1 Name Monthly Salary HK$12,265 2 Peter 3 Ann HK$14,780 HK$16,790 HK$30,165 4 Bob 5 Cathy 6. 7 Average HK$18,500 The numbers displayed in the worksheet have been formatted with the currency format so that a number 1000 would be displayed as 'HK$1,000: The average salary of the four people in cell B7 is calculated bya macro shown below. Sub ComputerAveragešalary() Dim Row As Integer, Sum As Long Dim CountRow As Integer Sum = 0 CountRow =e For Row = 2 To 5 Sum = Sum + Cells (Row, 2). Value CountRow = CountRow + 1 Next Row Range("B7").Value= Blank End Sub You need to fill in the blank so that the average is calculated correctly for the four people in the table. You cannot use any number in your answer. You can only use variables and operators. You need to write the answer clearly in the box below. Do not write any spaces in the answer. For example, if you need to write an expression such as A+ B., you will write A+B without any spaces in between. Here is the display of a worksheet. 1 Name Monthly Salary HK$12,265 2 Peter 3 Ann HK$14,780 HK$16,790 HK$30,165 4 Bob 5 Cathy 6. 7 Average HK$18,500 The numbers displayed in the worksheet have been formatted with the currency format so that a number 1000 would be displayed as 'HK$1,000: The average salary of the four people in cell B7 is calculated bya macro shown below. Sub ComputerAveragešalary() Dim Row As Integer, Sum As Long Dim CountRow As Integer Sum = 0 CountRow =e For Row = 2 To 5 Sum = Sum + Cells (Row, 2). Value CountRow = CountRow + 1 Next Row Range("B7").Value= Blank End Sub You need to fill in the blank so that the average is calculated correctly for the four people in the table. You cannot use any number in your answer. You can only use variables and operators. You need to write the answer clearly in the box below. Do not write any spaces in the answer. For example, if you need to write an expression such as A+ B., you will write A+B without any spaces in between.

Answer rating: 100% (QA)

The answer in the blank would be SumCountRow See a loop has b... View the full answer