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. B C D E F G First EmployeelD Last Name Date Hired Vacation Days Salary Flex Time 1 Name 2 JTAN Tanner Joyce 9/24/1997 10 $1,000 yes 3 KANT Anthony Ken 5/15/1995 9 $2,000 yes 4 KCLI Clifton Katherine 6/8/1996 8 $3,000 yes 5 6 7 JPAO Paolucci Jennifer 7/7/1994 7 $4,000 no 8 WCHA Chan Wei 3/23/1995 6 $5,000 no 9 10 RALV Alverez Rosa 8/28/1996 5 $6,000 no Knight Carolyn 4/15/1994 4 $7,000 yes 11 CKNI 12 13 RRIV Rivera Rubin 11/1/1991 3 $8,000 yes 14 DSMI 2 $9,000 yes Smith Donald 10/25/1996 Sharet Bells 15 RALV 7/8/1996 1 $10,000 no 55 $55,000 16 Totals Sub AFD() i = 10 k = 5 If Cells(i, k).Value = 5 Then Cells(i, k). Font.Color = vbRed Else_ Cells(i + 1, k + 1).Font.Color = vbGreen End Sub Salary $7,000 is in green font Salary $7,000 is in red font O Vacation Days 5 is in green font Vacation Days 5 is in red font O None of the above are correct 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. A B C D E F G EmployeelD Last First Name Name Date Hired Vacation Days Salary Flex Time 1 2 JTAN Tanner Joyce 9/24/1997 10 $1,000 yes 3 KANT Anthony Ken 5/15/1995 9 $2,000 yes 4 KCLI Clifton Katherine 6/8/1996 8 $3,000 yes 5 6 7 JPAO Paolucci Jennifer 7/7/1994 7 $4,000 no 8 WCHA Chan Wei 3/23/1995 6 $5,000 no 9 10 RALV Alverez Rosa 8/28/1996 5 $6,000 no 11 CKNI Knight Carolyn 4/15/1994 4 $7,000 yes 12 13 RRIV 11/1/1991 3 $8,000 yes 14 DSMI Rivera Rubin Smith Donald Sharet Bells 2 $9,000 yes 10/25/1996 7/8/1996 15 RALV 1 $10,000 no 55 $55,000 16 Totals Sub AFD() i = 5 k=6 If Cells(i, k).Value = "" Then Cells(i + 1, k).Value = 50000 Else_ Cells(i+1, k).Value = 60000 End Sub Row 6 Salary is $50,000 O Row 7 Salary is $60,000 O Row 6 Salary is $60,000 O None of the above are correct 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. A B C D E F G Last First EmployeelD Date Hired Vacation Days Salary Flex Time 1 Name Name 2 JTAN Tanner Joyce 9/24/1997 10 $1,000 yes 3 KANT Anthony Ken 5/15/1995 9 $2,000 yes 4 KCLI Clifton Katherine 6/8/1996 8 $3,000 yes Paolucci Jennifer 7/7/1994 7 $4,000 no 7 JPAO 8 WCHA Chan Wei 3/23/1995 6 $5,000 no 9 10 RALV Alverez Rosa 8/28/1996 5 $6,000 no 11 CKNI Knight Carolyn 4/15/1994 4 $7,000 yes 12 13 RRIV Rubin 11/1/1991 3 $8,000 yes Rivera Smith Donald 14 DSMI 2 $9,000 yes 10/25/1996 7/8/1996 15 RALV Sharet Bells 1 $10,000 no 16 Totals 55 $55,000 Sub AFD() a=0 lastrow = Cells(Rows.Count, 1).End(xlUp).Row For i = 15 To lastrow step 2 a = a + Cells(i, 6).Value Next 456 Cells(lastrow Cells(lastrow End Sub + 2, 1).Value = "The SUM of AFD is" + 2, 6).Value = a $65,000 $10,000 $55,000 0 The program is incorrect - will not run