Amaspredishithi okwamanje angenye yamathuluzi asetshenziswa kakhulu ekudaleni uhlu , ukuhlela izinto, kanye nokwenza izibalo . Ngaphambi kokufika kwesofthiwe yokuqala yalolu hlobo, ngokuvamile ayegcwaliswa ngesandla. Ayehlanganisa imigqa namakholomu.
Kodwa ngokungafani nalezo ezindala, ezedijithali zinikeza izici ezengeziwe futhi umphumela utholakala ngendlela engokoqobo.
Esinye salezi zici ikhono lokudala izinkomba zamaseli . Lokhu futhi kungenye yezici eziyisisekelo zokudala idokhumenti eyisisekelo ye-Microsoft Excel . Sikumema ukuthi ufunde okuthunyelwe okulandelayo ukuze ufunde kabanzi ngakho.
Iyini ireferensi yeseli ku-Microsoft Excel futhi isetshenziselwani kuspredishithi?
Lesi yisici esibe sitholakala kusukela ezinguqulweni zokuqala ze- Microsoft Excel. Senze umehluko omkhulu uma kuqhathaniswa nabancintisana nabo. Indlela engcono kakhulu yokuqonda ukuthi isebenza kanjani ngokusebenzisa isifaniso esilula . Cabanga ukuthi ubheka ispredishithi futhi udinga ukufaka inani lamanye amanani amabili kuseli elilodwa.
Esikhundleni sokuthayipha umphumela, uxhuma amaseli ahlobene ngentambo . Khumbula ukuthi ungenza okufanayo ngeseli yomphumela namanye amaseli eshidini elifanayo, noma ngisho nasekhasini elihlukile. Kuhlelo, lena yindlela ephumelelayo yokubonisa ukuthi inani noma umphumela weseli elilodwa noma ngaphezulu kufanele ubonakale kuseli elihlukile.
Funda isinyathelo ngesinyathelo ukuthi ungasebenzisa kanjani izinkomba zamaseli ku-Excel
Njengoba sishilo ngaphambili, ukwazi kahle lesi sici ngaphakathi kwe-Excel kubalulekile ngaphambi kokuthi uqale ukusebenzisa imisebenzi yaso enamandla kakhulu . Kungumsebenzi olula kakhulu, yize kunezinhlobo ezahlukene kuye ngomphumela owufunayo.
Ake sibheke eziyinhloko:
Kusukela kwelinye iseli kuya kwelinye
Lena indlela elula kakhulu. Ukuze wenze lokhu, kufanele ubhale uhlamvu nenombolo ebhekisela kulwazi oluthandayo, ngaphambi kophawu olulinganayo.
Ngokwesibonelo.
- Ephepheni elingenalutho, bhala inani "=23" esitokisini “C2”.
- Okulandelayo, bhala noma yikuphi okunye, (kungaba “A1”umsebenzi “=C2”.
- Ngale ndlela umphumela wokuqala iseli esibhekisele kulo kuzobonakala kwesibili.
Enye indlela yokufeza umphumela ofanayo, kodwa kulokhu usebenzisa inhlanganisela yekhibhodi negundane, yilena elandelayo:
- Faka noma iyiphi inombolo kumaseli okufunayo. Isibonelo, lezo ozozibona esithombeni.
- Okulandelayo, kuseli elizobhekisela, bhala uphawu "=".
- Chofoza kuseli ozobhekisela kulo bese ucindezela “Ngena” Ekugcineni, ungangeza imisebenzi namanye amaseli noma amanani kule nqubo.
Rango
Ithuba lesibili elinikezwa yileli thuluzi ukubhekisela eqenjini lamaseli ahlangene , abizwa ngokuthi "i-Range".
Landela lezi zinyathelo ukuze ufeze lokhu:
- Uma uya yenza isamba samanani afakiwe kulolo hlu, bhala esitokisini esingenalutho “=ISUM(“.
- Okulandelayo, khetha, ukuhudula ngokuchofoza kwesobunxele mayelana namaseli okufanele engezwe.
- Vala umsebenzi ngokubhala uphawu olungekho “)” bese ucindezela “Ngena”.
Elinye ishidi
Kuvunyelwe ngisho nokubhekisela kuseli noma ububanzi obungaphandle kweshidi lamanje, kodwa ngaphakathi kwencwadi yokusebenza efanayo (idokhumenti).
Lokhu kuwusizo kakhulu lapho usebenza ngamadokhumenti amade aqukethe amakhasi ahlukene:
- Sicabanga lokho Idokhumenti yakho isivele inamakhasi amaningana.Ngamanani avezwe kumaseli ahlukene, bhala kuseli elizobhekisela kulo "=".
- Okulandelayo, khetha iseli ozolibhekisela kulo, kungakhathaliseki indawo noma ishidi.
- Qhafaza “Ngena"ukuze.
Sincoma le ndlela kunokufaka ngesandla, njengoba igama leshidi lingashintsha . Kodwa-ke, uma ufisa ukulifaka ngesandla, ifomula ithi “=Sheet3!A1” , lapho ishidi liyinombolo “3” kanti iseli elingaphakathi kwalo lithi “A1” . Uma liqanjwe kabusha, lizoba “='Second Sheet'!A1” , lapho “ Second Sheet” kuyishidi eliqanjwe kabusha futhi “A1” yindawo yeseli.
