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 O Salary $7,000 is in green font O Salary $7.000 is in red font O Vacation Days 5 is in green font O Vacation Days 5 is in red font O None of the above are correct
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 O Salary $7,000 is in green font O Salary $7.000 is in red font O Vacation Days 5 is in green font O Vacation Days 5 is in red font O None of the above are correct
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question

Transcribed Image Text:Sub AFD()
i- 10
k-5
If Cells(i, k).Value 5 Then Cells(i, k).Font.Color = vbRed Else
%3D
Cells(i+ 1, k + 1).Font.Color = vbGreen
End Sub
O Salary $7.000 is in green font
O Salary $7.000 is in red font
O Vacation Days 5 is in green font
O Vacation Days 5 is in red font
O None of the above are correct

Transcribed Image Text:Current Attempt in Progress
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
D.
Last
EmployeelD
First
Date Hired Vacation Days Salary
Flex Time
Name
Name
9/24/1997
5/15/1995
6/8/1996
10 $1,000 yes
9 $2,000 yes
8 $3,000 yes
2 JTAN
Tanner Joyce
3 KANT
Anthony Ken
4 KCLI
Clifton
Katherine
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
8/28/1996
4/15/1994
5 $6,000 no
4 $7,000 yes
Alverez Rosa
11 CKNI
Knight Carolyn
12
3 $8,000 yes
$9,000 yes
1 $10,000 no
13 RRIV
Rivera
Rubin
11/1/1991
10/25/1996
7/8/1996
14 DSMI
Smith
Donald
15 RALV
Sharet
Bells
16 Totals
55 S55,000
Sub AFD()
i-10
k = 5
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY