The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cell
Posted: Fri May 20, 2022 2:58 pm
The following Excel image has a VBA program (see below). What
will be the result after the program is executed? Any cells not
displayed are currently empty, and any cells with numbers are
formatted numeric. Sub GDP() k = 0 finalrow = Cells(Rows.Count,
1).End(xlUp).Row For i = 7 To finalrow step 2 k = k + Cells(i,
2).Value Next Cells(finalrow + 2, 1).Value = "The SUM of GDP is"
Cells(finalrow + 2, 2).Value = k End Sub
30
50
40
The program is incorrect-will not run
60
will be the result after the program is executed? Any cells not
displayed are currently empty, and any cells with numbers are
formatted numeric. Sub GDP() k = 0 finalrow = Cells(Rows.Count,
1).End(xlUp).Row For i = 7 To finalrow step 2 k = k + Cells(i,
2).Value Next Cells(finalrow + 2, 1).Value = "The SUM of GDP is"
Cells(finalrow + 2, 2).Value = k End Sub
30
50
40
The program is incorrect-will not run
60