Code question 6 with excel VB! List step by step of code and show screen shots

* 25% 5:23 PM blackboard.tamuk.edu .ill AT&T 714 Note in the above code we have used the variable "sum" as an accumulator. Note when i-1 surro, then it is assapod a value of sum 100,000, which is 100,000, when-2 sum-100,000 and then as assigned a value of 100,000+150,000 . this epealin is repeated until all salanes of all the employees are added 10 Visual basic tutorial problems, developed by Dr. Clement, clement@ auburn.eda Test Preblem-6: Understanding simple ene dimensional arrays Problem Statement Deagn a VB program to compute the areas ef-,-number of sqaares and circles, given theit characteristic dimensions (length of the side foe squares or radius for circles). The valae of u" and the dimemices are entiered in the specadsheet as show belew EXCEL to create the above spreadsheet Setup a command buttion and enter the following code: Option Explieit Option Base 1 Private Sub Mycode Click Dim i As Integer, n As Integer, A As Single Dim resultlo As Single. reault20 As Single nCells(2. 1) ror i 1 To n Step 1 resulti(S)A2 result24)3.14A2 Next i For i 1 To n Step 1 Cells(3 2)-resulel( Cells(3 +,3)-result214) Next i End Sub Run the code and you will see that your spreadsheet will be updated with the data shown below 28 50 78