I-Excel Rakiking

Xa usebenza nedatha, ihlala iphakamisa isidingo sokufumanisa ukuba yeyiphi indawo ethathayo kuluhlu lwe-aggretate yesalathiso esinye okanye esinye. Kwiinkcukacha-manani, oku kubizwa ngokuba se-prikiki. I-Excel inezixhobo ezivumela abasebenzisi ngokukhawuleza kwaye bavelise ngokulula le nkqubo. Masifumanise ukuba ungazisebenzisa njani.

Imisebenzi yenqanaba

Kwinqanaba le-Excel, imisebenzi ekhethekileyo ibonelelwe. Kwiinguqulelo ezindala zesicelo apho kukho umqhubi omnye oyilelwe ukusombulula lo msebenzi. Ngenjongo yokusebenza, ishiywe kudidi olwahlukileyo lwefomula kwaye kwiinguqulelo zale mihla zeNkqubo, kodwa ihleli inqweneleka ukusebenza nge-analogue entsha ukuba kukho ithuba elinjalo. Oku kubandakanya abaqhubi beenkcukacha-manani rang.rv kunye ne-rang.sr. Siza kuthetha ngeyantlukwano kunye ne-algorithm yomsebenzi kunye nabo.

Indlela yoku-1: Rang.rv Umsebenzi

I-Operator Rang.rv ivelisa ukulungisa idatha kwaye ibonisa inani lempikiswano echaziweyo kwiseli echaziweyo kuluhlu olucwangcisiweyo. Ukuba amaxabiso amaninzi anenqanaba elifanayo, umqhubi ubonakalisa eyona iphakamileyo yoluhlu lwamaxabiso. Ukuba, umzekelo, amaxabiso amabini aya kuba nexabiso elifanayo, zombini ziya kwabelwa inani lesibini, kwaye ixabiso lexabiso liya kuba nelinye lesine. Ngendlela, inqanaba lomqhubi kwiinguqulelo ezindala ze-Excel ifana ngokupheleleyo, ukuze le misebenzi inokuthathwa njengento efanayo.

I-syntax yale phucuko ibhaliwe ngolu hlobo lulandelayo:

= Isikhundla.RV (inombolo; [iodolo])

Impikiswano "inombolo" kunye "nereferensi" zinyanzelekile, kwaye "oda" kukuzikhethela. Njengempikiswano "inombolo" ofuna ukufaka ikhonkco kwiseli apho ixabiso liqulathe inani lento ekufuneka uyazi. "Isalathiso" impikiswano iqulethe idilesi yoluhlu lonke olubandakanyiweyo. "I-odolo" impikiswano inokuba neentsingiselo ezimbini - "0" kunye "1". Kwimeko yokuqala, ukubala komyalelo kuyahla, kwaye okwesibini - ngokwanda. Ukuba le mpikiswano ayichazwanga, ithathelwa ingqalelo ngokuzenzekelayo njenge-zero.

Le fomula ingabhalwa ngesandla, kwiseli apho ufuna ukubonisa iziphumo, kodwa kubasebenzisi abaninzi kuya kuba lula ukumisela i-wizard ye-Wizard kwiwindows.

1. Sabela iseli ephepheni apho iziphumo zokulungisa idatha ziya kubonakala khona. Cofa kwiqhosha "Cola umsebenzi". Kukwenziwe ngasekhohlo kwe-formula yomtya.
2. Ezi zenzo zikhokelela kwinto yokuba imisebenzi yeWizard yeWizard iqala. Iqulethe zonke (zezinto ezinqabileyo) Abaqhubi abanokusetyenziselwa ukwenza iifomula ze-Excel. Kwinqanaba "le-staistical" okanye "i-alfabhethi ogcweleyo" sifumana igama "i-rang.rv", siyayibalisa kwaye ucofe iqhosha u "Kulungile".



3. Emva kwento engentla, impikiswano yomsebenzi iya kusebenza. Kwintsimi "yenombolo", faka idilesi yeso siseli, idatha ofuna ukuyibala. Oku kungenziwa ngesandla, kodwa kufanelekile ukwenza ngendlela eya kuxutyushwa ngezantsi. Sisolula isikhombisi kwintsimi "yenombolo", kwaye emva koko ukhethe nje iseli efunekayo kwiphepha.

   Emva koko, idilesi yayo iya kudweliswa ebaleni. Ngendlela efanayo, sifaka idatha nakwikhonkco "kuphela", kule meko yalwa la luhlu lonke, apho kwenzeka khona inqanaba.

   Ukuba ufuna ukuba isikhundla sivela ngaphantsi, emva koko "kwintsimi ethi" oda "kufuneka isekelwe" 1 ". Ukuba kuyimfuneko ukuba iodolo isasazwe ukusuka kuncinci ukuya kuncinci (kwaye kwinani eliphezulu lamatyala ayimfuneko ukuba iyimfuneko), emva koko le ntsimi ishiywe ingenanto.

   Emva kwayo yonke le datha ingentla yenziwa, cinezela iqhosha u "Kulungile".



4. Emva kokwenza le ntshukumo kwiseli echazwe kwangaphambili, inani elilandelelaneyo liya kuboniswa, elinexabiso lokhetho lwakho phakathi koluhlu lonke lwedatha.

   

   Ukuba unqwenela ukuqhuba yonke indawo echaziweyo, akukho mfuneko yokuba ufake ifomula eyahlukileyo kwisalathiso ngasinye. Okokuqala, senza idilesi kwindawo "yekhonkco". Phambi kwexabiso ngalinye elilungelelanisiweyo, yongeza uphawu lwedola ($). Kwangelo xesha, ukutshintsha amaxabiso "kwinombolo" ye "nenani", kungenjalo ukuba ifomula ingabalwa ngokungachanekanga.

   

   Emva koko, kufuneka ufake isikhombisi kwikona esezantsi ngasekunene kwiseli, kwaye ulinde ukubonakala kwesiphawuli sokuzalisa ngohlobo lomnqamlezo omncinci. Emva koko ikhupha iqhosha lemouse lasekhohlo kwaye yolule imakisha efanayo kwindawo ebaliwe.

   

   Njengoko sibona, ngaloo ndlela, kuya kuveliswa ifomula, kwaye isikhundla siya kuveliswa kulo lonke uluhlu lwedatha.

Isifundo: I-Wizard imisebenzi kwi-Excel

Isifundo: Ngokupheleleyo kunye nezihlobo zokudibanisa

Indlela 2: Umsebenzi Rank.Srr

Umsebenzi wesibini ovelisa ukusebenza kwenqanaba le-Presele yi-rank.Sr. Ngokuchasene nemisebenzi yenqanaba kunye nenqanaba.RV, kunye nematshisi yeenqobo zexabiso lezinto ezininzi, lo mnxibelelanisi uphakamisa inqanaba. Oko kukuthi, ukuba amaxabiso amabini anexabiso elilinganayo kwaye alandele emva kwexabiso kwinombolo 1, emva koko iya kwabelwa inombolo ye-25.

Inqanaba le-syntax. I-SR ifana kakhulu nomzobo womsebenzi wangaphambili. Ujongeka ngoluhlobo:

= Rank.Srr (inombolo; [iodolo])

Ifomula inokungeniswa ngesandla okanye kwi-Master imisebenzi. Kwinguqulo yokugqibela siya kuyeka ngaphezulu kwaye sihlale.

1. Sivelisa ukukhetha kweseli kwiphepha lokukhupha iziphumo. Ngendlela efanayo, njengakwixesha elidlulileyo, yiya kwi-wizard ye-wizard "ye-fasa umsebenzi".
2. Emva kokuvula iwindow yewindows, sibela igama legama "lenkcukacha-manani" ", kwaye cinezela iqhosha u" Kulungile.



3. Iwindow yempikiswano ivuliwe. Impikiswano yalo msebenzi ifana ngqo nomsebenzi rang.rv:
   • Inombolo (idilesi yeseli equkethe inqaku elifanele limiselwe inqanaba);
   • Isalathiso (uluhlu lokunxibelelanisa, ukupakisha ngaphakathi);
   • I-odolo (impikiswano oyifunayo).

   Ukwenza idatha kwintsimi yenzeka ngokuchanekileyo kanye kwi-operator yangaphambili. Emva kokuba zonke izicwangciso zenziwe, cofa kwiqhosha "Kulungile".



4. Njengoko sibona, emva kwezenzo ezigqityiweyo, iziphumo zokubala zaboniswa kwiseli ephawulwe kwisiqendu sokuqala salo myalelo. Isiphumo ngokwaso siyindawo yokuhlala ixabiso elithile phakathi kwezinye izinto zoluhlu. Ngokuchasene nesiphumo, i-Rang.rv, isiphumo senqanaba lomqhubi. I-CER inokuba nexabiso elibonisa ukuba lixabiso.



5. Njengakwifomula yangaphambili, ngokutshintsha amakhonkco kwisalamane kwi-oright kunye nemarike, lonke uluhlu lwedatha lunokuqhutywa ngokuzenzekelayo. I-algorithm yesenzo iyafana.

Isifundo: Eminye imisebenzi yeenkcukacha-manani kwiMicrosoft Excel

Isifundo: Ungazalisa njani ngokuzenzekelayo kwi-Excel

Njengoko ubona, kukho imisebenzi emibini kwi-Excel ukumisela ixabiso elithile kuluhlu lwedatha: I-Rang.rv kunye neRank.s. Kwiinguqulelo ezindala zenkqubo, ukusetyenziswa komsebenzi wenqanaba esetyenziswayo, eyinto eyimfuneko ye-analogue epheleleyo yomsebenzi we-rang.rv Umahluko ophambili phakathi kwefomula rang.rv kunye ne-rank.sras kukuba owokuqala kubo ubonakalisa elona nqanaba liphezulu ngokuhambelana kwenxalenye yeqhezu le-decimal. Lo ngowona mahluko kuphela phakathi kwaba baqhubi, kodwa kufuneka kuthathelwe ingqalelo xa ukhetha ngqo umsebenzi ongcono onokuyisebenzisa.