Mwa zinthu zambiri zoyeserera zomwe Microsoft Excel imatha kuchita, mwachilengedwe, pamakhala kuchulukitsa. Koma, mwatsoka, si onse ogwiritsa ntchito omwe angathe kugwiritsa ntchito mwanzeru ntchitoyi. Tiyeni tiwone momwe mungapangire njira zochulukitsira mu Microsoft Excel.
Mfundo Zochulukitsa ku Excel
Monga ntchito yamagulu ena aliwonse ku Excel, kuchulukitsa kumachitika pogwiritsa ntchito njira zapadera. Zochita kuchulukitsa zalembedwa pogwiritsa ntchito chikwangwani cha "*".
Kuchulukitsa kwa manambala wamba
Mutha kugwiritsa ntchito Microsoft Excel ngati Calculator, ndi kungochulukitsa manambala osiyanasiyana mmenemo.
Pochulukitsa nambala imodzi ndi inzake, timalemba m'chipinda chilichonse pa pepalalo, kapena mzere wama formula, chikwangwani ndi (=). Kenako, sonyezani chinthu choyamba (nambala). Kenako, ikani chisonyezo kuti uchulukitse (*). Kenako lembani chinthu chachiwiri (nambala). Chifukwa chake, mawonekedwe ochulukitsa amawoneka motere: "= (nambala) * (nambala)".
Chitsanzochi chikuwonetsa kuchulukitsidwa kwa 564 ndi 25. Nkhaniyo idalembedwa ndi njira zotsatirazi: "=564*25".
Kuti muwone zotsatira za kuwerengera, dinani fungulo ENG.
Mukamawerengera, muyenera kukumbukira kuti cholinga choyambirira cha masamu mu Excel ndi chofanana ndi masamu wamba. Koma, zilembo zochulukitsa ziyenera kuwonjezeredwa mulimonse. Ngati polemba mawu papepala amaloledwa kusiyitsa chizindikiro chochulukitsa pamaso pa mabatani, ndiye kuti ku Excel, kuti muwerenge moyenera, ndikofunikira. Mwachitsanzo, mawu a 45 + 12 (2 + 4), mu Excel muyenera kulemba motere: "=45+12*(2+4)".
Kuchulukitsa maselo ambiri
Njira yokuchulukitsa khungu ndi khungu imachepetsa zonse kukhala zofanana ndi njira yokuchulukitsira nambala ndi nambala. Choyamba, muyenera kusankha kuti kodi zotsatirazo zikuwonetsedwa bwanji. Timayika chizindikiro chofanana (=) mmenemo. Kenako, dinani maselo omwe maselo ake amafunikira kuchulukitsidwa. Mukasankha khungu lililonse, ikani chizindikiro chodzichulukitsira (*).
Kholamu kuzidinda
Kuti muchulukitse mzere ndi wolemba, muyenera kuchulukitsa maselo apamwamba kwambiri pazakholilo, monga tikuonera pamwambapa. Kenako, tidayimirira pakona kumunsi kwa chipinda chodzaza. Chizindikiro Kokani pansi ndikusunga batani lakumanzere. Chifukwa chake, formula yochulukitsa imakopera maselo onse omwe ali mgululi.
Pambuyo pake, mzati udzachulukitsidwa.
Mofananamo, mutha kuchulukitsa mizati itatu kapena kupitirira.
Kuchulukitsa khungu ndi chiwerengero
Pochulukitsa khungu ndi nambala, monga momwe tafotokozera pamwambapa, choyambirira, ikani chizindikiro (=) chomwe chimakhala mu foni yomwe mukufuna kuwonetsa yankho la masamu. Kenako, muyenera kulemba nambala yamanambala, kuyika chikwangwani chokuzungulirani (*), ndikudina foni yomwe mukufuna kuchulukitsa.
Kuti muwonetse zotsatira pazenera, dinani batani ENG.
Komabe, mutha kuchita zinthu mwanjira ina: mukangofanana chikwangwani chofanana, dinani kuti foni ichuluke, kenako, ndikatha kuchuluka kwa kuchuluka, lembani manambala. Kupatula apo, monga mukudziwa, chinthucho sichisintha kuchoka pakubwezeretsa pazinthuzo.
Munjira yomweyo, mutha, ngati nkofunikira, kuchulukitsa maselo angapo ndi manambala angapo nthawi imodzi.
Chulukitsani mzere ndi nambala
Kuti muchulukitse mzere ndi nambala inayake, muyenera kuchulukitsa foniyo ndi nambala iyi, monga tafotokozera pamwambapa. Kenako, pogwiritsa ntchito chikhomo chodzaza, koperani chilinganizo kuma cell apansi, ndipo zotsatira zake.
Chulukitsani mzere wokhala ndi foni
Ngati pali nambala mu foni inayake yomwe muyezo uyenera kuchulukitsidwa, mwachitsanzo, pali cholowa china, ndiye kuti pamwambapa singagwire ntchito. Izi ndichifukwa choti mukamakopera zinthu zonse ziwiri zidzasunthika, ndipo tikufunika kuti chimodzi mwazinthuzi chizikhala chokhazikika.
Choyamba, timachulukana monga momwe selo loyamba la cholembera limakhala ndi cholembera. Chotsatira, mu fomula, timayika chikwangwani cha dollar patsogolo pa maulalo a mzere ndi cholumikizira mzere ku foni ndi cholowa. Mwanjira imeneyi, tinasinthanitsa cholumikizacho kukhala chamtheradi, zogwirizanitsa ndi zomwe sizingasinthe mukamakopera.
Tsopano, imakhalabe njira yokhayo, pogwiritsa ntchito chodzaza, ndikani chilinganizo pamaselo ena. Monga mukuwonera, zotsatira zomalizidwa zimapezeka nthawi yomweyo.
Phunziro: Momwe mungapangire kulumikizana kwathunthu
Ntchito ya PRODUCT
Kuphatikiza pa njira yachilendo kuchulukitsa, mu Excel pali zotheka kuti izi zitheke kugwiritsa ntchito ntchito yapadera CHENJEZO. Mutha kuyitanitsa zonse m'njira zofanana ndi ntchito ina iliyonse.
- Kugwiritsa ntchito Wizard Yogwira Ntchito, yomwe ikhoza kukhazikitsidwa podina batani "Ikani ntchito".
- Kudzera pa tabu Mawonekedwe. Pokhala mu icho, muyenera dinani batani "Masamu"ili pa riboni m'bokosi la chida Laibulale ya Feature. Kenako, mndandanda womwe umawonekera, sankhani "PRODUCTION".
- Lembani dzina la ntchito CHENJEZO, ndi mfundo zake, pamanja, pambuyo pa chizindikiro chofanana (=) mu foni yomwe mukufuna, kapena baramu yamuyeso.
Kenako, muyenera kupeza ntchitoyo CHENJEZO, pawindo lotseguka la wizard wogwira ntchito, ndikudina "Zabwino".
Ma template a ntchito yolowa ndi awa ndi awa: "= PRODUCTION (nambala (kapena cholembera foni); nambala (kapena cholembera maselo); ...)". Ndiye kuti, mwachitsanzo ngati tikufunika kuchulukitsa 77 ndi 55, ndi kuchulukitsa ndi 23, ndiye kuti talemba izi: "= PRODUCT (77; 55; 23)". Kuti muwonetse zotsatira, dinani batani ENG.
Mukamagwiritsa ntchito njira ziwiri zoyambirira zogwiritsira ntchito ntchito (pogwiritsa ntchito Wizard Yogwira ntchito kapena tabu Mawonekedwe), zenera la zokambirana limatsegulidwa, momwe muyenera kulowetsamo zotsutsana mu manambala, kapena ma adilesi a foni. Izi zitha kuchitika mwa kungodina ma cell omwe mukufuna. Mukamaliza kukangana, dinani batani "Zabwino", kuwerengera, ndikuwonetsa zotsatira zake pazenera.
Monga mukuwonera, ku Excel pali mitundu ingapo ya zosankha zogwiritsa ntchito masamu ngati kuchulukitsa. Chachikulu ndikudziwa malingaliro amomwe mungagwiritsire ntchito njira zochulukitsira pagawo lililonse.
