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

Another question on Computers and Technology

Computers and Technology, 22.06.2019 16:00

You have inserted new slides based on a word outline. how do you format these new slides to match the powerpoint presentation formatting? a. select all slides in the presentation and click format on the home tab. b. select the new slides and click reset on the home tab. c. select all slides in the presentation and click reset on the home tab. d. select the new slides and click format on the home tab.

Answers: 3

Answer

Computers and Technology, 22.06.2019 21:40

Develop a function to create a document in the mongodb database “city” in the collection “inspections.” be sure it can handle error conditions gracefully. a. input -> argument to function will be set of key/value pairs in the data type acceptable to the mongodb driver insert api call b. return -> true if successful insert else false (require a screenshot)

Answers: 2

Answer

Computers and Technology, 23.06.2019 10:00

Install and use wireshark program ( send back screen shots and other vital information) case project 3-2: decode a tcp segment in a wireshark capture in this chapter, you walked through tcp segment to interpret the data included in its header. in this project, you use wireshark to capture your own http messafes, examine the tcp headers, and practice interpreting the data you'll find there. 1. open wireshark and snap the window to one side of your screen. open a browser and snap that window to the other side of your screen so you can see both windows.

Answers: 2

Answer

Computers and Technology, 24.06.2019 11:00

Each row in a database is a set of unique information called a(n) ? a.) table. b.) record. c.) object. d.) field.

Answers: 2

Answer

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