Pakati pa masamu ambiri opangidwa ndi Microsoft Excel, ndithudi, palinso kuwonjezereka. Koma, mwatsoka, si ogwiritsa ntchito onse angathe kugwiritsa ntchito bwino mwayi umenewu. Tiyeni tione momwe tingachitire njira yowonjezera mu Microsoft Excel.
Mfundo zowonjezera mu Excel
Monga ntchito ina iliyonse ya masamu ku Excel, kuchulukitsa kumachitika pogwiritsa ntchito machitidwe apadera. Zowonjezera zidalembedwa polemba chizindikiro - "*".
Kuwonjezeka kwa nambala wamba
Microsoft Excel ikhoza kugwiritsidwa ntchito ngati calculator ndikungowonjezera manambala osiyanasiyana mmenemo.
Pofuna kuchulukitsa nambala imodzi ndi imzake, timalowa mu selo iliyonse pa pepala, kapena mu ndondomeko, chizindikiro chiri (=). Kenaka, tchulani chinthu choyamba (chiwerengero). Kenako, timayika chizindikiro kuti chiwonjezere (*). Kenaka, lembani chinthu chachiwiri (chiwerengero). Kotero, kachitidwe kowonjezera kambiri kudzawoneka monga: "= (nambala) * (nambala)".
Chitsanzo chikuwonetsa kuchulukitsa kwa 564 ndi 25. Zochitazo zalembedwa ndi njira yotsatirayi: "=564*25".
Kuti muwone zotsatira za mawerengero, muyenera kusindikiza fungulo ENTER.
Paziwerengero, mukuyenera kukumbukira kuti chofunika kwambiri pa ntchito za masamu ku Excel, ndi chimodzimodzi ndi masamu ambiri. Koma, chizindikiro chochulukitsa chiyenera kuwonjezeka mulimonsemo. Ngati, polemba mapepala, amaloledwa kuchotsa chizindikiro chochulukitsa pamaso pa makolo, ndiye ku Excel, kuti awerengere bwino, amafunika. Mwachitsanzo, mawu 45 + 12 (2 + 4), mu Excel, muyenera kulemba motere: "=45+12*(2+4)".
Kuwonjezeka kwa selo ndi selo
Ndondomeko ya kuchulukitsa selo ndi selo imachepetsa chirichonse mofanana ndi njira yochulukitsa nambala mwa nambala. Choyamba, muyenera kusankha kuti selo zotsatira zake zidzawonetsedwa. M'menemo timayika chizindikiro chofanana (=). Kenaka, dinani pang'onopang'ono pa maselo omwe mkati mwake ayenera kuwonjezeka. Mukasankha selo iliyonse, yesani chizindikiro chochulukitsa (*).
Lembani ndimeyo pamtundu
Pofuna kuchulukitsa chingwe ndi ndondomeko, nthawi yomweyo muyenera kuchulukitsa maselo apamwamba a zipilala izi, monga momwe zasonyezera mu chitsanzo chapamwamba. Kenaka, timakhala kumbali ya kumanzere ya selo yodzazidwa. Chizindikiro chodzaza chikuwonekera. Kokani pansi ndi batani lamanzere laching'ono. Choncho, njira yowonjezera imakopedwa kwa maselo onse omwe ali m'mbali.
Pambuyo pake, zipilala zidzachulukitsidwa.
Mofananamo, mukhoza kuchulukitsa zigawo zitatu kapena zingapo.
Kuwonjezeka kwa magulu ndi nambala
Pofuna kuchulukitsa selo ndi nambala, monga mwa zitsanzo zomwe tatchula pamwambapa, choyamba, yesani chizindikiro (=) mu selo kumene mukufuna kukwaniritsa yankho la masamu. Pambuyo pake, muyenera kulemba chiwerengero cha anthu ochulukitsa chiwerengero, yesani chizindikiro chochulukitsa (*), ndipo dinani selo limene mukufuna kuzichulukitsa.
Kuti muwonetse zotsatirapo pawindo, dinani pa batani. ENTER.
Komabe, mukhoza kuchita zosiyana: patangotha chizindikiro chofanana, dinani selo limene liyenera kuwonjezeka, ndiyeno, pambuyo pa chizindikiro chowonjezera, lembani nambala. Inde, monga momwe zikudziwika, mankhwalawo sasintha kuchokera pa kukonzanso zinthu.
Mofananamo, n'zotheka, ngati n'koyenera, kuchulukitsa maselo angapo ndi nambala zingapo nthawi imodzi.
Kuchulukitsa chigawo ndi nambala
Pofuna kuchulukitsa chigawo ndi nambala inayake, muyenera kuwonjezereka selo ndi nambalayi, monga tafotokozera pamwambapa. Kenaka, pogwiritsira ntchito chikhomo chodzaza, lembani mawonekedwe m'maselo apansi, ndipo pangani zotsatira.
Lembani ndime ndi selo
Ngati pali nambala mu selo ina yomwe ndimeyo iyenera kuchulukitsidwa, mwachitsanzo, pali coefficient inayake pamenepo, ndiye njira yomwe ili pamwambayi isagwire ntchito. Izi ndi chifukwa chakuti pamene mukujambula, zosiyana zonsezi zidzasintha, ndipo tikusowa chinthu chimodzi chokhazikika.
Choyamba, yochulukitseni mwa njira yoyamba selo yoyamba ya chigawocho ndi selo yomwe ili ndi coefficient. Kuwonjezera apo, mu ndondomeko ife timayika chizindikiro cha dola kutsogolo kwa makonzedwe a chigawocho ndi mzere wa selo lofotokozera ndi coefficient. Mwanjira iyi, ife tinasinthira malembawo mwachidule, ma coordinates omwe sangasinthe pamene mukujambula.
Tsopano, imakhalabe mwachizoloŵezi, pogwiritsa ntchito chikhomo chodzaza, kutengera mawonekedwewo ku maselo ena. Monga mukuonera, zotsatira zomalizirazo zikuwonekera.
PHUNZIRO: Tingapange bwanji mgwirizano
KULAMBIRA ntchito
Kuwonjezera pa njira yowonjezera yowonjezera, mu Excel pali kuthekera kuti zolingazi zigwiritse ntchito ntchito yapadera KUPANGA. Mukhoza kuyitchula mofanana ndi ntchito ina iliyonse.
- Pogwiritsira ntchito Function Wizard, yomwe ingayambike mwa kuwonekera pa batani "Ikani ntchito".
- Kupyolera mu tabu "Maonekedwe". Pamene muli mmenemo, muyenera kutsegula pa batani. "Masamu"yomwe ili pa tepiyi mu zida za zipangizo "Laibulale ya Ntchito". Kenako, m'ndandanda imene ikuwonekera, sankhani ANAPEREKEDWA.
- Lembani dzina la ntchito KUPANGA, ndi zifukwa zake, pamanja, chizindikirocho chikufanana (=) mu selo lofunidwa, kapena mu bar.
Ndiye, muyenera kupeza ntchitoyi KUPANGA, mutseguka wotsogolera zenera, ndipo dinani "Chabwino".
Kachitidwe cha template cholowera cholembedwa ndi ichi: "= KUKHALA (nambala (kapena selo); nambala (kapena selo lofotokozera); ...)". Izi zikutanthauza kuti ngati tikuyenera kuchulukitsa 77 ndi 55, ndikuchulukitsa ndi 23, ndiye kuti tikulemba fomu yotsatirayi: "= KUKHALA KWAMBIRI (77; 55; 23)". Kuti muwonetse zotsatira, dinani pa batani. ENTER.
Mukamagwiritsa ntchito njira ziwiri zoyambirira kugwiritsa ntchito ntchitoyi (pogwiritsira ntchito Function Wizard kapena tab "Maonekedwe"), zenera zatsegula, zomwe muyenera kulowetsamo mndandanda wa ziwerengero, kapena maadiresi a selo. Izi zikhoza kuchitika mophweka pokhapokha pamakhungu omwe mukufuna. Mutatha kukambirana, dinani pakani "Chabwino", kupanga mawerengero, ndi kusonyeza zotsatira pawindo.
Monga mukuonera, mu Excel pali zifukwa zambiri zomwe mungachite kuti mugwiritse ntchito masabata monga kuchulukitsa. Chinthu chachikulu ndicho kudziwa mndandanda wa kugwiritsa ntchito maulendo ochulukitsa.
