Pali milandu pamene mukufuna kudziwa zotsatira za kuwerengera ntchito kunja kwa malo odziwika. Magaziniyi ndi yofunika kwambiri pazomwe zikuchitika. Ku Eksele pali njira zingapo zomwe zingathandize kuti apatsidwe ntchito. Tiyeni tiyang'ane pa iwo ndi zitsanzo zenizeni.
Gwiritsani ntchito zowonjezereka
Mosiyana ndi kutanthauzira mawu, ntchito yomwe ingapeze kufunika kwa ntchito pakati pa zifukwa ziwiri zomwe zimadziwika, kufotokozera kumaphatikizapo kupeza njira yothetsera kunja kwa malo odziwika. Ndichifukwa chake njira iyi ndi yotchuka kwambiri poyerekeza.
Mu Excel, kufufuza kwina kungagwiritsidwe ntchito pa ma tebulo ndi ma grafu onse.
Njira 1: kufufuza zowonjezera deta
Choyamba, timagwiritsa ntchito njira yowonjezeretsa ku zomwe zili mu tebulo. Mwachitsanzo, tenga tebulo ndi zifukwa zingapo. (X) kuchokera 5 mpaka 50 ndi mndandanda wa machitidwe ogwirizana (f (x)). Tiyenera kupeza phindu la ntchitoyi pazokangana 55zomwe zili pamtundu wambiri wa deta. Pachifukwa chimenechi, timagwiritsa ntchito ntchitoyi ZAMBIRI.
- Sankhani selo zomwe zotsatira za zomwe anaziwerengetsera zidzawonetsedwa. Dinani pazithunzi "Ikani ntchito"yomwe ili pa bar bar.
- Foda ikuyamba Oyang'anira ntchito. Sinthani kusintha "Zotsatira" kapena "Mndandanda wathunthu wa alfabeti". M'ndandanda yomwe imatsegula, timayesetsa kupeza dzina. "ZAMBIRI". Kupeza izo, sankhani, kenako dinani pa batani. "Chabwino" pansi pazenera.
- Timasuntha kuwindo latsutsano la ntchito yomwe ili pamwambapa. Lili ndi zifukwa zitatu zokha komanso masamba omwe akuwunikira.
Kumunda "X" ayenera kusonyeza kufunika kwa mkangano, ntchito yomwe tiyenera kuwerengera. Mukhoza kungoyendetsa nambala yofunikila kuchokera ku kibokosiko, kapena mungathe kufotokozera zogwirizanitsa za selo ngati ndemanga yalembedwa pa pepala. Njira yachiwiri ndi yabwino kwambiri. Ngati tipanga njirayi, kuti tiwone kufunika kwa ntchitoyi pamtsutso wina, sitidzasintha ndondomekoyi, koma zidzakwanira kusintha kusintha kwa selo lofanana. Pofuna kufotokoza makonzedwe a selo ili, ngati njira yachiwiri idasankhidwa, ndikwanira kuyika cholozera pamtundu womwewo ndikusankha selo ili. Adilesi yake imapezeka nthawi yomweyo muzenera zotsutsana.
Kumunda "Zomwe Amadziwika Y" ziyenera kusonyeza ntchito yonse zomwe timachita. Imawonetsedwera m'ndandanda "f (x)". Choncho, ikani cholozera pamtundu womwewo ndikusankha lonselo popanda dzina lake.
Kumunda "Zodziwika x" ziyenera kusonyeza malingaliro onse a kutsutsana, zomwe zimagwirizana ndi ziyeso za ntchito yomwe yatchulidwa ndi ife. Deta iyi ili m'mbali "x". Mofananamo, monga nthawi yoyamba, timasankha chigawo chimene tikusowa poyambira choyamba pazenera pazenera.
Deta yonse italowa, dinani pa batani "Chabwino".
- Pambuyo pa zochitikazi, zotsatira za chiwerengerocho ndi kuwonetseratu zowonjezera zidzawonetsedwa mu selo yomwe yasankhidwa mu ndime yoyamba ya malangizowa musanayambe Oyang'anira ntchito. Pankhaniyi, phindu la ntchito ya mkangano 55 zofanana 338.
- Ngati, komabe, chisankhocho chinasankhidwa ndi kuwonjezera kwa kutchulidwa kwa selo yomwe ili ndi mtsutso wofunikira, ndiye tikhoza kusintha mosavuta ndi kuwona mtengo wa ntchito kwa nambala ina iliyonse. Mwachitsanzo, mtengo wofunikira pa mkangano 85 adzakhala ofanana 518.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 2: kuwunikira kwa graph
Mukhoza kupanga ndondomeko yowonjezereka kwa graph mwa kumanga mzere wotsatira.
- Choyamba, timapanga ndandanda yokha. Kuti muchite izi, gwiritsani ntchito chithunzithunzi pamene mukukhala ndi batani lamanzere kuti muzisankha malo onse a tebulo, kuphatikizapo zifukwa komanso zoyenera. Ndiye, ndikusamukira ku tabu "Ikani", dinani pa batani "Ndondomeko". Chizindikiro ichi chili muzithunzi. "Zolemba" pa chida cha tepi. Mndandanda wa zosankha zachitsulo zomwe zilipo zikuwonekera. Timasankha bwino kwambiri pazochita zathu.
- Gululo litakonzedweratu, chotsani mzere wowonjezera wotsutsana kuchokera pamenepo, kuusankha ndi kupanikiza batani. Chotsani pamakina a makompyuta.
- Kenaka, tifunika kusintha magawo osakanikirana, chifukwa sichisonyeza mfundo zazitsulo, monga momwe tikufunira. Kuti muchite izi, dinani pomwepa pa chithunzichi ndi mndandanda womwe umaoneka kuti taima pa mtengo "Sankhani deta".
- Poyang'ana pazenera posankha deta yanu, dinani pa batani "Sinthani" mu chigawo chokonzekera siginecha chazitali zosakanikirana.
- Wowonjezerapo mawindo oyika mawindo amawonekera. Ikani chotsekera m'munda wawindo ili, ndipo sankhani deta yonse ya data "X" popanda dzina lake. Kenaka dinani pa batani "Chabwino".
- Titabwerera ku zenera zosankha zosankha, timabwereza zomwezo, ndiko kuti, dinani pa batani "Chabwino".
- Tsopano ndondomeko yathu imakonzedwa ndipo inu mukhoza, mwachindunji, mumayamba kupanga mzere wazomwe. Dinani pa tchati, kenaka zinaibulo za ma tebulo zamasulidwa pa ndodo - "Kugwira Ntchito ndi Mphatso". Pitani ku tabu "Kuyika" ndipo dinani pa batani "Mzere wazotsatira" mu block "Kusanthula". Dinani pa chinthu "Kuwerengera kwachilendo" kapena "Zonenedwa Zophatikiza".
- Mzerewu wawonjezeredwa, koma uli pansipa mzere wa graph womwewo, popeza sitinasonyeze kufunika kwa mkangano umene uyenera kuyesetsa. Kuchita izi kachiwiri dinani pa batani "Mzere wazotsatira"koma tsopano sankhani chinthu "Zapamwamba Zamakono Zam'ndandanda".
- Mawindo a mawonekedwe a mzere akuyamba. M'chigawochi "Mndandanda wa Zolemba Zamtundu" pali chigawo cha machitidwe "Chiwonetsero". Mofanana ndi njira yapitayi, tiyeni titenge mkangano woonjezera 55. Monga mukuonera, pakuti graph tsopano ili ndi kutalika mpaka kutsutsana 50 kuphatikizapo. Kotero, tifunikira kuwonjezera 5 mayunitsi. Pazigawo zosakanikirana zingathe kuwona kuti mayunitsi asanu ali ofanana ndi magawo amodzi. Kotero iyi ndi nthawi imodzi. Kumunda "Pitirirani pa" lowetsani mtengo "1". Timakanikiza batani "Yandikirani" kumbali ya kumanja yazenera yawindo.
- Monga momwe mukuonera, grafu inapitilira kutalika kwachindunji pogwiritsira ntchito mzere wa mzere.
Phunziro: Momwe mungamangire ndondomeko yowonjezera mu Excel
Choncho, talingalira zitsanzo zosavuta zowonjezeredwa pa matebulo ndi ma grafu. Poyamba, ntchitoyi imagwiritsidwa ntchito ZAMBIRI, ndipo chachiwiri - mzere wa mzere. Koma pamaziko a zitsanzo izi, ndizotheka kuthana ndi mavuto ambiri owonetsetsa.
