Isimo se-Excel

Lapho usebenza ngedatha, kuvame ukuvela isidingo sokuthola ukuthi iyiphi indawo ethatha kuyo uhlu oluhlanganisiwe lwenkomba eyodwa noma enye inkomba. Kwezibalo, lokhu kubizwa ngokuthi isikhundla. I-Excel inamathuluzi avumela abasebenzisi ukuthi basheshe futhi bakhiqize kalula le nqubo. Ake sibheke ukuthi ungazisebenzisa kanjani.

Imisebenzi esezingeni

Okokuzinga ku-Excel, kunikezwe imisebenzi ekhethekile. Ezinguqulweni ezindala zesicelo kukhona opharetha oyedwa owenzelwe ukuxazulula lo msebenzi - isikhundla. Ngezinhloso zokuhambisana, kushiywe esigabeni esihlukile samafomula nangezinhlobo zanamuhla zohlelo, kepha kuyathandeka ukusebenza nge-analogues emisha uma kunethuba elinjalo. Lokhu kufaka phakathi opharetha bezibalo ku-rang.rv and rang.sr. Sizokhuluma ngomehluko kanye ne-algorithm yokusebenza nabo.

Indlela 1: Umsebenzi we-Rang.RV

I-Opharetha RAG.RV ikhiqiza ukucubungula idatha futhi ibonisa inombolo yokulandelana kwengxabano ecacisiwe kwiseli elibekiwe kusuka ohlwini olukhumulayo. Uma amanani amaningi anezinga elifanayo, opharetha ukhombisa okuphezulu kakhulu kohlu lwamanani. Uma, ngokwesibonelo, amanani amabili azoba nenani elifanayo, khona-ke bobabili bayokwabelwa inombolo yesibili, futhi inani lenani lizoba nelesine. By the way, i-opharetha izinguqulo ezindala ze-Excel iyafana ngokuphelele, ukuze le misebenzi icatshangwe njengento efana.

I-syntax yalolu hlelo lokusebenza ibhalwe kanjena:

= Isikhundla.rv (inombolo; ireferensi; [Order])

Izimpikiswano "inombolo" ne "ireferensi" ziyimpoqo, futhi "i-oda" kungakhethwa. Njengengxabano "inombolo" udinga ukufaka isixhumanisi esiya esitokisini lapho inani liqukethe inombolo yokulandelana kwayo okudingeka uyazi. Ingxabano ethi "Reference" iqukethe ikheli lonke elibalwa. Ukuphikisana kwe- "Order" kungaba nezincazelo ezimbili - "0" no "1". Esimweni sokuqala, ukubalwa kwe-oda kwehla, futhi kwesesibili - ngokwanda. Uma le ngxabano ingacaciswanga, kuthathwa ngokuzenzakalelayo ukuthi kube ngu-zero.

Le formula ingebhalwa ngesandla, esitokisini lapho ufuna ukukhombisa khona umphumela wokucubungula, kepha kubasebenzisi abaningi kulula ukusetha imisebenzi wizadi ewindows Wizard ewindini Wizard.

1. Sabela iseli eshidini lapho umphumela wokucubungula idatha uzokhonjiswa khona. Chofoza inkinobho ethi "Namathisela Umsebenzi". Kwenziwe kwasendaweni ngakwesobunxele sentambo yefomula.
2. Lezi zenzo ziholela eqinisweni lokuthi imisebenzi wizard wisard iqala. Kuqukethe konke (okungajwayelekile) Abasebenzisi abangasetshenziswa ukuhlanganisa amafomula ku-Excel. Esigabeni "sezibalo" noma "uhlu olugcwele lwezinhlamvu" Sithola igama elithi "rang.rv", siveza bese uqhafaza inkinobho ethi "KULUNGILE".



3. Ngemuva kwesenzo esingenhla, izimpikiswano zomsebenzi zizosebenza. In the "Numbe" field, faka ikheli lalelo seli, idatha lapho ufuna khona isikhundla. Lokhu kungenziwa ngesandla, kepha kulula kakhulu ukwenza ngendlela yokuthi kuzoxoxwa ngayo ngezansi. Sisungula ikhesa enkundleni ethi "Number", bese umane ukhethe iseli oyifunayo ephepheni.

   Ngemuva kwalokho, ikheli layo lizofakwa kuhlu ensimini. Ngendlela efanayo, sifaka imininingwane futhi kusixhumanisi "isixhumanisi", kuleli cala kuphela sabela lonke uhla, lapho kwenzeka khona.

   Uma ufuna ukubalwa kufike kusuka kokuningi kuya kokuningi ku-Kindle "Order" kufanele kusethwe "1". Uma kunesidingo ukuthi i-oda lisatshalaliswa kusuka kokukhulu kuya kokuncane (futhi ngenani elikhulu lamacala kuyadingeka ukuthi kuyadingeka), khona-ke le nkambu ishiywe ingenalutho.

   Ngemuva kwayo yonke imininingwane engenhla yenziwa, cindezela inkinobho ethi "KULUNGILE".



4. Ngemuva kokwenza lezi zenzo kwiseli elishiwo ngaphambili, inombolo yokulandelana izokhonjiswa, enobunikazi bokukhetha kwakho phakathi kohlu lonke lwedatha.

   

   Uma ufisa ukuqhuba yonke indawo ebekiwe, awudingi ukufaka ifomula ehlukile kwinkomba ngayinye. Okokuqala, senza ikheli lenkambu ye- "Link". Ngaphambi kwenani ngalinye lokuxhumanisa, engeza uphawu lwedola ($). Ngasikhathi sinye, ukushintsha amanani ensimini "yenombolo" ukuze ngokuphelele, akunakwenzeka, uma kungenjalo ifomula izobalwa ngokungalungile.

   

   Ngemuva kwalokho, udinga ukufaka isikhombisi ekhoneni elingezansi kwesokudla seseli, bese ulinda ukubonakala kophawu lokugcwaliswa ngesiphambano esincane. Bese ubopha inkinobho yegundane kwesobunxele bese welula umaki ngokufana nendawo ebaliwe.

   

   Njengoba sibona, ngale ndlela, indlela ozokopishwa, futhi izinga lizokhiqizwa kulo lonke uhla lwedatha.

Isifundo: Imisebenzi yeWizard ku-Excel

Isifundo: Izixhumanisi eziphelele nezihlobo ze-Excel

Indlela 2: Isikhundla somsebenzi.SR

Umsebenzi wesibili okhiqiza ukusebenza kwezikhundla ku-Efpelle.SR. Ngokungafani nemisebenzi yesikhundla nesikhundla.RV, nemidlalo yamanani ezinto eziningana, lo opharetha ukhipha izinga eliphakathi. Okungukuthi, uma amanani amabili anenani elilinganayo bese ulandela inani lenani elithi 1, bobabili bazobelwa inombolo engu-2,5.

Isikhundla se-Syntax. I-SR ifana kakhulu nomdwebo we-opharetha wangaphambilini. Kubukeka kanjena:

= Isikhundla.sr (inombolo; ireferensi; [Order])

Ifomula ingafakwa ngesandla noma ngokusebenzisa imisebenzi. Enguqulweni yokugcina sizovimba okuningi futhi sihlale.

1. Siveza ukukhetha kweseli eshidini ukuze kukhishwe umphumela. Ngendlela efanayo, njengasesikhathini esedlule, iya kwimisebenzi wizard ngenkinobho ethi "Faka umsebenzi".
2. Ngemuva kokuvula iwindi Wizard Wizard, sabela igama lesigaba esithi "Izibalo" Isigaba ", bese ucindezela inkinobho ethi" KULUNGILE ".



3. Iwindi lokuphikisana liyasebenza. Izimpikiswano zalolu hlelo lokusebenza zifana ncamashi nomsebenzi RAG.RV:
   • Inombolo (Ikheli Leseli eliqukethe into elokunqunywa);
   • Isethenjwa (izixhumanisi zangaphakathi, ezikhundleni ngaphakathi ezenziwa);
   • Oda (Ukuphikisana ngokuzithandela).

   Ukwenza idatha emkhakheni kwenzeka ngendlela efanayo naku-opharetha wangaphambilini. Ngemuva kwayo yonke izilungiselelo zenziwe, chofoza inkinobho ethi "Kulungile".



4. Njengoba sikwazi ukubona, ngemuva kwezenzo ezigcwalisiwe, umphumela wokubala waboniswa esitokisini esimakwe esigabeni sokuqala salo myalelo. Umphumela uqobo uyindawo ethatha inani elithile phakathi kwamanye amanani webanga. Ngokungafani nomphumela, i-rang.rv, umphumela we-opharetha isikhundla. I-CER ingaba nenani elihlanganayo.



5. Njengasefomula yangaphambilini, ngokushintsha izixhumanisi ezivela kusihlobo esiphelele nangokumaka, lonke uhla lwedatha lungaqhutshwa ngokuzenzakalela. I-algorithm yesenzo iyafana.

Isifundo: Eminye imisebenzi yezibalo ku-Microsoft Excel

Isifundo: Kanjani ukugcwalisa ngokuzenzakalela ku-Excel

Njengoba ubona, kunemisebenzi emibili ku-Excel ukuthola isikhundla senani elithile kububanzi bedatha: Rang.rv kanye nesikhundla.S. Okwezinhlobo ezindala zohlelo, kusetshenziswa i-opharetha yezikhundla, empeleni okuyi-analogue ephelele yomsebenzi we-rang.rv Umehluko omkhulu phakathi kwefomula rang.rv kanye ne-ren.Sras ukuthi eyokuqala yazo ikhombisa izinga eliphakeme kakhulu ngokuhlangana kwamanani, kanti okwesibili kukhombisa isilinganiso ngesilinganiso sengxenye yengxenye yengxenye yedesimali. Lona kuphela umehluko phakathi kwalaba basebenzi, kepha kufanele kubhekwe lapho ukhetha ngqo ukuthi yimuphi umsebenzi umsebenzisi ongcono awusebenzisa.