1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 B D Question 3-Categorize the user based on given conditions using the excel function: (a)- If vouchers are more than 10 then Bonus else Slacker (b)- If vouchers are more than equal to 10 and Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker) (c)- If vouchers are more than equal to 10 or Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker) A Business Unit # of Vouchers 5 13 8 33 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 14 25 5 2 15 12 7 11 1 2 27 15 Days Between Vchr Entry and Payment 2 5 5 4 3 2 3 3 4 3 3 3 3 1 4 1 User Jim Ignatowski John Locke Kim Bauer Liz Lemon Lorelai Gilmore Lynette Scavo Maddie Hayes Matt Saracen Monica Bing Natalie Teeger Niles Crane E Norm Peterson Phil Dunphy Phillip J. Fry Red Forman Robert Barone F Q.3(a) Bonus / Slacker Q.3(b) Bonus / Slacker G Q.3(c) Bonus / Slacker H

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...
icon
Related questions
Question

Please solve all three parts using Excel 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
B
D
Question 3-Categorize the user based on given conditions using the excel function:
(a)- If vouchers are more than 10 then Bonus else Slacker
A
Business Unit # of Vouchers
5
13
8
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
OSCM1
33
14
25
(b)- If vouchers are more than equal to 10 and Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker)
(c)- If vouchers are more than equal to 10 or Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker)
5
2
15
12
7
C
11
1
2
27
15
Days Between
Vchr Entry and
Payment
2
5
5
4
3
2
3
3
4
3
3
3
3
1
4
1
User
Jim Ignatowski
John Locke
Kim Bauer
Liz Lemon
Lorelai Gilmore
Lynette Scavo
Maddie Hayes
Matt Saracen
Monica Bing
Natalie Teeger
Niles Crane
E
Norm Peterson
Phil Dunphy
Phillip J. Fry
Red Forman
Robert Barone
F
Q.3(a)
Bonus /
Slacker
G
Q.3(b)
Bonus /
Slacker
Q.3(c)
Bonus /
Slacker
H
I
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 B D Question 3-Categorize the user based on given conditions using the excel function: (a)- If vouchers are more than 10 then Bonus else Slacker A Business Unit # of Vouchers 5 13 8 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 33 14 25 (b)- If vouchers are more than equal to 10 and Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker) (c)- If vouchers are more than equal to 10 or Days Between Vchr Entry and Payment less than equal to 3 then Bonus else Slacker) 5 2 15 12 7 C 11 1 2 27 15 Days Between Vchr Entry and Payment 2 5 5 4 3 2 3 3 4 3 3 3 3 1 4 1 User Jim Ignatowski John Locke Kim Bauer Liz Lemon Lorelai Gilmore Lynette Scavo Maddie Hayes Matt Saracen Monica Bing Natalie Teeger Niles Crane E Norm Peterson Phil Dunphy Phillip J. Fry Red Forman Robert Barone F Q.3(a) Bonus / Slacker G Q.3(b) Bonus / Slacker Q.3(c) Bonus / Slacker H I
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY