Amakholomu Ashesha Ngokushesha noma Imigqa Yezinombolo ku-Excel

Engeza izinto ngokushesha

Ukwengeza amakholomu noma imigqa yezinombolo ingenye yezenzo ezivame ukwenziwa ezinhlelweni zespredishithi njenge-Excel noma i- Google Spreadsheets .

Umsebenzi we-SUM unikeza indlela esheshayo futhi elula yokufeza lo msebenzi emsebenzini we-Excel.

01 ka 05

Umsebenzi we-SUM Syntax nama-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-SUM yilezi:

= ISUM (Inombolo1, Inombolo2, ... Inombolo255)

Inombolo1 - (edingekayo) inani lokuqala okufanele lifinyelwe.
Le mpikiswano ingaqukatha idatha yangempela ehlanganisiwe noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela .

Inombolo2, Inombolo3, ... Inombolo255 - (okukhethwa kukho) amanani engeziwe angezofinyelelwa ku-255.

02 ka 05

Ukufaka umsebenzi we-SUM usebenzisa izinqamuleli

Okudumile kakhulu umsebenzi we-SUM ukuthi i-Microsoft idale izinqamuleli ezimbili ukwenza kube lula ukuyisebenzisa:

• Isinqamuleli sekhibhodi.
• I-AutoSUM ithebhu yaseKhaya yebhebhoni.

Okunye okukhethwa kukho ukungena kulo msebenzi kufaka:

• Ukusebenzisa ibhokisi lengxoxo lomsebenzi.
• Ukufaka umsebenzi ngesandla.

03 ka 05

Idatha Yomumo ku-Excel Ukusebenzisa Izinqamuleli Zesikhashana

Inhlanganisela eyinhloko yokufaka umsebenzi we-SUM yile:

Alt + = (uphawu olulinganayo)

Isibonelo

Izinyathelo ezilandelayo zisetshenziselwa ukungena umsebenzi we-SUM usebenzisa izinkinobho ezifinyelele ngenhla

1. Chofoza kuseli lapho umsebenzi we-SUM kufanele utholakale khona.
2. Cindezela bese ubamba ikhi Alt ekhibhodi.
3. Cindezela bese ukhulula uphawu olulinganayo (=) kukhibhodi ngaphandle kokukhipha ukhiye we-Alt.
4. Khipha ukhiye we- Alt .
5. Umsebenzi we-SUM kufanele ungene esitokisini esisebenzayo ngephuzu lokufaka noma isikhombisi esivela phakathi kwebhangqa labakaki abangenalutho.
6. Abakaki babamba ingxabano yomsebenzi - ububanzi bezinkomba zocingo noma izinombolo okufanele zifingqwe.
7. Faka ingxabano yomsebenzi:
   • usebenzisa iphuzu bese uchofoze ngegundane ukufaka izingqikithi zamaseli ngabanye (bheka Qaphela ngezansi);
   • usebenzisa ukuchofoza bese uhudula negundane ukuze ugcizelele uhla lwamandla amangqamuzana;
   • ukuthayipha izinombolo noma izinkomba zocingo ngesandla.
8. Uma ngabe ingxabano ifakiwe, cindezela ukhiye we- Enter ekhibhodi ukuqedela umsebenzi;
9. Impendulo kufanele ivele esitokisini equkethe umsebenzi;
10. Uma uchofoza kuseli eliqukethe impendulo, umsebenzi ophelele we-SUM uvela kubha yefomula ngaphezulu kwephepha lokusebenzela;

Qaphela : Uma ufaka ingxabano yomsebenzi, khumbula:

• izingqikithi zamaseli ngabanye ezifakiwe ngokuthayipha noma ukukhomba kumele zihlukaniswe ngama-commas;
• ukuze uhla lwezinombolo ezifakiwe zifakwe ngokuthayipha, izingqikithi zokuqala zamaseli zingase zihlukaniswe ikoloni ephelele (:)

04 ka 05

Idatha Yomumo ku-Excel Usebenzisa i-AutoSUM

Kulabo abakhetha ukusebenzisa igundane kunokuba ikhibhodi, isinqamuleli se-AutoSUM esisethempelini laseKhaya lebhebhoni, njengoba kuboniswe esithombeni ngenhla, singasetshenziswa ukufaka umsebenzi we-SUM.

Ingxenye Yokuzenzakalela yegama i-AutoSUM ibhekisela eqinisweni lokuthi uma ufakwa usebenzisa le ndlela, umsebenzi ukhetha ngokuzenzakalelayo lokho okukholelwa ukuthi ububanzi bamaseli abuzofinganiswa nomsebenzi.

Njengoba kuboniswe esithombeni ngenhla, ibanga elikhethiwe livulekile futhi lizungezwe umngcele oveziwe obizwa ngokuthi ukuhamba ngezintuthwane.

Qaphela :

• Umsebenzi we-SUM uklanyelwe ukungena ngaphansi kwekholomu yedatha noma ekugcineni kwesigcawu sedatha.
• Uma umsebenzi we-SUM ufakwe endaweni ngaphandle kwalaba ababili, ububanzi bamaseli akhethiwe njengengxabano yomsebenzi kungenzeka ukuthi akulungile.
• Ukuze ushintshe ibanga elikhethiwe, sebenzisa i-pointer yegundane ukugqamisa uhla olufanele ngaphambi kokucindezela ukhiye we- Enter ukuqedela umsebenzi

Ukusebenzisa i-AutoSUM:

1. Chofoza kuseli lapho umsebenzi kufanele utholakale khona;
2. Cindezela isithonjana se- AutoSUM ku-Ribbon;
3. Umsebenzi we-SUM kufanele ungene esitokisini esisebenzayo nebanga lobukhulu lokubambezeleka;
4. Hlola ukubona ukuthi uhla oluzungezile - oluzokwenza ingxabano yomsebenzi ilungile;
5. Uma ibanga lilungile, cindezela ukhiye we- Enter ekhibhodi ukuqedela umsebenzi;
6. Impendulo izoboniswa esitokisini lapho umsebenzi wangena khona;
7. Uma uchofoza kuseli eliqukethe impendulo, umsebenzi ophelele we-SUM uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.

05 ka 05

Ukusebenzisa ibhokisi le-Function SUM

Imisebenzi eminingi ku-Excel ingangenwa ngokusebenzisa ibhokisi lengxoxo , elikuvumela ukuba ufake izingxabano zomsebenzi kumigqa ehlukile. Ibhokisi lengxoxo libuye lisebenzise i-syntax yomsebenzi - njengabazali bamahhala wokuvulwa nokuvala kanye nama-commas asetshenziselwa ukuhlukanisa izingxabano ngabanye.

Nakuba izinombolo ezithile zingangeniswa ngokuqondile ebhokisini lezingxoxo njengama-arguments, ngokuvamile kungcono ukufaka idatha kumaseli wokusebenzela bese ufaka izingqikithi zeseli njengama-arguments for the function.

Ukufaka umsebenzi we-SUM usebenzisa ibhokisi lengxoxo:

1. Chofoza kuseli lapho imiphumela izoboniswa khona.
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon .
3. Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza.
4. Chofoza ku- SUM kuhlu ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lengxoxo, chofoza kulayini leNombolo1 .
6. Qinisekisa okungenani iselferensi yeselula noma uhla lwezinkomba.
7. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo.
8. Impendulo kufanele ivele kuseli elikhethiwe.