Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

What about leadership lessons from particularly good or bad bosses?

Answered: 1 week ago