Chimodzi mwazinthu zazikulu za Microsoft Excel ndikutha kugwira ntchito ndi formula. Izi zimathandizira kwambiri ndikufulumiza njira yowerengera zotsatira zonse, ndikuwonetsa zomwe mukufuna. Chida ichi ndi mtundu wa ntchito. Tiyeni tiwone momwe mungapangire njira mu Microsoft Excel, ndi momwe mungagwirire nawo.
Pangani njira zosavuta
Mitundu yosavuta kwambiri mu Microsoft Excel ndi mawu ochitira masamu pakati pa deta yomwe ili m'maselo. Pofuna kupanga kakhazikidwe koteroko, choyambirira, timayika chizindikiro chofanana mu cell momwe zotsatira zomwe zimapezeka mu opaleshoni yoyeserera zikuyenera kuwonetsedwa. Kapenanso mutha kuyimirira pafoni ndikuyika chikwangwani chofananira ndi mzere wama formula. Zochita izi ndizofanana, ndipo zimangochitika zokha.
Kenako timasankha khungu lina lodzaza ndi deta ndikuyika chikwangwani cha masamu ("+", "-", "*", "/", ndi zina). Zizindikiro izi zimatchedwa ogwiritsa ntchito formula. Sankhani foni yotsatira. Chifukwa chake bwerezani mpaka ma cell onse omwe timafunikira akukhudzidwa. Pambuyo poti mawuwo alowa mokwanira, kuti muwone zotsatira za kuwerengera, dinani batani Lowani pa kiyibodi.
Zitsanzo zowerengera
Tiyerekeze kuti tili ndi tebulo momwe kuchuluka kwa katundu kukufotokozedwera, komanso mtengo wake. Tiyenera kudziwa kufunika kwa chinthu chilichonse. Izi zitha kuchitidwa ndikuchulukitsa kuchuluka kwake ndi mtengo wa katunduyo. Timakhala chotembezera muchipinda chomwe chiwonetserochi chikuyenera kuwonetsedwa, ndikuyika chizindikiro chofanana (=) pamenepo. Kenako, sankhani khungu ndi kuchuluka kwa katundu. Monga mukuwonera, ulalo kwa iwo umawonekera pambuyo pa chizindikiro chofanana. Kenako, pambuyo pazolumikizana za selo, muyenera kuyika chizindikiro cha masamu. Mwanjira imeneyi, chizikhala chizindikiro chochulukitsa (*). Chotsatira, timadula pafoni momwe zosungidwa ndi mtengo wa unityo zimayikidwa. Makina owerengera akonzeka.
Kuti muwone zotsatira zake, ingodinani batani Lowani pa kiyibodi.
Pofuna kuti musalowe mu fom iyi nthawi iliyonse kuti muwerengere mtengo wonse wa chinthu chilichonse, ingochotsani chikombole kumunsi kwakumanja kwa chipangizocho ndi zotsatira zake, ndikuzikokera kudera lonse la mizere momwe dzina lalembedwera limapangidwira.
Monga mukuwonera, fomuloli idakopedwa, ndipo mtengo wake udali kuwerengeredwa pachokha mtundu uliwonse wa malonda, molingana ndi kuchuluka kwake komanso mtengo wake.
Mwanjira yomweyo, munthu amatha kuwerengera njira zingapo, komanso ndi mitundu yosiyanasiyana ya masamu. M'malo mwake, mitundu ya Excel imapangidwa molingana ndi mfundo zomwezo zomwe zitsanzo wamba za masamu zimachitika mu masamu. Poterepa, pafupifupi syntax yomweyi imagwiritsidwa ntchito.
Timasokoneza ntchitoyi pogawa kuchuluka kwa katundu patebulolo kukhala matomu awiri. Tsopano, kuti tidziwe mtengo wonse, choyamba tiyenera kuwonjezera kuchuluka kwa zonsezo, kenako kuchulukitsa zotsalazo ndi mtengo. Mu masamu, machitidwe oterewa amachitika pogwiritsa ntchito mabakki, apo ayi kuchulukitsa kudzachitidwa ngati chinthu choyamba, chomwe chitsogolera kuwerengera kolakwika. Timagwiritsa ntchito mabatani, ndikuti tithetse vutoli ku Excel.
Chifukwa chake, ikani chizindikiro chofanana (=) mu cholembera choyamba cha "Sum". Kenako timatsegula bulaketi, ndikudina foni yoyamba mzere wa "1 batch", ndikuyika chikwangwani chowonjezera (+), ndikudina foni yoyamba "2 batch". Kenako, tsekani bulaketi, ndikuyika chikwangwani kuti ichulukitse (*). Dinani pa foni yoyamba mu "Price". Chifukwa chake tili ndi kachitidwe.
Dinani pa Dinani batani kuti muwone zotsatira.
Momwemonso nthawi yomaliza, pogwiritsa ntchito njira yokokera ndikutsitsa, ikani njira iyi pamizere ina ya tebulo.
Dziwani kuti sizofunikira kuti mitundu yonseyi ikhale mu maselo oyandikana, kapena pagome lomweli. Amatha kukhala pagome lina, kapenanso papepala lina. Pulogalamuyo idawerengera zotsatirazo molondola.
Calculator
Ngakhale, ntchito yayikulu ya Microsoft Excel ndi kuwerengera m'matafura, koma pulogalamuyo imagwiritsidwa ntchito ngati Calculator yosavuta. Ingoikani chikwangwani chofanana ndikulowetsa zomwe mukufunazo mu cell iliyonse ya pepalalo, kapena zochitikazo zitha kulembedwa mu barula yokhazikika.
Kuti mumve zotsatira, dinani batani la Enter.
Mfundo Zachidule za Excel
Owerengera omwe amagwiritsidwa ntchito ku Microsoft Excel akuphatikiza izi:
- = ("chizindikiro chofanana") - chofanana ndi;
- + ("kuphatikiza") - kuwonjezera;
- - ("minus") - zochotsa;
- ("asterisk") - kuchulukitsa;
- / ("slash") - magawano;
- ^ ("circumflex") - kutanthauzira.
Monga mukuwonera, Microsoft Excel imapereka chida chokwanira kuti wosuta azichita ntchito zosiyanasiyana za masamu. Zochita izi zitha kuchitika pokhapokha polemba matebulo, komanso pang'onopang'ono kuwerengera zotsatira za masamu.
