microsoft excel assessment
TRANSCRIPT
-
7/25/2019 Microsoft Excel Assessment
1/6
EMPLOYEE NAME POSITIONNo. Of
Working Days
1 Anderson, Donald D. Manager 13
2 Yu, Mark Andrew R. Supervsor 12
3 Mendo!a, "o#n Les$er %. Supervsor 13
& orres, "ake M(#eal . Supervsor 11
) Pere!, Mark Andrew *. ea+ Leader 13
Pa-arllaga, Pre(e P. ea+ Leader 13
Mensalvas, "eleen P. ea+ Leader 13
/ Mon$e(laro, M(#eal ". ea+ Leader 13
0 Mon$e+aor, "oan L. ea+ Leader 12
1 o+e!, R(o ". 4orker 13
11 Evans, Ma$$eo R. 4orker 13
12 Avla, R$aln S. 4orker 1
13 5on(epon, ar *. 4orker 0
1& %laro, 6#ong L. 4orker 12
1) Pun!alan, Prn(epe O. 4orker 11
1 Odane, Rand *. 4orker 13
1 7un$o, Marlon ". 4orker 13
1/ *al+, "oan 8. 4orker 13
10 Olano, Mark l S. 4orker 1
2 av(a, S$ep#en 9. 4orker /
En$er E+ploee :a+e;
Pos$on;
:e$ pa;
9ns$ru($ons;
2. :e$ Per Da Per Pos$on
a. Manager < /.
=. Supervsor < .(. ea+ Leader < ).
d. 4orker < ).
Dedu($ons;
SSS < ).
3. 9n(o+e $a> would =e as ?ollows;
Salar a>
1. The BONUSIs "0" if the maximum sales is not reached. If reached, T
-
7/25/2019 Microsoft Excel Assessment
2/6
@2&00
2)@&000 2) )
)@&00 )
)@1
A=ove 1 /
&. 5olor 5odng Bor E+ploees; a. Manager
=. Supervsor
(. ea+ Leader
d. 4orker
). 5olor 5odng Per Rows
a. E+ploee :a+e and :u+=er o? Das
=. Regular Pa and Salar Per da
(. Dedu($ons
d. 5as# Loan and Conus e. :e$ Pa
. Corders
a. Ou$sde Corder
=. 9nsde Corders
. 5rea$e a pe (#ar$ on S#ee$ 2 usng $#ese De$als $le; EMPLOYEE P9E 5%AR
De$als;
Manager; 1
Supervsors; 3
ea+ Leaders; )
4orkers; 11
/. :a+e #e S#ee$ 1 as E+ploee's Paroll and S#ee$ 2 Pe 5#ar$
0. o #ave a CO:8S, e+ploee +us$ #ave a sales o? a$ leas$ +u+ sales rea(#ed use (ond$onal ?or+a$$ng Clue ?or Yes,
-
7/25/2019 Microsoft Excel Assessment
3/6
EMPLOYEE'S PAYROLL
Salary Per Day Regular PayDeducions
!as" LoanSSS Inco#e Ta$
)
)
)
) &
) )
) 3
) 12
)
)
)
)
) )
) /
) 1
) 12
)
)
) )
) )
) 1)
he BONUSwould be 10%of the regular pay.
-
7/25/2019 Microsoft Excel Assessment
4/6
Bon$ 5olor; 4#$e
Bon$ 5olor; 4#$e
Bon$ 5olor; 4#$e
Bon$ 5olor; 4#$e
s$ =e (olored
Red ?or :o
-
7/25/2019 Microsoft Excel Assessment
5/6
Sales for T"e Ma$i#u# Sales%ON&S Ne Pay
Mon" Reac"ed '
/)
3)
)
)
&)
3)
)
2)
)
1)
1
1
1)
&
)1
)).)
&0000.)
)
-
7/25/2019 Microsoft Excel Assessment
6/6