Ngokuvamile, phakathi kwamaqembu atholakalayo, abasebenzisi be-Excel babhekisela kwizibalo. Ngosizo lwabo kungenzeka ukukhiqiza izinyathelo ezihlukahlukene ze-arithmetic kanye ne-algebraic. Zivame ukusetshenziselwa ukuhlela nokubala kwesayensi. Sifunda ukuthi leli qembu lama-opharetha limelela kanjani futhi ngokuningiliziwe sizogxila ekuthandweni kwabo.
Ukusebenza kwemisebenzi imisebenzi
Ngosizo lwemisebenzi yezibalo ungenza izibalo ezihlukahlukene. Zizosiza abafundi nabafundi besikole, onjiniyela, ososayensi, abacwaningi, abahleli. Leli qembu liqukethe opharetha abangaba ngu-80. Sizoxoxa ngokuningiliziwe kokuyishumi okuthandwa kakhulu kubo.
Ungakwazi ukuvula uhlu lwefomula amafomula ngezindlela eziningana. Indlela elula yokuqala wizard yomsebenzi ngokuchofoza inkinobho. "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula. Kulokhu, kufanele uqale ukhethe iseli lapho umphumela wokucubungula idatha uzoboniswa khona. Le ndlela inhle ngoba ingasetshenziswa kusuka kunoma iyiphi ithebhu.
Ungase futhi uqalise i-Function Wizard ngokuya kuthebhu "Amafomula". Kulapho udinga ukucindezela inkinobho "Faka umsebenzi"etholakala ngakwesokunxele ngakwesokunxele kwetheyipu ebhokisini lamathuluzi "I-Function Library".
Kunendlela yesithathu yokuqalisa umsebenzi wizard. Yenziwa ngokucindezela inhlanganisela yokhiye ekhibhodi. Shift + F3.
Ngemuva kokuthi umsebenzisi enze noma yiziphi izenzo ezingenhla, i-Function Wizard ivula. Chofoza efasiteleni ensimini "Isigaba".
Uhlu lokudonsa luvuleka. Khetha isikhundla kuso "Isibalo".
Emva kwalokho, uhlu lwazo zonke izibalo zemisebenzi ku-Excel livela efasiteleni. Ukuze uye ekungenisweni kwezingxabano, khetha eyodwa bese uchofoza inkinobho "Kulungile".
Kukhona indlela yokukhetha opharetha othize wezibalo ngaphandle kokuvula iwindi eliyinhloko loMsebenzi Wensizakalo. Ukuze wenze lokhu, iya kuthebhu kakade ejwayelekile. "Amafomula" bese uchofoza inkinobho "Isibalo"etholakala kutheyipu eqenjini lamathuluzi "I-Function Library". Uhlu luvuleka kulokho okudingayo ukukhetha ifomula edingekayo ukuxazulula umsebenzi othize, emva kwalokho iwindi lezingxoxo zalo zizovula.
Nokho, kufanele kuqashelwe ukuthi akuzona zonke amafomula eqenjini lezibalo ezethulwa kulolu hlu, nakuba iningi lawo likhona. Uma ungatholi opharetha oyidingayo, chofoza ku-intwana "Faka umsebenzi ..." phansi kakhulu ohlwini, emva kwalokho uMphathi wemisebenzi, osevele ejwayelekile kithi, uzovula.
Isifundo: I-Excel Function Wizard
SUM
Umsebenzi ovame ukusetshenziswa kakhulu SUM. Lo opharetha uhloselwe ukwengeza idatha kumaseli amaningana. Nakuba kungasetshenziselwa ukufingqwa okujwayelekile kwezinombolo. I-syntax engasetshenziselwa ukufaka okokufaka ngesandla kanje:
= SUM (inombolo1; inombolo2; ...)
Ewindini lezimangalo, faka izixhumanisi zeseli noma izixazululo zedatha emasimini. Opharetha uyanezela okuqukethwe futhi ubonise inani eliphelele esitokisini esithile.
Isifundo: Indlela yokubala inani ku-Excel
Amanani
I-Operator Amanani futhi sinquma inani lezinombolo kumaseli. Kodwa, ngokungafani nomsebenzi odlule, kulolu opharetha, ungasetha isimo esizocacisa ukuthi yiziphi izimiso ezihilelekile ekubalweni, futhi okungekho. Uma ucacisa lesi simo, ungasebenzisa izimpawu ">" ("ngaphezulu"), "<" ("ngaphansi kwe"), "" ("akulingani"). Okusho ukuthi, inombolo engahlangabezane nesimo esibekiwe ayicatshangelwa ekuphikisweni kwesibili lapho kubalwa inani. Ngaphezu kwalokho, kunengxabano eyengeziwe "Isigaba sokubamba"kodwa akuyona impoqo. Le nqubo ine-syntax elandelayo:
= SUMMESLES (Uhlobo; Isigaba; Range_Summing)
ROUND
Njengoba kungaqondakala kusuka egameni lomsebenzi ROUNDIsebenza ezinombolweni ezizungezile. Ukuphikisana kokuqala kwalokhu opharetha kuyinombolo noma ukubhekisela kuseli eliqukethe isici senombolo. Ngokungafani neminye imisebenzi eminingi, lolu hlu alukwazi ukwenza njengenani. Ingxabano yesibili yinombolo yezindawo zedesimali kuya kuzungeze. Ukujikeleza kwenziwa ngokuvumelana nemithetho jikelele yezibalo, okungukuthi, kwinombolo ye-modulo esiseduze. I-syntax yale fomula ngu:
= ROUND (inombolo; amadijithi)
Ngaphezu kwalokho, ku-Excel, kunemisebenzi efana nale ROUNDUP futhi CIRCLEokuyinto ngokulandelana izinombolo kuya eseduze kakhulu futhi encane in value ngokuphelele.
Isifundo: Izinombolo ezihambayo ze-Excel
Ukukhiqiza
Umsebenzi we-Operator CALL ukuphindaphinda kwezinombolo ngabanye noma lezo ezitholakala kumaseli eshidi. Iziphakamiso zalo msebenzi zibhekisela kumaseli aqukethe idatha yokuphindaphinda. Kuze kube ngu-255 izixhumanisi ezinjalo zingasetshenziswa. Umphumela wokuphindaphinda uboniswa kuseli elihlukile. I-syntax yalesi sitatimende yile:
= UKUQALA (inombolo; inombolo; ...)
Isifundo: Indlela yokwandisa kahle ku-Excel
ABS
Ukusebenzisa ifomati yamathematika ABS Ibala inani le-module. Lesi sitatimende sinokuphikisana okukodwa - "Inombolo"okungukuthi, ukubhekisela kweseli equkethe idatha yenombolo. Ububanzi obunendima yokuphikisana akunakwenzeka. I-syntax yile:
= ABS (inombolo)
Isifundo: Umsebenzi we-module we-Excel
IZIHLOKO
Kusuka egameni kucacile ukuthi umsebenzi womqhubi IZIHLOKO ukwakhiwa kwenombolo kuya kwizinga elinikeziwe. Lo msebenzi unemibono emibili: "Inombolo" futhi "Isiqu". Okokuqala kungachazwa njengokubhekisela kuseli elinenani lezinombolo. Ingxabano yesibili ibonisa izinga lokumiswa. Kusukela kulokhu okulandelayo kulandela ukuthi i-syntax yalolu opharetha kanje:
= DEGREE (inombolo; degree)
Isifundo: Indlela yokukhulisa i-degree ku-Excel
I-ROOT
Umsebenzi womsebenzi I-ROOT iyindawo yokudonsa isikwele. Lo opharetha unokuphikisana okukodwa - "Inombolo". Esikhundleni salo singabhekisela kuseli eliqukethe idatha. I-syntax ithatha leli fomu elilandelayo:
= INQUBO (inombolo)
Isifundo: Indlela yokubala impande ku-Excel
CASE
Ifomula inomsebenzi okhethekile. CASE. Iqukethe ekuphumeni kweseli ecacisiwe noma iyiphi inombolo ehleliwe ephakathi kwezinombolo ezimbili ezinikezwe. Kusukela ekuchazeni ukusebenza kwalolu opharetha kucacile ukuthi izingxabano zalo zingumkhawulo ophezulu nangaphansi. I-syntax yakhe yile:
= ISICELO (Esincane-esingezansi; Upper_boundary)
I-PRIVATE
I-Operator I-PRIVATE esetshenziswa ukuhlukanisa izinombolo. Kodwa emiphumeleni yokuhlukaniswa, ibonisa inombolo nje kuphela, ehlangene nenombolo encane. Iziphakamiso zalolu fomula zibhekisela kumaseli aqukethe isahluko kanye nomshayeli. I-syntax ilandelayo:
= PRIVATE (Numerator; Denominator)
Isifundo: Hlanganisa ifomula ku-Excel
ROMAN
Lo msebenzi uvumela ukuthi uguqule izinombolo zama-Arabhu, okusetshenziswe i-Excel ngokuzenzakalelayo, kwinamba yamaRoma. Lo opharetha unezimpikiswano ezimbili: ukubhekisela kweseli nenombolo ezoguqulwa, kanye nefomu. Ingxabano yesibili iyakhethwa. I-syntax yile:
= I-ROMAN (Inombolo; Ifomu)
Ngenhla, kuphela imisebenzi evelele kakhulu ye-Excel yemisebenzi echazwe. Basiza ukwenza lula ukubala okuhlukahlukene kule hlelo. Ngosizo lwamafomula, ungenza kokubili izibalo ezilula nezibalo eziyinkimbinkimbi. Ikakhulukazi basiza ezimweni lapho udinga ukwenza izibalo ezinkulu.
