1. Study the VBA function shown below. Then create a \"Stepping Table\" that kee

Q: 1. Study the VBA function shown below. Then create a \"Stepping Table\" that kee

Answer 1 : Stepping Table to track variables a, joe and jack for the given function a joe jack For i=1 24 16 2.5 For i=2 104 96 5 For i=3 424 416 7.5 For i=4 1704 1696 10 Answer 2 : Coding for the nested loop will look like : Dim m, n As Integer Dim i As Integer = 0 For m = 10 To 3 Step -1 For n = 1 To 10 Step 2 i = i + (m * n) Next n Next m a joe jack For i=1 24 16 2.5 For i=2 104 96 5 For i=3 424 416 7.5 For i=4 1704 1696 10

ID: 3594140 • Letter: 1

Question

1. Study the VBA function shown below. Then create a "Stepping Table" that keeps track of a, Joe, and Jack. Let a = 4, b = 2, c = 3, and d = 5 as values that are inputted from your Excel worksheet. Function tempo (a,b,c,d) For i = 1 To 4 joe = a-c-d Jack-jack + 2.5 Next i tempo jack End Function 2. Create a set of nested For/Next loops based on the following instructions: a. Use m as the counter for the outer loop and allow it to have a start value of 10 and an end value of 3. Use a step size of-1 b. Use n as the counter for the inner loop and allow it to have a start value of 1 and an end value of 10. Use a step size of 2. There is only a single statement within the inside loop. That statement is: c. i = i + (m*n) Show what the nested loops look like and what is the final value of i once both of the For/Next loops exit.

Explanation / Answer

Answer 1 : Stepping Table to track variables a, joe and jack for the given function

joe

jack

For i=1

2.5

For i=2

104

For i=3

424

416

7.5

For i=4

1704

1696

Answer 2 : Coding for the nested loop will look like :

Dim m, n As Integer

Dim i As Integer = 0

For m = 10 To 3 Step -1
For n = 1 To 10 Step 2
i = i + (m * n)
Next n
Next m