Chimodzi mwa zikuluzikulu za Microsoft Excel ndi kuthekera kugwira ntchito ndi ma fomu. Izi zimapangitsa kuti pakhale ndondomeko yowerengera ma totali, ndikuwonetsa deta yomwe mukufuna. Chida ichi ndi gawo lapadera la kugwiritsa ntchito. Tiyeni tione mmene tingapangire mawonekedwe mu Microsoft Excel, ndi momwe tingagwirire nawo.
Kupanga mawonekedwe osavuta
Mayendedwe ophweka mu Microsoft Excel ndiwo mafotokozedwe opangira masamu pakati pa deta yomwe ili mu maselo. Kuti tipeze njira yofananamo, choyamba, timayika chizindikiro chofanana mu selo yomwe ikuyenera kutulutsa zotsatira zomwe zimapezeka kuchokera ku masamu. Kapena mungathe kuima mu selo, ndikuyika chizindikiro chofanana mu bar. Zochita izi ndizofanana ndipo zimangopeka mobwerezabwereza.
Kenaka sankhani selo yodzaza ndi deta, ndipo yesani chizindikiro cha masamu ("+", "-", "*", "/", etc.). Zizindikiro izi zimatchedwa operekera njira. Sankhani selo yotsatira. Kotero ife timabwereza mpaka maselo onse omwe tikuwafuna sakuphatikizidwa. Pambuyo pake mawuwo alowetsani, kuti muwone zotsatira za mawerengero, pindani batani lolowani mukibokosi.
Zitsanzo Zowerengetsera
Tiyerekeze kuti tiri ndi tebulo momwe kuchuluka kwa chinthucho chikuwonetsedwa, ndi mtengo wake. Tiyenera kudziwa mtengo wa chinthu chilichonse. Izi zikhoza kuchitika powonjezera kuchuluka kwa mtengo wa katundu. Timakhala chithunzithunzi mu selo momwe ndalamazo ziyenera kuwonetsedwa, ndipo ikani chizindikiro chofanana (=) pamenepo. Kenaka, sankhani selo ndi kuchuluka kwa katundu. Monga mukuonera, kulumikizana kwa izo nthawi yomweyo kumawonekera chizindikiro chofanana. Ndiye, mutatha makonzedwe a selo, muyenera kuyika chizindikiro cha masamu. Pankhaniyi, idzakhala chizindikiro chochulukitsa (*). Kenaka, dinani selo kumene deta ikuyikidwa ndi mtengo umodzi. Masamu a masamu ndi okonzeka.
Kuti muwone zotsatira zake, ingolani pakani Enter mu keyboard.
Kuti musalowe muyeso iyi nthawi iliyonse kuti muwerenge mtengo wake wa chinthu chilichonse, ingolumikizani chithunzithunzi pansi pa ngodya ya kumanja kwa selo ndi zotsatira, ndipo yesani pansi pa dera lonse limene dzina lachinsinsi likupezeka.
Monga momwe mukuonera, ndondomekoyi inakopedwa, ndipo ndalama zonsezo zinkawerengedwa pa mtundu uliwonse wa mankhwala, malinga ndi deta yomwe ili ndi kuchuluka kwake.
Mofananamo, n'zotheka kuwerengera machitidwe osiyanasiyana, ndi zizindikiro zosiyanasiyana za masamu. Ndipotu, Excel malemba amalembedwa molingana ndi mfundo zomwezo monga zitsanzo zamakono zamasamu. Pa nthawi yomweyi, pafupifupi mawu ofananawo amagwiritsidwa ntchito.
Tiyeni tipambane ntchitoyo pogawaniza kuchuluka kwa katundu mu tebulo mu magulu awiri. Tsopano, kuti tipeze mtengo wathunthu, ife choyamba tikuyenera kuwonjezera kuchuluka kwa zogulitsa zonsezo, ndiyeno tiwonjezere zotsatirapo ndi mtengo. Mu masamu, zochita zoterezi zidzachitidwa pogwiritsa ntchito maubwenzi, mwinamwake choyamba chidzachitidwa kuchulukitsa, zomwe zidzatsogolera kuwerengera kosayenera. Timagwiritsa ntchito makina, ndi kuthetsa vutoli mu Excel.
Kotero, ife timayika chizindikiro chofanana (=) mu selo yoyamba ya column "Sum". Kenaka mutsegule kabati, dinani pa selo yoyamba muzitsulo "1 batch", ikani chizindikiro chophatikiza (+), dinani pa selo yoyamba muzitsulo "2". Kenaka, tseka besiti, ndipo yikani chizindikiro chochulukitsa (*). Dinani pa selo yoyamba mu "Mtengo". Kotero ife tinali ndi dongosolo.
Dinani pa batani lolowera kuti mupeze zotsatira.
Mofananamo nthawi yotsiriza, pogwiritsira ntchito njira yokokera, timatsanzira njira iyi kwa mizere ina ya tebulo.
Zindikirani kuti sizimenezi ziyenera kukhala pafupi ndi maselo omwe ali pafupi, kapena mkati mwa tebulo lomwelo. Iwo akhoza kukhala mu tebulo lina, kapena ngakhale pa pepala lina la chikalata. Pulogalamuyo ikadali yoyenera kuwerengera zotsatira.
Calculator
Ngakhale, ntchito yaikulu ya Microsoft Excel ndiyo kuwerengera m'matawuni, koma ntchitoyo ingagwiritsidwe ntchito, komanso ngati chowerengera chophweka. Mwachidule, ife timayika chizindikiro chofanana, ndipo timalowa zofunikira mu selo iliyonse pa pepala, kapena tikhoza kulemba zomwe timachita mu bar.
Kuti mupeze zotsatira, dinani pa Enter.
Mafotokozedwe ofunika a Excel
Omwe amagwiritsa ntchito mawerengedwe omwe amagwiritsidwa ntchito mu Microsoft Excel ndi awa:
- = ("chizindikiro chofanana") - ofanana;
- + ("kuphatikiza") - kuwonjezera;
- - ("kuchotsa") - kuchotsa;
- ("asterisk") - kuchulukitsa;
- / ("kupha") - kugawa;
- ^ ("circumflex") - kufotokozera.
Monga mukuonera, Microsoft Excel imapereka chida chokwanira kwa wogwiritsa ntchito masabata osiyanasiyana. Zochita izi zikhoza kuchitidwa pazokonzekera matebulo ndi padera kuti awerengere zotsatira za ntchito zina za masamu.
