Ungabala kanjani inani lamagama kuseli lespredishithi se-Excel

Ku-Microsoft Office Excel, ungabala inani lezinto ezibhalwe kumaseli wohlu lwethebula. Kulokhu, kujwayele ukusetshenziswa ifomula elula. Imininingwane enemininingwane ngalesi sihloko izokwethulwa kulesi sihloko.

Izindlela zokubala amagama kumaseli e-Excel

Kunezindlela eziningana ezivamile zokufeza umsebenzi othile, ngayinye edinga ukutadisha okujulile ukuze uqonde ngokugcwele. Okulandelayo, sizokhuluma ngokulula futhi okuphumelelayo kakhulu kubo.

Indlela 1: ukubala okwenziwa ngesandla

Le ndlela ayifanele neze i-MS Excel, kungakhathaliseki ukuthi inguqulo yayo, ngoba. lolu hlelo lusebenzisa amathuluzi okubala azenzakalelayo. Kodwa-ke, kuhle futhi ukucabangela i-akhawunti yezandla ngaphakathi kohlaka lwendatshana. Ukuze isetshenziswe kuyadingeka:

1. Dala uhlu lwangempela lwethebula.
2. Khetha ngokucindezela inkinobho yegundane kwesokunxele iseli ofuna ukubala kuyo amagama.
3. Bala izinto eziqoqiwe.
4. Ukuze ungalahlekelwa yisikhathi sakho, ungakopisha okuqukethwe kweseli, okukhonjiswa ngokuphelele emgqeni wokufaka amafomula, bese unamathisele endaweni yokusebenza yesayithi elikhethekile ukuze ubale ngokushesha inombolo yezinhlamvu, amagama.

Nakani! Ukubala amagama kumaseli e-Excel ngokwenza akusebenzi uma ithebula liqukethe ulwazi oluningi kakhulu.

Indlela 2: Ukusebenzisa i-Microsoft Office Word

Kumhleli wombhalo, wonke amagama athayiphiwe abalwa ngokuzenzakalelayo futhi inombolo yawo iboniswa esikrinini. Ukuze usebenzise le ndlela, umsebenzisi we-Excel uzodinga:

1. Gqamisa i-LMB yamagama kuseli yethebhulethi ukuze uqhubeke ubale inombolo yawo.
2. Shintshela ikhibhodi esakhiweni sesiNgisi futhi ngesikhathi esifanayo ubambe izinkinobho "Ctrl + C" ukuze ukopishele izinhlamvu ezikhethiwe ebhodini lokunamathisela.
3. Vula umhleli wombhalo we-MS Word.
4. Beka ikhesa yegundane ekuqaleni kwenkambu yokusebenza yohlelo bese ucindezela izinkinobho "Ctrl + V" kusuka kukhibhodi.
5. Hlola umphumela. Izakhi ezikopishiwe ezivela ku-Excel kufanele zinamathiselwe ku-Word ngaphandle kwezinkinga.
6. Naka ikhoneni elingezansi kwesokunxele lephepha lokusebenzela lohlelo. Ibha yomsebenzi izokhombisa inani lamagama athayiphiwe njengamanje.

Ulwazi Olwengeziwe! I-Excel ayinalo ithuluzi lokubala amagama kumaseli, ngoba le software ayiklanyelwe ukusebenza ngombhalo.

Indlela yesi-3: Ukusebenzisa Umsebenzi Okhethekile

Lena indlela efaneleke kakhulu futhi eshesha kakhulu yokubala amagama kumaseli, imisho ye-Excel. Ukuze uthole ngokushesha inani lezinto ezidingekayo, umsebenzisi uzodinga ukuthatha izinyathelo ezimbalwa ngokuya nge-algorithm:

1. Khetha noma iyiphi iseli engenalutho ekhasini lokusebenza lohlelo. Umphumela wezibalo uzoboniswa kuwo ngokuzayo.
2. Beka ikhesa yegundane emgqeni wokufaka amafomula phezulu kohlelo bese ubhala inkulumo elandelayo ukusuka kukhibhodi: “=UBUDE(AMA-TRIMSPACES(i-agumenti))-DLSTR(SUBSTITUTE(i-agumenti;» «;»»))+1".
3. Esikhundleni segama elithi "Ukungqubuzana", ikheli leseli lapho kubalwa khona liyaboniswa.

4. Ngemva kokubhala ifomula, kufanele ucindezele okuthi “Enter” ukuze uyiqinisekise.
5. Hlola umphumela. Iseli elikhethwe ngaphambilini lizoqukatha inombolo ehambisana nenani lamagama ento okukhulunywa ngayo.

Ungabala kanjani inani lezinhlamvu kuseli le-Excel

Kwesinye isikhathi abasebenzisi be-Excel badinga ukubala inani lezinhlamvu kuseli elithile lohlu lwethebula. Ukubala izimpawu kulula kunamagama. Kunezindlela eziningana zale njongo, okuzoxoxwa ngakho ngezansi.

Indlela 1: ukubala okwenziwa ngesandla

Le ndlela ifana nendlela yangaphambili okuxoxwe ngayo engxenyeni yokuqala yesihloko. Ukuze uyisebenzise, ​​umsebenzisi uzodinga ukukhetha iseli elithile lepuleti futhi abale uhlamvu ngalunye olukulo.

Kubalulekile! Kungaba nezinhlamvu eziningi kumaseli ethebula le-Microsoft Office Excel, okuzothatha isikhathi eside ukubala ngesandla. Ngakho-ke, ukubala ngesandla kubalulekile uma kuziwa epuletini elincane.

Indlela yesi-2: Ukusebenzisa Umsebenzi Ukubala Ubude Bentambo

I-Excel inefomula ekhethekile ekuvumela ukuthi ubale izakhi zilandelana. Ukuyisebenzisa, udinga ukwenza izinyathelo ezimbalwa ezilula ngokuya ngemiyalelo:

1. Ngokhiye ongakwesokunxele we-manipulator, khetha umugqa ongenalutho, iseli lapho umphumela wokubala izinhlamvu uzoboniswa khona.
2. Hambisa ikhesa yegundane emugqeni wokufaka amafomula phezulu kwewindi lohlelo bese ubhala inkulumo ethi: “=DLSTR(ingxabano)». Esikhundleni sengxabano, ikheli leseli ethile liyaboniswa, lapho udinga ukuthola inani lezinhlamvu.

3. Cindezela okuthi “Enter” uma ifomula ibhaliwe ukuze uqinisekise ukusetshenziswa kwayo.
4. Hlola umphumela. Isici esishiwo ngaphambilini sizobonisa inani lezinombolo elihambisanayo.

Indlela yesi-3: Ukusebenzisa amasayithi akhethekile ku-inthanethi

Ungahamba ngendlela eyinkimbinkimbi kakhulu yokubala inani lezinhlamvu kumaseli wohlu lwethebula le-Excel. Kubandakanya izenzo ezilandelayo ngokuya nge-algorithm:

1. Ngendlela efanayo, khetha iseli oyifunayo yohlu lwethebula nge-LMB bese uhambisa ikhesa yegundane emugqeni wokufaka amafomula phezulu kohlelo.
2. Manje, ngokhiye ofanayo we-manipulator, udinga ukukhetha okuqukethwe kweseli emugqeni wokufaka.
3. Chofoza kwesokudla kunoma iyiphi indawo yenkulumo ekhethiwe futhi efasiteleni lohlobo lomongo chofoza inketho ethi "Kopisha".
4. Ngena ngemvume kusiphequluli ku-PC bese uya kunoma iyiphi isayithi ukuze ubale inani lezinhlamvu.
5. Chofoza kwesokudla endaweni yokusebenza yesayithi bese ukhetha inketho ethi "Faka".
6. Zijwayeze nenani eliwumphumela. Ngemva kokwenza lokhu kukhohlisa okungenhla, isayithi izobonisa lonke ulwazi mayelana nobude bombhalo.

Nakani! Kumasayithi anjalo, ungabala ngisho nenani lemisho embhalweni oshiwo.

Isiphetho

Ngakho-ke, ku-Excel, ungathola ngokushesha ulwazi mayelana nenani lamagama kumaseli afunwayo ohlu lwetafula. Indlela yokwenza lokhu ichazwe ngokuningiliziwe ngenhla.