Ikesi ku-Microsoft Office Excel ubude bezinhlamvu, indawo yazo kumaseli ohlu lwethebula. I-Excel ayinikezi umsebenzi okhethekile wokushintsha isimo sezinhlamvu. Nokho, ingashintshwa kusetshenziswa amafomula. Indlela yokwenza lokhu ngokushesha kuzoxoxwa ngayo kulesi sihloko.
Ungalishintsha kanjani icala ku-Excel
Kunezinketho eziningi zokushintsha irejista, ngayinye yazo efanele ukucatshangelwa kabanzi. Okulandelayo, sizocubungula zonke izindlela ezikuvumela ukuthi uguqule isimo sezinhlamvu.
Indlela 1. Ulubhala kanjani ngosonhlamvukazi uhlamvu lokuqala egameni
Kuyinto evamile ukuqala imisho kumaseli etafula ngohlamvu olukhulu. Lokhu kuthuthukisa ubuhle kanye nokubonakala kwe-array. Ukuze uguqule icala lohlamvu lokuqala egameni, ulenze libe ngosonhlamvukazi, udinga ukulandela i-algorithm elandelayo:
- Ngenkinobho yegundane engakwesokunxele, khetha ububanzi bamaseli noma ingxenye ehlukile yohlu lwethebula.
- Emugqeni wokufaka otholakala phezulu kwemenyu enkulu ye-Excel ngaphansi kwekholomu yamathuluzi, noma kunoma iyiphi ingxenye yethebula, faka ngokwakho ifomula usuka kukhibhodi ye-PC. «=PROPRANACH()». Kobakaki, umsebenzisi kufanele acacise ukuphikisana okufanele. Lawa amagama amaseli ofuna ukushintsha kuwo uhlamvu lokuqala lwegama.
- Ngemva kokubhala ifomula, cindezela okuthi “Enter” ukuze uqinisekise isenzo.
- Hlola umphumela. Manje wonke amagama engxenyeni ekhethiwe noma uhla lwamaseli kufanele aqale ngofeleba.
- Uma kunesidingo, ifomula ebhaliwe inganwetshwa kuze kube sekugcineni kohlu lwethebula ukuze kugcwaliswe amaseli asele.
Nakani! Indlela ecatshangelwayo yokushintsha irejista ayisizi uma amagama amaningana ebhalwa kuseli eyodwa ngesikhathi esisodwa. Bese ifomula izobhala igama ngalinye ngosonhlamvukazi.
Ifomula «=PROPLANCH()» kubaluleke kakhulu ukusebenzisa uma umsebenzisi esebenza ngamagama afanele, okumele aqale ngosonhlamvukazi.
Indlela 2. Uzenza kanjani zonke izinhlamvu kwezinhlamvu ezincane zeseli
Le ndlela iphinde isetshenziswe ngokusebenzisa ifomula efanele. Ukuze ushintshe ngokushesha ikesi libe yizinhlamvu ezincane, udinga ukwenza lokhu kukhohlisa okulandelayo ngokuya nge-algorithm:
- Beka ikhesa yegundane kuseli, ezobonisa umphumela wefomula.
- Engxenyeni ekhethiwe yohlu lwethebula, bhala ifomula “=AMAPHANSI()”. Kubakaki, ngendlela efanayo, kufanele ucacise i-agumenti ngokuchofoza i-LMB engxenyeni oyifunayo yeseli yasekuqaleni lapho icala lingashintshiwe.
- Cindezela okuthi “Enter” kusukela kukhibhodi ukuze uqedele ifomula.
- Hlola umphumela. Uma zonke izenzo zenziwe ngendlela efanele, igama elifanayo noma uchungechunge lwezinhlamvu ezinezinhlamvu ezincane zizobhalwa kuseli elikhethiwe.
- Yelula umphumela ekupheleni kohlu lwethebula ukuze ugcwalise izakhi ezisele. Lesi sici sivumela umsebenzisi ukuthi angafaki ifomula yeseli ethile isikhathi ngasinye.
Kubalulekile! Ngeshwa, inguqulo evamile ye-Excel ayinayo inketho ekhethekile enesibopho sokushintsha icala, njengaku-Microsoft Office Word, ngoba. I-Excel yakhelwe ukusebenza ngamatafula, hhayi umbhalo.
Indlela yesi-3. Ubhalwa kanjani ngosonhlamvukazi bonke egameni
Kwesinye isikhathi, lapho kwakhiwa ithebula ku-MS Excel, umsebenzisi udinga ukuthi uhlamvu ngalunye lweseli lubhalwe ngosonhlamvukazi. Lokhu kuyadingeka ukuze kuqokonyiswe izingcezu ezibalulekile zohlu lwetafula, ukugxilisa ukunaka.
Ukuze ubhekane nomsebenzi ngesikhathi esifushane ngangokunokwenzeka, udinga ukusebenzisa imiyalelo elula yesinyathelo ngesinyathelo:
- Khetha iseli lapho umphumela woshintsho lwekesi uzoboniswa khona ngokubeka ikhesa yegundane kuyo.
- Faka ifomula ethi “=" kukhibhodi yekhompyuthaUMTHETHO()». Kubakaki, ngokufanisa nezikimu ezingenhla, udinga ukucacisa impikiswano - iseli lomthombo lapho ufuna ukushintsha khona icala.
- Qedela ukubhala ifomula ngokucindezela inkinobho ethi "Enter".
- Qiniseka ukuthi zonke izinhlamvu kuseli zibhalwe ngosonhlamvukazi.
Indlela 4. Ukushintsha isimo sezinhlamvu ngazinye egameni
Ku-Microsoft Office Excel, ungakwazi futhi ukushintsha usayizi wohlamvu olulodwa noma ngaphezulu egameni. Isibonelo, ngokuwenza abe ngosonhlamvukazi, futhi abashiye abanye abancane. Ukuze wenze le nqubo, awudingi ukusebenzisa ifomula, vele ulandele izinyathelo ezimbalwa ezilula:
- Khetha noma iyiphi iseli yohlu lwethebula ngokuchofoza kuyo ngenkinobho yegundane engakwesokunxele.
- Emgqeni wokufaka amafomula phezulu kumenyu enkulu yohlelo, okuqukethwe kwesici esikhethiwe kuzovezwa. Kulula kakhulu ukwenza izilungiso zedatha kulo mugqa.
- Beka ikhesa yegundane eduze kwanoma yiluphi uhlamvu oluncane egameni bese ulususa ngokucindezela inkinobho ethi “Backspace” kukhibhodi yekhompyutha.
- Bhala uhlamvu olufanayo ngesandla, kodwa kuphela ngokulwenza lube ngosonhlamvukazi. Ukuze wenze lokhu, kuzodingeka ubambe noma yimaphi okhiye "Shift" bese uchofoza uhlamvu olufunayo.
- Hlola umphumela. Uma konke kuhamba kahle, icala lencwadi lizoshintsha.
- Yenza okufanayo kubo bonke abanye abalingiswa egameni.
Ulwazi Olwengeziwe! Ungakwazi futhi ukushintsha ikesi lazo zonke izinhlamvu egameni ngokuzenzela kusuka kukhibhodi. Nokho, lokhu kuzothatha isikhathi eside kunokusebenzisa ifomula ethile.
Isiphetho
Ngakho-ke, ungashintsha isimo sezinhlamvu ku-Microsoft Office Excel ngokusebenzisa amafomula afanele, noma ngokwenza ngokushintsha usayizi wezinhlamvu kukhibhodi ye-PC. Zombili izindlela kuxoxwe ngazo ngokuningiliziwe ngenhla.