subject
Computers and Technology, 06.12.2021 07:40 wavy419

B AØI TAÄP EXCEL 8 BAÛNG PHAÂN BOÁ TIEÀN LÖÔNG, THÖÔÛNG THAÙNG…NAÊM 1997
Soá tieàn phaân boå trong thaùng : 7000000
STT "MAÕ
NV" HOÏ TEÂN "MAÕ
CHÖÙC
VUÏ" "LÖÔNG
CAÊN
BAÛN" "NGAØY
LAØM
VIEÄC" PCCV "HEÄ
SOÁ" "CHÖÙC
VUÏ" LÖÔNG THÖÔÛNG "TIEÀN
LÓNH"
1 A1 TRAÀN A GÑ 505000 27
2 A2 LEÂ VAÊN PGÑ 350000 25
3 B1 LYÙ BAÛO NV 360000 24
4 A2 CAO THANH TP 450000 23
5 B2 THAÛO THAÛO PP 500000 26
6 B1 TRAÀN B NV 360000 25
7 B3 NGUYEÃN C PGÑ 420000 24
8 A3 THAÙI THANH PP 460000 23
Toång
Bình quaân
Cao nhaát
Thaáp nhaát
Yeâu caàu :
1/ Phuï caáp chöùc vuï : BAÛNG 1
* GÑ : phuï caáp 55000 ñoàng "MAÕ
CHÖÙC VUÏ" CHÖÙC VUÏ
* PGÑ : phuï caáp 45000 ñoàng GÑ GIAÙM ÑOÁC
* TP : phuï caáp 30000 ñoàng PGÑ PHOÙ GIAÙM ÑOÁC
* PP : 25000 ñoàng TP TRÖÔÛNG PHOØNG
* NV : khoâng coù phuï caáp chöùc vuï. PP PHOÙ PHOØNG
2/ Heä soá: NV NHAÂN VIEÂN
Neáu kyù töï ñaàu cuûa MAÕ NV laø A thì HEÄ SOÁ laø 1.4
Neáu kyù töï ñaàu cuûa MAÕ NV laø B thì HEÄ SOÁ laø 1.6
3/ Chöùc vuï :
Döïa vaøo MAÕ CHÖÙC VUÏ vaø Baûng 1 ñeå ñieàn Chöùc vuï
4/ Löông (tính troøn khoâng laáy soá leû)
Löông = Löông caên baûn / 30 * Ngaøy laøm vieäc
Nhöng neáu ngaøy laøm vieäc lôùn hôn 24 ngaøy thì moãi ngaøy dö ñöôïc tính thaønh 2 ngaøy.
Ví duï : Neáu ngaøy laøm vieäc laø 26 thì ñöôïc tính thaønh 28 (=24+(26-24)*2)
5/ Thöôûng
Toång thöôûng = Soá tieàn phaân boå trong thaùng - Toång tieàn löông vaø toång PCCV
Thöôûng = Toång thöôûng chia cho toång heä soá thöôûng nhaân vôùi heä soá thöôûng töøng ngöôøi
6/ Tieàn lónh = PCCV + Löông + Thöôûng
7/ Tính toång, bình quaân, cao nhaát, thaáp nhaát cho caùc oâ coù daáu ? vaø ñònh daïng theo daïng #,##0 ñ cho coät Tieàn lónh.
8/ Töï trang trí baûng tính (tieâu ñeà, khung, maøu saéc...)

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 18:30, smariedegray
All of the following are characteristics that must be contained in any knowledge representation scheme except
Answers: 3
image
Computers and Technology, 24.06.2019 21:00, Winzen07
Which device has the most limited computing functionality?
Answers: 1
image
Computers and Technology, 25.06.2019 01:30, babyquinnz
Why is the most liked picture on instagram an eggy? owo
Answers: 1
image
Computers and Technology, 25.06.2019 12:10, uwrongboi
Create a function called quadform( ) that takes as input the coefficients of the quadratic equation (a, b,c) and returns the two distinct real roots (x1,x2) as output, if they exist. in addition, the function returns a message (flag) that informs the user if an error occurred when trying to find two distinct real roots. the possible errors are: (1) "only one root is found"; (2) "imaginary roots are found"; (3) "any value of x is a solution"; (4) "no zeroes exist." if no errors occur, then flag should be "no errors".
Answers: 1
You know the right answer?
B AØI TAÄP EXCEL 8 BAÛNG PHAÂN BOÁ TIEÀN LÖÔNG, THÖÔÛNG THAÙNG…NAÊM 1997
Soá tieàn phaân bo...

Questions in other subjects:

Konu
Mathematics, 09.11.2020 07:50
Konu
History, 09.11.2020 07:50