Lapho usebenza nedatha, ngokuvamile kunesidingo sokuthola ukuthi indawo eyodwa noma enye inkomba ithatha kuhlu olubanzi. Kuzibalo, lokhu kubizwa ngokuthi kusezingeni. I-Excel ineamathuluzi avumela abasebenzisi ukuba benze le nqubo ngokushesha futhi kalula. Ake sithole ukuthi singayisebenzisa kanjani.
Imisebenzi eyisisekelo
Ukwenza isimo ku-Excel inikeza izici ezikhethekile. Ezinguqulo ezidala zohlelo lokusebenza kwakukhona opharetha owodwa oklanyelwe ukuxazulula le nkinga - Isibalo. Ngezizathu zokuhambisana, kushiywe kusigaba esithile sezimfomula nasenguqulweni zanamuhla zesimiso, kodwa kuzo, kusadingeka ukuthi usebenze ngezifaniso ezintsha, uma kungenzeka. Lokhu kufaka phakathi opharetha bokubala. I-RANG.RV futhi RANG.SR. Sizoxoxa ngokungafani kanye ne-algorithm yokusebenza nabo ngokuqhubekayo.
Indlela 1: Umsebenzi we-RANK
I-Operator I-RANG.RV iqhuba idatha kanye nemiphumela yocingo ecacisiwe inombolo yokulandelana kwempikiswano ecacisiwe esuka kuhlu oluqoqiwe. Uma izindinganiso eziningana zinezinga elifanayo, u-opharetha ubonisa okuphezulu ohlwini lwamanani. Uma, isibonelo, amanani amabili anenani elifanayo, bobabili bazokwaziswa ngenombolo yesibili, futhi inani elilandelayo elikhulu lizobe nelinye lesine. Ngendlela, opharetha wenza ngendlela efanayo. Isibalo kuzinguqulo ezindala ze-Excel, ukuze le misebenzi ingacatshangwa ifana.
I-syntax yalesi sitatimende ibhalwe kanje:
= RANK RV (inombolo; isixhumanisi; [oda])
Iziphakamiso "inombolo" futhi "isixhumanisi" kudingeka futhi "oda" - ngokuzithandela. Njengengxabano "inombolo" Udinga ukufaka isixhumanisi esitokisini lapho inani eliqukethwe khona, inombolo yokulandelana okudingeka ukwazi. Ukuphikisana "isixhumanisi" iqukethe ikheli lendawo yonke ebalwa. Ukuphikisana "oda" kungaba nezincazelo ezimbili - "0" futhi "1". Esikhathini sokuqala, umyalelo we-oda uqhubeka wehla, futhi okwesibili - ngokukhula. Uma le mpikiswano ingacacisiwe, ke kucatshangwa ngokuzenzakalelayo uhlelo olulingana no-zero.
Le fomula ingabhalwa ngesandla esitokisini lapho ufuna khona imiphumela yokucubungula ukuthi iboniswe, kodwa kubasebenzisi abaningi kulula ukubeka okokufaka ngefasitela Amakhosi omsebenzi.
- Khetha iseli kushidi lapho umphumela wokucubungula idatha uzoboniswa khona. Chofoza inkinobho "Faka umsebenzi". Itholakala ngakwesokunxele kwibha yefomula.
- Lezi zenzo zenza iwindi iqale. Amakhosi omsebenzi. Ihlinzeka konke (ngezingavamile ezingavamile) opharetha ezingasetshenziswa ukwakha amafomula ku-Excel. Esikhathini "Isitatimende" noma "Uhlu oluphelele lwe-alfabhethi" thola igama "RANK.RV", ukhethe futhi uchofoze inkinobho ethi "Kulungile".
- Ngemuva kwezinyathelo ezingenhla, i-window ye-arguments function izosebenza. Ensimini "Inombolo" faka ikheli leseli ofuna ukulinganisa ngalo. Lokhu kungenziwa ngesandla, kodwa kulula kakhulu ukwenza ngendlela echazwe ngezansi. Setha isikhombisi emkhakheni "Inombolo", bese uvele ukhethe iseli elifunayo kushidi.
Emva kwalokho, ikheli layo lizofakwa ensimini. Ngendlela efanayo, singena idatha emkhakheni "Xhumanisa", kuphela kuleli cala sikhetha uhla lonke, lapho simo sithathwa khona.
Uma ufuna ukuthi inkundla ihambe kusukela kokuncane kuya kokuningi, khona-ke ensimini "Hlela" kufanele usethe inombolo "1". Uma kudingekile ukuba lo myalelo uhanjiswe kusuka ezinkulu kuya ezincane (futhi kunani eliqine kakhulu lamacala lokhu okuyiyona nto edingekayo), ke le nsimu ishiywe ingenalutho.
Ngemuva kokuthi yonke idatha engenhla ifakiwe, chofoza inkinobho "Kulungile".
- Ngemva kokwenza lezi zenzo, inombolo yokulandelana izoboniswa kuseli elichaziwe ngaphambilini, elinenani elikhethile phakathi kohlu lonke lwedatha.
Uma ufuna ukubeka indawo yonke indawo ecacisiwe, awudingi ukufaka ifomula ehlukile yenkomba ngayinye. Okokuqala, senza ikheli endle "Xhumanisa" ngokuphelele. Engeza isibonakaliso se-dollar ngaphambi kwenani ngalinye lokuxhumanisa ($). Ngesikhathi esifanayo, shintsha amanani ensimini "Inombolo" akufanele neze kube yinto ephelele, ngaphandle kwalokho ifomula izobalwa ngokungalungile.
Ngemuva kwalokho, udinga ukusetha isikhombisi ekhoneni elingezansi elingakwesokudla leseli, futhi ulinde uphawu lokugcwalisa luvele ngendlela yesiphambano esincane. Bese ubamba inkinobho yegundane lesokunxele bese welula umaka ohambisana nendawo ebalwe.
Njengoba ubona, ngakho-ke, ifomula izokopishwa, futhi simo sizokwenziwa kuwo wonke uhla lwedatha.
Isifundo: I-Excel Function Wizard
Isifundo: Ukuxhumanisa okuphelele nokuhlobene ku-Excel
Indlela 2: Umsebenzi we-RANK.SR
Umsebenzi wesibili osebenza ngokusezingeni ku-Excel RANG.SR. Ngokungafani nemisebenzi Isibalo futhi I-RANG.RV, ngokungahambi kahle kwamagugu wezinto eziningana lo opharetha unikeza izinga elilinganiselwe. Okusho ukuthi, uma amanani amabili enenani elilinganayo futhi alandela inani elibalwe 1, bobabili bazokwaziswa ngenombolo 2.5.
I-Syntax RANG.SR kufana kakhulu nesitatimende esandulele. Kubonakala kanje:
= RANK.SR (inombolo; isixhumanisi; [oda])
Ifomula ingangenwa ngesandla noma ngokusebenzisa idijithali yomsebenzi. Sizohlala ngenguqulo yokugcina ngokuningiliziwe.
- Yenza ukhetho lweseli kushidi ukuze ubonise umphumela. Ngendlela efanayo nangesikhathi esidlule, iya ku- Umsebenzi weWebhu ngokusebenzisa inkinobho "Faka umsebenzi".
- Ngemuva kokuvula iwindi Amakhosi omsebenzi sikhetha ohlwini lwamaqembu "Isitatimende" igama RANG.SR bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano ivuliwe. Amaphuzu alo mqhubi afana ncamashi nomsebenzi I-RANG.RV:
- Inombolo (ikheli leseli eliqukethe isici esingafanele sinqunywe izinga);
- Izikhombo (izixhumanisi zobubanzi, isigaba esenziwa ngaphakathi);
- I-oda (ingxabano yokuzikhethela).
Ukufaka idatha emasimini kuyindlela efanayo ne-opharetha wangaphambilini. Ngemuva kokuthi zonke izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".
- Njengoba ungabona, ngemuva kokuthi izenzo zenzeke, umphumela wokubala uboniswe esitokisini esivezwe esigabeni sokuqala sale mfundiso. Isamba ngokwayo yindawo ephethe inani elithile phakathi kwamanye amanani ebanga. Ngokungafani nomphumela I-RANG.RVisifinyezo somqhubi RANG.SR ingaba nenani elincane.
- Njengokwesimo sefomu langaphambilini, ngokushintsha izixhumanisi ukusuka ekuhambelaneni nomaka ogqamile nokugqamisa, ungafaka lonke uhla lwemininingwane ngokuzenzakalela. I-algorithm yesenzo ifana ncamashi.
Isifundo: Ezinye imisebenzi zezibalo ku-Microsoft Excel
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Njengoba ubona, ku-Excel kunemisebenzi emibili yokunquma isimo senani elithile ebangeni ledatha: I-RANG.RV futhi RANG.SR. Izinguqulo ezindala zalolu hlelo, sebenzisa opharetha Isibalookuyinto, eqinisweni, i-analogue ephelele yomsebenzi I-RANG.RV. Umehluko omkhulu phakathi kwamafomula I-RANG.RV futhi RANG.SR iqukethe ukuthi owokuqala wabo ubonisa izinga eliphakeme uma amanani ahambisana, futhi okwesibili kubonisa isibalo esiphezulu ngesimo seqhezu yedesimali. Lona kuphela umehluko ophakathi kwalaba baqhubi, kodwa kufanele ucatshangelwe uma ukhetha umsebenzi othile umsebenzisi okufanele asebenzise.
