Iingqungquthela yimiqobo esebenzayo ukwenza izibalo. Kwiiprogram ze- spreadsheet ezifana ne-Excel kunye ne-Google AmaSpredishithi, imisebenzi yenziwe ngamafomula ezakhelwe ukubala kunye nemininzi yale mi sebenzi idinga idatha ukuba ingeniswe, mhlawumbi ngumsebenzisi okanye omnye umthombo, ukuze ubuyise umphumo.
Umsebenzi weSintax
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, abazali, abahluli be-comma kunye neengxabano zalo.
Iingxoxo zihlala zijikelezwe ngabazali kunye neengxabano ngabanye zihlukaniswe ngama-commas.
Umzekelo olula, oboniswe kumfanekiso ongentla, ngumsebenzi we-SUM - ongasetyenziselwa ukulinganisa okanye iikholomu ezide okanye imiqolo yamanani. I-syntax yalo msebenzi yile:
ISUM (Inani1, Inani2, ... Inani255)
Iingxoxo zalo msebenzi zi: Number1, Number2, ... Inani255
Inani lamaArguments
Inombolo yeziphakamiso ezenziwa ngumsebenzi ziyahluka kunye nomsebenzi. Umsebenzi we-SUM unokufikelela kuma- arguments angama-255, kodwa enye kuphela iyadingeka - ingxabano yeNombolo1 - intsalela ikhethiweyo.
Umsebenzi we-OFFSET, okwangoku, unamalungu amathathu afuna iingxabano kunye neendlela ezimbini zokuzikhethela.
Eminye imisebenzi, njengemiSebenzi ye- MANJE kunye ne- TODAY , abanakho iziphakamiso, kodwa bamba idatha yabo- inombolo ye - serial okanye usuku-ukusuka kwikhompyutheni yeekhompyutha. Nangona kungekho ziphakamiso ezifunwa yiloo mi sebenzi, abazali, abayingxenye yenkqubo ye-syntax, kufuneka bafakwe xa befaka umsebenzi.
Iintlobo zeenkcukacha kwiingxoxo
Njengenani leengxabano, iintlobo zedata ezingenakho ukungena kwimpikiswano ziyahlukahluka kuxhomekeke kumsebenzi.
Kwimeko yomsebenzi we-SUM, njengoko kuboniswe kumfanekiso ongentla, iingxoxo kufuneka zibe neenkcukacha zeenombolo-kodwa le datha ingaba:
- idatha echanekileyo isingqinisiso-ingxabano yeNombolo1 kumfanekiso ongentla;
- ireferensi yecala nganye kwindawo yendawo yedatha kwiphepha lokusebenzela - ingxabano yeNombolo2;
- uluhlu okanye uluhlu lweenkcazelo zeeseli - imbambano yeNombolo3;
Ezinye iintlobo zedatha ezingasetyenziselwa iingxoxo zibandakanya:
- idatha yombhalo;
- Ixabiso leBoolean ;
- Iimpazamo zephutha ;
- neminye imisebenzi.
ImiSebenzi yokuHlola
Kuqhelekileyo ukuba umsebenzi omnye ungeniswe njengengxabano yomnye umsebenzi. Lo msebenzi uyaziwa njengemisebenzi yokuhlalisa kwaye yenziwe ukunyusa amandla ophulo lwenkqubo ekusebenzeni izibalo ezinzima.
Ngokomzekelo, akuqhelekanga ukuba imisebenzi ye- IF ibe yindleke ngaphakathi kwelinye njengoko iboniswe ngezantsi.
= IF (A1> 50, IF (A2 <100, A1 * 10, A1 * 25)
Kulo mzekelo, umsebenzi we sibini okanye okhuniweyo we-IF usetyenziswe njenge- Value_if_yiyo ingxabano yomsebenzi wokuqala we-IF kwaye isetyenziselwa ukuvavanya imeko yesibini - ukuba idatha kwi-cell A2 ingaphantsi kwe-100.
Ukususela kwi-Excel ka-2007, amanqanaba angama-64 okuzala avunyelwe kwiifomula. Ngaphambi koko, iinqanaba ezisixhenxe kuphela zokuxhaswa zaxhaswa.
Ukufumana Umsebenzi & # 39; s Arguments
Izindlela ezimbini zokufumana iimfuno zengxabano kwimisebenzi nganye:
- Vula ibhokisi yencoko yencoko yomsebenzi kwi-Excel;
- Iifayile ze-Tooltip kwi-Excel kunye ne-Google Spreadsheets.
Iibhokisi zeDiscobo zokuSebenza ze-Excel
Ubuninzi bemisebenzi kwi-Excel inobhokisi yencoko-kuboniswe kumsebenzi we-SUM kumfanekiso ongentla-oluhlu lweengxoxo ezifunekayo kunye nezikhethelo zomsebenzi.
Ukuvula ibhokisi yencoko yencoko yomsebenzi inokwenziwa ngu:
- ukufumana kunye nokucofa kwigama lomsebenzi phantsi kwethebhu ye Formu yebhoni ;
- ngokuchofoza kwindlela yokuSebenza yokuSebenza esekelwe kwibha yefom - njengoko kuboniswe kumfanekiso ongentla.
Izixhobo: Ukuthayipha Umsebenzi & # 39;
Enye indlela yokufumana iingxoxo zomsebenzi kwi-Excel nakwi-Google Spreadsheets kukuba:
- Cofa kwiseli,
- Faka uphawu olulinganayo - ukwazisa inkqubo efakwe ifomu;
- Faka igama lomsebenzi - njengoko uthayipha, amagama azo yonke imisebenzi eqala ngalo ileta ibonakala kwisixhobo sekhompyutha ngaphantsi kweeseli esebenzayo;
- Faka umzali ovulekile - umsebenzi ochaziweyo kunye neziphakamiso zayo zidweliswe kwisixhobo sokusetyenziswa.
Kwi-Excel, iwindow ye-tooltip ijikeleze iziphakamiso ezikhethiweyo kunye neebakaki zesikwere ([]). Bonke abanye badwelise iziphakamiso ezifunekayo.
Kwi-Google Spreadsheets, iwindow ye-tooltip ayihlukanisi phakathi kweengxoxo ezifunekayo kunye nezakhethiweyo. Kunoko, kubandakanya umzekelo kunye nesishwankathelo sokusetyenziswa komsebenzi kunye nenkcazo yempikiswano nganye.