Computer, Software
Ukubalwa umdla: usebenzisa Excel
Masithi kufuneka liqwalasele ukuba ukwandisa ifakwe kwibhanki iminyaka emihlanu, ukubala irhafu kwintengiso yempahla, okanye ukufumanisa ukuba kungakanani lubekelwe mboleko ukuthatha. Kuyo nayiphi na yezi meko kuya kufuneka ukujongana ngomdla. Calculator - into elungileyo, kodwa awukwazi ukunika ukubonakala kwaye ekube- iziphumo xa utshintsha idatha engumthombo kanye nje ngokulula ukwenza Excel. Ukongeza, ezi ubalo angasoloko izakugcinwa ifayile (kucacile ukuba ikhaltyhuleyitha ukuba lo msebenzi).
Ukubalwa le njengepesenti yenani lilonke jikelele
Ngokomzekelo, xa ngokuphumelela ilotto karhulumente ngo-5000 engange kuyimfuneko ukuba ahlawule-15% yerhafu yengeniso. Kuya kufuneka njani imali eninzi ukuze ahlawule urhulumente?
A | the | C | D | |
1 | imali iphumelele | Ixabiso irhafu ngokwe ngeshumi | ifomula | incazelo |
2 | 5000 | 0,15 | = A2 * B2 | Inani 5000 yande nje 0,15, yaye Icacili phandle ukuba imali yerhafu ekufuneka ihlawulwe (750). |
Ukubalwa ekhulwini, kunye elaziwayo ekupheleni iyonke
Umzekelo, xa iklasi ukufunda abafundi-29, kubo abantu 16 - amakhwenkwe, ngoko yintoni yipesenteji amakhwenkwe?
A | the | C | D | |
1 | inani elivisayo lamakhwenkwe | Inani lilonke labafundi | Ukubalwa ekhulwini, ifomula | incazelo |
2 | 16 | 29 | = A2 / B2 | Umlinganiselo ka-16 ukuya kwi-29 kuvumela ukuba ukufumana phandle i ipesenti amakhwenkwe (malunga 0,5517, okanye 55,17%). |
Ukubala itotali grand yi ixabiso ipesenti
Umzekelo, iijini ivenkile kuxabisa 2390 engange. Le veki isaphulelo se-23% emva-23 Februwari. uya kubiza malini iijini kwiveki ezayo?
A | the | C | D | |
1 | athengisa | 100% -23% (in ifomu ngeshumi) | ifomula | incazelo |
2 | 2390 | 0,77 | = A2 / B2 | 2390 umahlule ngo 0,77, ukuze ukwazi ixabiso lokuqala (3103.90 engange). |
Ukubalwa ekhulwini njengoko umahluko amanani amabini
Umzekelo, ukuba umvuzo ngoFebruwari yaba ku 24,780 engange, yaye ngoMatshi - 25 500 engange. Ipesenti kwisithuba ukwandisa imali? Ngeenjongo zokukhawulelana nale mfuno, ukongeza umzekelo yabaqhubi eziphambili sisahlula nokuthabatha isicelo AVS umsebenzi.
A | the | C | D | |
1 | Salary in February | Salary in March | Ukubalwa ekhulwini, ifomula | incazelo |
2 | 24780 | 25500 | = (B2-A2) / ABS (A2) | umahluko ngolwahlulo izakwenziwa ngosuku lokuqala kwimodyuli, kwaye ke ngoko kufuneka umsebenzi ABC. Isiphumo 0.02905 (okanye 2,91%). |
Qaphela. ABC umsebenzi isetyenziselwa ukufumanisa ubukhulu elililo lwenani. Ngamanye amazwi, ibuyisela lo mnqongo wokulinganisela, oko kukuthi ungatyikitywanga.
Ukunciphisa okanye ukwandisa inani inombolo ekhulwini elikhankanyiweyo
A | the | |
1 | inombolo | imali umdla |
2 | 97,96 | 1,521% |
3 | ifomula | incazelo |
4 | = A2 * (1-B2) | Inani 97,96 kuncitshiswa 1.521% (96,47). |
5 | = A2 * (1 + B2) | Inani elandileyo nge 1.521 97,96% (99.45). |
Umzekelo, izinga Sberbank izibambiso eziqhelekileyo sandisiwe nge 1.521% kule veki igqithileyo bafikelela engange 97,96 ngesabelo ngasinye. lalisithini ixabiso lokuqala izibambiso? Okanye, icala, kulindeleke ukuba izabelo Sberbank yokutyala iintsuku ezimbalwa (ubuncinane-2%). Azi uya kuba yintoni iindleko zabo zokugqibela? Kuba lula ngakumbi, ungakwazi ukukopisha imixholo ezi mpawu zilandelayo Excel yekhasi yakho entsha. Ukuba yonke ngesiquphe endaweni iziphumo a kuya kuba yimpazamo, zama ingena iikoma amanani ingongoma.
Njengokuba mhlawumbi ukuba bakwazi ukuqinisekisa ukubalwa umdla Excel - loo nto ilula kakhulu lula. Yiloo nto le nkqubo ukuze wayethanda ezimali, zasebhange, bezimali kunye nje bonke abo badla kufuneka ukusebenza ngamanani.
Similar articles
Trending Now