Kusanthula deta ndikusonkhanitsa, kuitanitsa, kuphatikiza ndi kusanthula chidziwitso ndi kuthekera kuti mudziwe zochitika ndi zowonongeka za zochitika zomwe zikuchitika. Mu Excel, muli zida zambiri zothandizira kufufuza m'dera lino. Mapulogalamu atsopano a pulojekitiyi sali otsika poyerekeza ndi mapulogalamu apadera omwe ali ndi mphamvu. Zida zikuluzikulu zowerengera ndi kusanthula zimagwira ntchito. Tiyeni tione zomwe zimachitika pakugwira nawo ntchito komanso kugwiritsira ntchito zipangizo zothandiza kwambiri.
Zomwe zimagwira ntchito
Monga ntchito zina zilizonse mu Excel, ntchito zowonjezera zimagwiritsidwa ntchito pazokangana zomwe zingakhale ngati mawerengero nthawi zonse, zokhudzana ndi maselo kapena magulu.
Mawu akhoza kulowa mwachindunji mu selo yeniyeni kapena mu bar bar, ngati inu mumadziwa mgwirizano wa chinthu chimodzi. Koma ndizosavuta kugwiritsa ntchito mawindo apadera a ndewu, omwe ali ndi malemba ndi minda yopangira deta. Pitani pawindo lazitsutso la mawu owerengetsera angathe kupyolera "Mbuye Wa Ntchito" kapena kugwiritsa ntchito mabatani "Makalata Opangira Ntchito" pa tepi.
Pali njira zitatu zothetsera ntchito wizara:
- Dinani pazithunzi "Ikani ntchito" kumanzere kwa bar.
- Kukhala mu tab "Maonekedwe", dinani paboni pa batani "Ikani ntchito" mu chigawo cha zipangizo "Laibulale ya Ntchito".
- Sakani njira yomasulira Shift + F3.
Mukamagwiritsa ntchito zomwe mwasankhazi, zenera lidzatsegulidwa. "Ambuye A Ntchito".
Ndiye mukuyenera kutsegula kumunda "Gulu" ndi kusankha mtengo "Zotsatira".
Pambuyo pake mndandanda wa mafotokozedwe owerengetsera adzatsegulidwa. Zonse zilipo zoposa zana. Kuti mupite kuwindo lamatsutso la aliyense wa iwo, muyenera kungoisankha ndi dinani pa batani "Chabwino".
Kuti tipite ku zinthu zomwe tikufunikira timadutsa mu kabati, tulukani ku tabu "Maonekedwe". Mu gulu la zipangizo pa tepi "Laibulale ya Ntchito" dinani pa batani "Ntchito Zina". M'ndandanda yomwe imatsegulira, sankhani gulu "Zotsatira". Mndandanda wa zida zomwe zilipo zowunikira. Kuti mupite kuwindo lamatsutso, dinani pa chimodzi cha izo.
Phunziro: Wowonjezera Wogwira Ntchito
MAX
Ogwira ntchito MAX adapangidwa kuti adziwe kuchuluka kwa chiwerengero cha zitsanzo. Lili ndi mawu ofanana awa:
= MAX (nambala 1; nambala 2; ...)
M'madera a zokambirana zomwe muyenera kulowa mndandanda wa maselo omwe mndandanda wa nambala ulipo. Chiwerengero chachikulu kwambiri, chiwerengerochi chikuwonetsera mu selo yomwe ili yokha.
MIN
Pogwiritsa ntchito ntchito ya MIN, zikuwonekeratu kuti ntchito zake zikutsutsana ndi ndondomeko yapitayi - imayang'ana kakang'ono kwambiri kuchokera pa chiwerengero cha mayina ndikuyiwonetsera mu selo yapatsidwa. Lili ndi mawu ofanana awa:
= MIN (nambala1; nambala2; ...)
MALANGIZO
Ntchito YAPAVERAGE ikufufuza chiwerengero chomwe chili pafupi kwambiri ndi masamu. Zotsatira za kuwerengera uku zikuwonetsedwa mu selo losiyana lomwe mayendedwe alimo. Chithunzi chake chili motere:
= GAWO (nambala1; nambala2; ...)
MALANGIZO
Ntchito YOPHUNZITSA ili ndi ntchito zomwezo monga zapitazo, koma mmenemo muli mwayi wakukhazikitsa zina. Mwachitsanzo, zambiri, zochepa, osati zofanana ndi nambala inayake. Imaikidwa m'munda wosiyana pazokangana. Kuonjezerapo, njira yowonjezereka ikhoza kuwonjezeredwa ngati mkangano wosankha. Mawu omasulira ndi awa:
= GAWO (nambala1; nambala2; ...; chikhalidwe; [zowerengera]
MODA.ODN
Fomu ya MOD.AODN imaonetsa selo chiwerengerocho kuchokera kuyika yomwe imapezeka nthawi zambiri. M'mbuyo yakale ya Excel, pamakhala ntchito ya MODA, koma m'mawu omaliza adagawanika kukhala awiri: MODA.ODN (kwa manambala aumwini) ndi MODANASK (kwa zilembo). Komabe, mawonekedwe akalewo adatsalirabe mu gulu losiyana, momwe zigawo zomwe zamasulidwa kale zimasonkhanitsidwa kuti zitsimikizire zikalata.
= MODA.ODN (nambala1; nambala2; ...)
= MODAHNA (nambala1; nambala2; ...)
MEDIANA
Wogwiritsira ntchito MEDIANA amadziŵitsa kuchuluka kwa chiwerengero cha manambala. Izi zikutanthauza kuti sizingakhazikitse chiwerengero cha masamu, komabe chiwerengero cha mtengo wapatali pakati pa zazikulu ndi zochepa kwambiri. Chidule chake ndi:
= Wochuluka (nambala1; nambala2; ...)
STANDOWCLONE
Fomu ya STANDOCLON komanso MODA ndizolemba za mapulogalamu akale. Tsopano magwero ake amakono amagwiritsidwa ntchito - STANDOCLON.V ndi STANDOCLON.G. Yoyamba mwa iwo inalinganizidwa kuti muwerenge kuperewera kwayeso kwa zitsanzo, ndipo yachiwiri - anthu ambiri. Ntchito izi zimagwiritsidwanso ntchito kuwerengera zolepheretsa. Msonkhano wawo uli motere:
= STDEV.V (nambala1; nambala2; ...)
= STDEV.G (nambala1; nambala2; ...)
Phunziro: Excel Standard Deviation Formula
WAMPHAMVU
Wogwiritsira ntchitoyi amasonyeza selo yosankhidwa nambalayo mukutsika. Izi zikutanthauza kuti ngati tili ndi chiwerengero cha 12.97.89.65, ndipo timafotokozera 3 ngati ndondomeko ya udindo, ndiye kuti ntchitoyo mu selo idzabwerenso chiwerengero chachikulu chachitatu. Pankhaniyi, ndi 65. Mawu akuti syntax ndi awa:
= Wamkulu (gulu; k)
Pankhaniyi, k ndi mtengo wa ordinal wambiri.
KALE
Ntchitoyi ndi chithunzi chagalasi cha mawu apitalo. Momwemonso mfundo yachiwiri ndi nambala ya ordinal. Pano pokhapokha pakadali pano, dongosololi likuonedwa ngati laling'ono. Chidule chake ndi:
= KUTSATIRA (gulu; k)
RANG.SR
Ntchitoyi ili ndi zosiyana ndi zomwe zachitika kale. Mu selo losankhidwa, limapereka chiwerengero cha nambala yeniyeni muzitsanzo molingana ndi chikhalidwe, chomwe chimatchulidwa mu ndemanga yosiyana. Izi zikhoza kukhala zikukwera kapena zitsika. Yotsirizirayi imakhala yosasintha ngati munda uli "Dongosolo" chokani chopanda kanthu kapena kuyikapo nambala 0. Chigwirizano cha mawu awa ndi awa:
= RANK.SR (nambala; gulu; dongosolo)
Pamwamba, zokhazokha zomwe zimatchuka komanso zofunikidwa ku Excel zakhala zikufotokozedwa. Ndipotu, nthawi zambiri zimakhala zambiri. Komabe, mfundo yayikulu ya zochita zawo ndi yofanana: kukonza deta komanso kubwezeretsa zotsatira za zochita zamakono ku selo lomwe limanenedweratu.
