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...)

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 03:30, patience233

Many everyday occurrences can be represented as a binary bit. for example, a door is open or closed, the stove is on or off, and the fog is asleep or awake. could relationships be represented as a binary value? give example.

Answers: 1

continue

Computers and Technology, 23.06.2019 09:00, jeremytheprimerapper

Which best compares appointments and events in outlook 2010appointments have a subject man, and events do notappointments have a specific date or range of dates, and events do notappointments have a start and end time of day, and events do notappointments have a location option, and events do not

Answers: 2

continue

Computers and Technology, 23.06.2019 12:40, melaniem50

Curriculum exam to process a resident's payment, you must click on onesite payments home page. from the a. reports b. my settings o c. transactions o d. rent tab

Answers: 1

continue

Computers and Technology, 24.06.2019 12:00, elainnysanchez1541

How can we take picture in this app

Answers: 1

continue

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...