Pakati pa zochitika za Arithmetic zomwe zimatha kuchita Microsoft Excel, mwachilengedwe imapezekanso. Koma, mwatsoka, si onse ogwiritsa ntchito omwe angagwiritse ntchito kwathunthu ndi kugwiritsa ntchito bwino mwayiwu. Tiyeni tiwone momwe mungapangire kuchuluka kwa Microsoft Excel.
Mfundo Zochulukitsa
Monga mtundu wina uliwonse wogwiritsa ntchito pulogalamu ya Excel, Kuchulukitsa kumachitika pogwiritsa ntchito njira zapadera. Zochulukitsa zimalembedwa pogwiritsa ntchito chizindikiro - "*".Kuchulukitsa manambala wamba
Pulogalamu ya Microsoft Excel itha kugwiritsidwa ntchito ngati chowerengera, ndikungochulukitsa manambala osiyanasiyana.
Kuti muchulukitse nambala imodzi kupita ku khungu limodzi papepala, kapena mu chingwe, chizindikirocho ndi chofanana ndi (=). Kenako, fotokozerani chinthu choyamba (chiwerengero). Kenako, ikani chizindikirocho kuti chichulukitse (*). Kenako, lembani chinthu chachiwiri (chiwerengero). Chifukwa chake, zochulukitsa template ziwongoleredwa motere: "= (nambala) * (nambala)".
Chitsanzo chikuwonetsa kuchulukitsa kwa 564 mpaka 25. Chochitikachi chalembedwa ndi njira yotsatirayi: "= 564 * 25".
Kuti muwone zotsatira za kuwerengetsa, muyenera dinani batani la Enter.
Pa mawerengero, muyenera kukumbukira kuti cholinga cha aritithmet kuchita bwino kwambiri, chimodzimodzi monga pamiyambo yachilendo. Koma, kuchulukitsa chizindikiro kumayenera kuwonjezeredwa mulimonse. Ngati polemba mawu papepala amaloledwa kutsitsa chizindikiro chachulukitsa kutsogolo kwa mabatani, ndiye ku Excel, chifukwa chowerengera molondola, ndikofunikira. Mwachitsanzo, mawu 45 + 12 (2 + 4), kukuthandizani kuti mulembedwe motere: "= 45 + 12 * (2 + 4)".
Cell zochulukitsa
Kuchuluka kwa maselo pafoni pa cell kumachepetsedwa ndi mfundo yomweyo monga kuchuluka kwa nambala. Choyamba, muyenera kusankha kuti gawo lomwe zotsatira zake zidzawonetsedwa. M'malo mwake ikani chikwangwani chofanana ndi (=). Kenako, onetsani dinani pamaselo, zomwe muyenera kuchulukitsa. Pambuyo posankha khungu lirilonse, timakhazikitsa chizindikiro (*).
Kuchulukitsa kwa mzere pa mzere
Pofuna kuchulukitsa mzati pachingwe, nthawi yomweyo amafunika kuchulukitsa maselo apamwamba kwambiri a mizamu iyi, monga tikuonera pamwambapa. Kenako, timakhala pakona yakumanzere ya cell yodzala. Chizindikiro chodzaza chikuwonekera. Kuganiza kuti pansi ndi batani la mbewa yakumanzere yofinya. Chifukwa chake, kuphatikiza njira yochulukitsa imakopera maselo onse a mzati.
Pambuyo pake, mizata imachulukitsidwa.
Momwemonso, mutha kuchulukitsa maminiti atatu kapena kupitilira apo.
Kuchulukitsa kwa maselo ndi nambala
Pofuna kuchulukitsa foniyo, monga zitsanzo pamwambapa, zoyambirira, ikani chikwangwani chofanana ndi (=) mu cell yomwe mukufuna kuwonetsa yankho la zochita za Arithmetic. Kenako, muyenera kujambula kuchuluka kwa manambala, ikani chikwangwani (*), ndikudina pa cell yomwe mukufuna kuchulukitsa.
Pofuna kuti zitheke pazenera, dinani batani la Enter.
Komabe, mutha kuchita zinthu komanso mwadongosolo lina: Chizindikirocho chikakhala chofanana ndi dinani pa cell yomwe muyenera kuchulukitsa, kenako, pambuyo polemba nambala. Kupatula apo, monga mukudziwa, ntchitoyi sikusintha kuchokera ku kuwerengera kwa kuchulukitsa.
Momwemonso, mungathe, ngati kuli kotheka, chulani ma cell angapo ndi manambala angapo nthawi imodzi.
Kuchulukitsa kwa nambala
Pofuna kuchulukitsa mzati wina, muyenera kuchulukitsa ndi khungu, monga tafotokozera pamwambapa. Kenako, pogwiritsa ntchito cholembera chodzaza, koperani njira yam'madzi, ndipo timapeza zotsatira zake.
Kuchulukitsa kwa mzere pa cell
Ngati nambala ili mu cell ina kuti muchulukane ndi mzati, mwachitsanzo, pali chofunda china, njira yomwe ili pamwambapa siyabwino. Izi ndichifukwa choti kukopera kudzasunthidwa ndi mitundu yonse iwiri yonse, ndipo tikufuna imodzi mwazochulukitsa.
Choyamba, kuchulukitsa ndi njira yoyambirira khungu la mzati pa cell, lomwe lili ndi zogwirizana. Komanso, mu fomula, timayika chikwangwani kutsogolo kwa mgwirizano wa mzati ndi mizere yofotokoza za cell yomwe ili ndi zogwirizana. Mwanjira imeneyi, tatembenuza wachibale wake kuti muthetsa mtheradi, zogwirizanitsa zomwe sizisinthidwa mukakopera.
Tsopano, zimakhalabe mwachizolowezi, pogwiritsa ntchito cholembera chodzaza, koperani ma cell ena. Monga mukuwonera, zotsatira zake zopangidwa zokonzekera nthawi yomweyo zimawoneka.
Phunziro: Momwe Mungapangire Ulalo Wabwino
Kupanga ntchito
Kuphatikiza pa zochulukitsa mwachizolowezi, pali mwayi wogwiritsa ntchito ntchito yapadera pazolinga izi. Mutha kuwatcha njira zonse zomwezo ngati ntchito ina iliyonse.
- Kugwiritsa ntchito phompho la Wizard yomwe mutha kuthamanga podina batani "
- Kudzera mu formula tab. Pokhala mmenemo, muyenera dinani batani la "masamu", lomwe limapezeka pa tepi mu "Library of A State" la GrandBar. Kenako, mu mndandanda womwe umawonekera, sankhani "kupanga".
- Imbani dzina la ntchitoyo, ndi zotsutsana zake, pamanja, chizindikiritso ndichofanana ndi (=) mu khungu lomwe mukufuna, kapena mu chingwe.
Kenako, muyenera kupeza ntchito ya malonda, pazenera la Wizard Wizard lomwe limatseguka, ndikudina batani la "OK".
Ntchito ya template ya buku la Magazi ndi motere: "= kupanga (nambala (kapena ulalo); nambala (kapena ulalo). Izi zikutanthauza kuti, ngati tikufunika kuchulukitsa pofika 55, ndikuchulukitsa ndi 23, kenako lembani fomu iyi: "= zopangidwa (77; 23)". Kuwonetsa zotsatira, dinani batani la Lower.
Mukamagwiritsa ntchito njira ziwiri zoyambira ntchito (pogwiritsa ntchito formulas Wizard), zenera lotsutsa lidzatsegulidwa kuti mulowetse mikangano mu mtundu wa manambala, kapena ma adilesi. Izi zitha kuchitika pongodina pa maselo omwe mukufuna. Pambuyo polowa zotsutsana, kanikizani "OK" kuti mugwiritse ntchito zowerengera, ndipo zidatulutsa zotsatira zake pazenera.
Monga mukuwonera, mu pulogalamu ya Excel pali zingapo zomwe mungagwiritse ntchito pogwiritsa ntchito gawo lotereli ngati kuchuluka. Chinthu chachikulu ndikudziwa zochulukitsa zogwiritsira ntchito zochulukitsa m'njira zonse.