Ngokuvamile, phakathi kwamaqembu atholakalayo wemisebenzi, abasebenzisi be-Excel baphendukela kulabo bezibalo. Ngokusebenzisa zona, ungenza imisebenzi ehlukene ye-arithmetic ne-algebraic. Zivame ukusetshenziswa ekuhleleni nasekubaleni kwezesayensi. Sizothola ukuthi yini leli qembu labahlinzeki ngokujwayelekile, bese sihlala ngemininingwane ethe xaxa ngabathandwa kakhulu kubo.
Ukusetshenziswa kwemisebenzi yezibalo
Usebenzisa imisebenzi yezibalo, ungenza izibalo ezahlukahlukene. Zizoba wusizo kubafundi nakwizingane zesikole, onjiniyela, ososayensi, ama-accountant, abahleli. Leli qembu lifaka cishe ama-opharetha angama-80. Sizohlala ngokuningiliziwe kwabayishumi abathandwa kakhulu kubo.
Ungavula uhla lwamafomula wezibalo ngezindlela eziningi. Indlela elula yokuqalisa Umsebenzi Wizard ngokuchofoza inkinobho. "Faka umsebenzi", etholakala kwesobunxele sebha yefomula. Kulokhu, kufanele ukhethe kuqala iseli lapho umphumela wokulungiswa kwedatha uzokhonjiswa khona. Le ndlela yinhle ngoba ingaqalwa kunoma iyiphi ithebhu.
Ungase futhi uqalise Umsebenzi Wizard ngokuya kuthebhu Amafomula. Lapho udinga chofoza inkinobho "Faka umsebenzi"etholakala emaphethelweni angakwesobunxele wetheyibhu ebhulini lamathuluzi Umtapo wesici.
Kunendlela yesithathu yokwenza kusebenze Umsebenzi Wizard. Kwenziwa ngokucindezela ukuhlanganiswa kwezinkinobho kukhibhodi I-Shift + F3.
Ngemuva kokuthi umsebenzisi enze noma yisiphi isenzo esingenhla, i-Function Wizard iyavula. Qhafaza ewindini Isigaba.
Uhlu olwehlayo luvula. Khetha isikhundla kukho "Izibalo".
Ngemuva kwalokho, uhlu lwayo yonke imisebenzi yezibalo ku-Excel luvela efasiteleni. Ukuze uqhubeke nokwazisa kwezimpikiswano, khetha eyodwa ethize bese uchofoza inkinobho "Kulungile".
Kukhona nendlela yokukhetha opharetha wezibalo ezithile ngaphandle kokuvula iwindi eliyinhloko le-Function Wizard. Ukuze wenze lokhu, iya kuthebhu esesikujwayele Amafomula bese uchofoza inkinobho "Izibalo"etholakala kubambo eqenjini lamathuluzi Umtapo wesici. Uhlu luyavula, lapho udinga ukukhetha khona ifomula edingekayo yokuxazulula inkinga ethile, emva kwalokho kuvuleka iwindi lokuphikisana kwayo.
Kuliqiniso, kufanele kuqashelwe ukuthi akuzona zonke izindlela zeqembu lezibalo ezivezwe kulolu hlu, yize iningi lazo zinjalo. Uma ungamtholi opharetha owuthandayo, bese uchofoza entweni "Faka umsebenzi ..." ezansi kohlu, emva kwalokho kuzovulwa i-Function Wizard esejwayelekile.
Isifundo: Umsebenzi Wizard e-Excel
ISUM
Umsebenzi osetshenziswa kakhulu ISUM. Lo opharetha wenzelwe ukwengeza idatha kumaseli amaningi. Yize ingasetshenziselwa i-DRM ejwayelekile yezinombolo. I-syntax engasetshenziswa ngokufakwa kwencwajana ingendlela elandelayo:
= SUM (inombolo1; inombolo2; ...)
Kuwindi lokuphikisana, kufanele ufake izixhumanisi kumaseli anedatha noma amabanga emasimini. U-opharetha unezela okuqukethwe futhi akhombise inani eliphelele kuseli elihlukile.
Isifundo: Ungayibala kanjani inani ku-Excel
ISILAMU
Umsebenzi ISILAMU futhi ibala inani eliphelele lamanani amangqamuzana. Kepha, ngokungafani nomsebenzi wangaphambilini, kule opharetha ungabeka umbandela ozocacisa ukuthi yimaphi amanani ahilelekile ekubalweni nokuthi yikuphi okungah. Lapho ucacisa isimo, ungasebenzisa izimpawu ">" ("more"), "<" ("kancane"), "" ("alilingani"). Okusho ukuthi, inombolo engahlangabezana naleso simo ebekiwe ayithathwa njengengxabano yesibili lapho kubalwa inani. Ngaphezu kwalokho, kunempikiswano eyengeziwe "Ububanzi be-Summation"kepha kuyakhethwa. Lo msebenzi une-syntax elandelayo:
= SUMMES (Ibanga; I-Criterion; Sum_range)
Round
Njengoba kungaqondakala kusuka egameni lomsebenzi Round, kusebenza izinombolo eziyindilinga. Ukuphikisana kokuqala kwalokhu ku-opharetha kuyinombolo noma ireferensi yeseli equkethe into yezinombolo. Ngokungafani neminye imisebenzi eminingi, leli banga alikwazi ukubaluleka. Ukuphikisana kwesibili inani lezindawo zamadesimali ofuna ukuzungeza. Ukujikeleza kwenziwa ngokwemithetho ejwayelekile yezibalo, okungukuthi, kwinombolo ye-modulo eseduze. I-syntax yale formula yile:
= Round (inombolo; inombolo_emidwebo)
Ngaphezu kwalokho, i-Excel inezici ezifana Round UP futhi KULUNGILE, ahlukanisa izinamba ziye ezinkudlwana ezinkulu nezincane.
Isifundo: Ukufaka izinombolo ku-Excel
UMkhiqizo
Umsebenzi we-opharetha CELA ukuphindaphindwa kwezinombolo ngazinye noma lezo ezisezitokisini zeshidi. Izimpikiswano zalo msebenzi ziyinkomba kumaseli aqukethe idatha yokuphindaphindeka. Sekukonke, kuze kufinyelele ku-255 izixhumanisi ezinjalo zingasetshenziswa. Umphumela wokuphindaphindwa uboniswa kuseli elihlukile. I-syntax yalesi sitatimende imi ngalendlela elandelayo:
= IProduct (inombolo; inombolo; ...)
Isifundo: Unganda kanjani ngendlela efanele ku-Excel
I-ABS
Kusetshenziswa ifomula yezibalo I-ABS inombolo ibalwa modulo. Lo opharetha unempikiswano eyodwa - "Inombolo", okungukuthi, ireferensi yeseli equkethe idatha yamanani. Ibanga alikwazi ukusebenza njengengxabano. I-syntax imi kanje:
= ABS (inombolo)
Isifundo: Umsebenzi we-Module ku-Excel
IDIVINILE
Kusuka kwigama kuyacaca ukuthi umsebenzi opharetha IDIVINILE iphakamisa inombolo ngezinga elithile. Lo msebenzi unezimpikiswano ezimbili: "Inombolo" futhi "Isiqu". Owokuqala wabo ungakhonjiswa njengesixhumanisi seseli equkethe inani lokubala. Ukuphikisana kwesibili kukhombisa izinga le-erection. Kusukela kokushiwo ngenhla, kulandela ukuthi syntax yalokhu ku-opharetha imi ngalendlela elandelayo:
= DEGREE (inombolo; idigri)
Isifundo: Ungayichaza kanjani i-Excel
INDLALO
Inselelo yomsebenzi INDLALO ukukhishwa kwempande yesikwele. Lo opharetha unempikiswano eyodwa kuphela - "Inombolo". Indima yayo kungaba isixhumanisi seseli eliqukethe idatha. I-syntax ithatha leli fomu:
= I-ROOT (inombolo)
Isifundo: Ungasibala kanjani izimpande ku-Excel
CASE BETWEEN
Umsebenzi othize wefomula CASE BETWEEN. Kuqukethe ukubonisa noma iyiphi inombolo engahleliwe phakathi kwezinombolo ezimbili ezinikezwe esitokisini esichaziwe. Ngokwencazelo yokusebenza kwalesi opharetha kuyacaca ukuthi iziphikiso zawo ziyimingcele ephezulu nangaphansi yesikhathi sokuphumula. I-syntax yakhe yile:
= CASE BETWEEN (Lower_Bound; Upper_Bound)
KHAWULA
Umsebenzi KHAWULA isetshenziselwa ukwahlukanisa izinombolo. Kepha emiphumeleni yokuhlukaniswa, ukhombisa inombolo kuphela, eyindilinga kwimodulus encane. Izimpikiswano kule formula yizinkomba kumaseli aqukethe ukwahlukaniswa nokwahlukanisa. I-syntax imi kanje:
= ISIVIVINYO (Inombolo; iDenomator)
Isifundo: Ifomula yokuhlukaniswa kwe-Excel
ROMAN
Lo msebenzi ukuvumela ukuthi uguqule izinombolo zama-Arabhu, ezisebenzisa i-Excel ngokuzenzakalelayo, ziye kwisiRoma. Lo opharetha unezimpikiswano ezimbili: ireferensi yeseli enenombolo eguqukayo nefomu. Ingxabano yesibili iyakhethwa. I-syntax imi kanje:
= ROMAN (Inombolo; Ifomu)
Misebenzi ethandwa kakhulu yezibalo ye-Excel kuphela echazwe ngenhla. Basiza kakhulu ukwenza lula ukubalwa okuhlukahlukene kulolu hlelo. Usebenzisa lawa mafomula, ungenza imisebenzi elula kakhulu yezibalo nokubalwa okuyinkimbinkimbi. Ikakhulu bayasiza ezimweni lapho udinga ukwenza khona amakhambi enqwaba.
