Excel Clunk

Mukamagwira ntchito ndi deta, nthawi zambiri zimabwera chifukwa chofuna kudziwa malo ati omwe amatenga mndandanda wazomwe zimachitika. M'magawo, izi zimatchedwa kuti. Excel ali ndi zida zomwe zimalola ogwiritsa ntchito mwachangu komanso kupanga njirayi mosavuta. Tiyeni tiwone momwe mungagwiritsire ntchito.

Ntchito Zogwirira Ntchito

Chifukwa cha kuchuluka kwa Excel, ntchito zapadera zimaperekedwa. Mu mabaibulo akale a pulogalamuyi panali wothandizira wopangidwa kuti athetse ntchitoyi - udindo. Pazolinga zowunikira, imasiyidwa mu magawo osiyanasiyana a pulogalamuyi, koma ndizofunikirabe kugwira ntchito ndi analogues atsopano ngati pali mwayi wotere. Izi zimaphatikizapo ogwiritsa ntchito owerengera rang.rv ndi rang.sr. Tikambirana za kusiyana ndi algorithm ntchito nawo.

Njira 1: Rung.RV Ntchito

Ogwiritsa ntchito rang.rv amatulutsa deta ndikuwonetsa kuchuluka kwa mkangano womwe watchulidwa ku selo lotchulidwa kuchokera ku mndandanda wa cudutititi. Ngati mfundo zingapo zimakhala ndi mulingo womwewo, wothandizirayo amawonetsa apamwamba kwambiri. Mwachitsanzo, ngati pali mfundo ziwiri zomwe zingakhale ndi phindu lomweli ndi nambala yachiwiri, ndipo mtengo wa mtengo wake udzakhala ndi wachinayi. Mwa njira, udindo wa ogwiritsira ntchito mu matembenuzidwe a Excel ndi wofanana kwambiri, kotero kuti ntchito izi zitha kuwonedwa zofanana.

Syntax ya wogwiritsa ntchitoyu adalembedwa motere:

= Rank.RV (nambala; Refle; [dongosolo])

Zotsutsana "Nambala" ndi "Reference" ndizovomerezeka, ndipo "dongosolo" ndilosankha. Monga kutsutsana "nambala yakuti muyenera kulowa ulalo wa selo pomwe mtengo uli ndi kuchuluka komwe muyenera kudziwa. Mtsutsowu uli ndi adilesi ya onse omwe ali nawo. Mfundo yolamula "ikhoza kukhala ndi matanthauzo awiri -" 0 "ndi" 1 ". Poyamba, kuwerengetsa dongosolo kukutsika, ndipo wachiwiri - pakukula. Ngati mkanganowu sunafotokozedwe, umawoneka kuti ndi zero.

Njira iyi imatha kulembedwa pamanja, m'chipinda chomwe mukufuna kuwonetsa zotsatira, koma kwa ogwiritsa ntchito ambiri ndizothandiza kukhazikitsa ntchito za Wizard pazenera la Wizard.

1. Timagawa khungu papepala lomwe zotsatirapo zokonza deta zidzawonetsedwa. Dinani batani "Ikani ntchito". Amangomangitsidwa kumanzere kwa chingwe.
2. Zochita izi zimabweretsa kuti ntchito zaphokosozi ziyambike. Ili ndi zonse (kwa osowa) ogwiritsa ntchito omwe angagwiritsidwe ntchito pazifukwa zopambana. Mu gulu la "Statistical" kapena "mndandanda wathunthu"



3. Pambuyo pa zomwe tafotokozazi, malingaliro a ntchito azikhala. Mu "nambala ya", Lowani adilesi ya foni, zomwe mukufuna. Izi zitha kuchitika pamanja, koma ndizovuta kwambiri kuchita momwe zikafotokozeredwa pansipa. Timakhazikitsa cholozera m'munda wa "nambala ya", kenako sankhani foni yomwe mukufuna.

   Pambuyo pake, adilesi yake idzalembedwa m'munda. Momwemonso, timalowetsa deta ndi ulalo "ulalo" wokha pokhapokha pogawa gawo lonse, momwe mungagwiritsidwe ntchito.

   Ngati mukufuna kuti munthu wina abwere kuchokera kuzowonjezera mpaka, ndiye kuti mumunda wa "Worder" uyenera kukhazikitsidwa "1". Ngati kuli kofunikira kuti lamuloli ligawidwa kuchokera kwa ocheperako (pafupifupi angapo milandu) ndikofunikira kuti ndikofunikira), ndiye gawo ili limasiyidwa.

   Pambuyo pazomwe zili pamwambapa zimapangidwa, kanikizani batani la "OK".



4. Pambuyo pochita izi mu selo lotchulidwa kale, nambala yotsatizana idzawonetsedwa, yomwe ili ndi mtengo wosankha pakati pa mndandanda wonse wa deta.

   

   Ngati mukufuna kuyendetsa malo onse otchulidwa, simuyenera kulowa njira ina ya chizindikiro chilichonse. Choyamba, timapanga adilesi mu gawo la "ulalo". Lisanalandire phindu lililonse, onjezani chizindikiro cha dollar ($). Nthawi yomweyo, kusintha mfundo mu gawo la "nambala ya" kwa "palibe kanthu sikuyenera, apo ayi formula idzawerengedwa molakwika.

   

   Pambuyo pake, muyenera kukhazikitsa cholozera m'munsi mwa khomo lakumanja la cell, ndikudikirira kuwonekera kwa cholembera mu mawonekedwe a mtanda waung'ono. Kenako kwezani batani lamanzere la mbewa ndikutulutsa chizindikiro chofanana ndi malo owerengedwa.

   

   Monga tikuwona, motero, njirayi idzakopedwa, ndipo malowo adzatulutsidwa pazambiri za data.

Phunziro: Mzere wa Wizard mu Excel

Phunziro: Maulalo ndi ogwirizana ndi ogwirizana

Njira 2: Ntchito Yogwira Ntchito.Sr

Ntchito yachiwiri yomwe imapanga ntchito yopanga bwino kwambiri .Sr. Mosiyana ndi ntchito za udindo ndi maudindo, ndi machesi a zinthu zingapo, ogwiritsa ntchitoyu amapereka gawo lalikulu. Ndiye kuti, ngati mfundo ziwiri zimakhala ndi phindu lililonse ndikutsatira mtengo woyamba 1, ndiye onse awiri adzapatsidwa nambala 2.5.

Syntax udindo. SR ndi yofanana kwambiri ndi chithunzi cha wogwiritsa ntchito kale. Amawoneka ngati awa:

= Rank.Sr (nambala; Refle; [dongosolo])

Fomuyi imatha kulowa pamanja kapena kudzera mu ntchito mbuye. Mu mtundu womaliza tiyimilira kwambiri ndikukhala.

1. Timapanga kusankha kwa selo pa pepalalo kuti litulutse zotsatira zake. Momwemonso, monga kale, pitani ku ntchito za Wizard kudzera batani la "ikani ntchito".
2. Mukatsegula zenera la wizzard, timagawa dzina la "dzina la" Maphunziro "", ndikusindikiza batani la "Ok".



3. Windo la kukangana limayambitsidwa. Zotsutsana za wothandizirayu ndi zofanana ndi ntchitoyi rang.rv:
   • Nambala (adilesi ya foni yomwe ili ndi gawo lomwe mulingo womwe uyenera kutsimikiziridwa);
   • Reference (magwiridwe antchito, ogwirira ntchito mkati omwe amachitidwa);
   • Dongosolo (mkangano wosankha).

   Kupanga deta m'munda kumachitika chimodzimodzi monga momwe muliri kale. Zikhazikiko zonse zimapangidwa, dinani batani la "OK".



4. Monga tikuonera, pambuyo pa ntchito zomalizidwa, zotsatira za kuwerengedwa zidawonetsedwa m'ndende m'ndime yoyamba yamgwirizanowu. Zotsatira zake zokha ndi malo omwe amakhala kufunika kwazinthu zina zamitundu. Mosiyana ndi zotsatira zake, rang.rv, zotsatira za udindo wa ogwiritsa ntchito. Cer akhoza kukhala ndi mtengo wochepa.



5. Monga njira yapitayo, posintha maulalo kuchokera kwa wachibale ndi chikhomo, zingapo za data zimatha kuthamangitsidwa ndi auto. Algorithm ya kuchitapo chimodzimodzi.

Phunziro: Ntchito zina zowerengera mu Microsoft Excel

Phunziro: Momwe mungapangire kuzengereza

Monga mukuwonera, pali ntchito ziwiri zokhazokha kuti mudziwe zomwe zili ndi mtengo wapadera mu mtundu wa data: ranks ndi bank.s. Kwa okalamba pulogalamuyi, wogwiritsa ntchito rank amagwiritsidwa ntchito, yomwe ndiyomwe ndiyofananira ndi njira yathunthu ya rang.rv Kusiyanitsa kwakukulu pakati pa formula rang.rv ndi bank.sras ndikuti woyamba wa iwo akuwonetsa pamlingo wapamwamba kwambiri ndi zomwe zachitika, ndipo chachiwiri chikuwonetsa pafupifupi gawo la kachigawo kakang'ono. Uwu ndiye kusiyana kokha pakati pa ogwiritsa ntchito awa, koma ayenera kuthandizidwa mukamasankha ndendende yomwe wogwiritsa ntchitoyo ndi wabwino kugwiritsa ntchito.