Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Employee B D E F G Last First Date Vacation Salary Flex 1 ID Name Name Hired Days 2 JTAN 3 DSMI Tanner Smith Joyce Donald 09/24/97 Time 10 $1,000 yes 10/25/96 2 $9,000 yes 4 RALV Alverez Rosa 08/28/96 5 $6,000 no RALV Sharet Bells 07/08/96 1 $10,000 no 10 11 KCU Clifton Katherine 12 KANT Anthony Ken 06/08/96 05/15/95 68 9 $3,000 $2,000 yes yes 13 56789232 2345678 15 WCHA 16 18 JPAO CKNI RRIV Chan Paolucci Jennifer Wei 03/23/95 07/07/94 Knight Carolyn 04/15/94 Rivera Rubin 11/01/91 Sub AFD() 6143 $5,000 no $4,000 no $7,000 yes $8,000 yes Sub AFD0 a=0 i-4 Do While i 19 a-a+Cells(i. 5).Value i-i+2 Loop End Sub 0.12 O 11 36 O 38 25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started