ZVAKARURAMA muExcel. Formula uye kushandiswa kweRIGHT basa muExcel

Iyo Excel izwi processor ine akawanda maoperator ayo anotendera iwe kuti ushandise ruzivo rwemavara. Basa reRIGHT rinotora kukosha kwenhamba kubva pasero rakapihwa. Muchinyorwa ichi, tichadzidza zvakadzama maitiro eiyo opareta, uye zvakare, tichishandisa mimwe mienzaniso, tichawana ese maficha ebasa.

Zvinangwa uye zvinangwa zveRIGHT mushandisi

Chinangwa chikuru cheRUDZO ndechekutora nhamba yakatarwa yemavara kubva musero rakapihwa. Kubvisa kunotanga kubva kumagumo (kurudyi). Mhedzisiro yeshanduko inoratidzwa musero yakasarudzwa pakutanga, umo fomu uye basa racho pacharo rinowedzerwa. Iri basa rinoshandiswa kugadzirisa ruzivo rwemavara. KURUDHI kuri muchikamu cheMashoko.

Tsanangudzo yeRIGHT opareta muExcel spreadsheet

Maonero ese emushandisi: =KURUDZA(mavara,nhamba_ye_mavara). Ngatitarisei nharo imwe neimwe:

• 1st nharo - "Chinyorwa". Ichi ndicho chiratidzo chekutanga icho mavara anozopedzisira aburitswa. Kukosha kunogona kuva chinyorwa chakananga (ipapo kutorwa kubva murugwaro kuchaitwa uchifunga nezvenhamba yakatsanangurwa yemavara) kana kero yesero iyo iyo yekubvisa pachayo ichaitwa.
• 2nd nharo - "Nhamba_ye_characters". Izvi zvinotsanangura kuti mabhii mangani achatorwa kubva pamutengo wakasarudzwa. Nharo inotsanangurwa senhamba.

Teerera! Kana nharo iyi isina kuzadzwa mukati, ipapo sero inoratidzwa mhedzisiro icharatidza iyo yega yekupedzisira mavara kurudyi rwemashoko akapihwa nharo. Nemamwe manzwi, sekunge takapinda chikamu mundima iyi.

Kushandisa RIGHT Operator kune Yakananga Muenzaniso

Pane mumwe muenzaniso, ngatifungei nezve mashandisirwo eRIGHT mushandisi kuti tizive maficha ayo zviri nani. Semuenzaniso, tine ndiro inoratidza kutengesa sneakers. Muchikamu chekutanga, mazita anopiwa nechiratidzo chehukuru. Basa ndere kuburitsa zviyero izvi mune imwe mbiru.

Kufamba:

1. Pakutanga, isu tinofanirwa kugadzira mutsara umo ruzivo rwunozopedzisira rwaburitswa. Ngatipei zita - "Size".

2. Fambisa chinongedzo ku1st cell yekoramu, uchiuya mushure mezita, uye sarudza nekudzvanya LMB. Dzvanya pane "Insert Function" chinhu.

3. Iyo Insert Function hwindo inoonekwa pachiratidziri. Isu tinowana kunyorwa kwe "Category:" uye vhura iyo rondedzero padhuze ichi chinyorwa. Muchinyorwa chinovhurwa, tsvaga chinhu "Chinyorwa" uye tinya pairi LMB.

4. Muhwindo "Sarudza basa:" vese vanogona mameseji vashandisi vakaratidzwa. Isu tinowana basa "RIGHT" uye tinosarudza nerubatsiro rweLMB. Mushure mekuita zvese manipulations, tinya bhatani "OK".

5. Iwindo re "Function Arguments" rakaonekwa pachiratidziro nemitsara miviri isina chinhu. Mumutsara we "Text" unofanirwa kuisa marongero e1st cell yekoramu "Zita". Mumuenzaniso wedu chaiwo, iyi sero A2. Iwe unogona kuita iyi nzira iwe pachako nekuipinda nemaoko kana nekutaura kero yesero. Dzvanya pamutsara weiyo seti yezvinokosha, wobva wadzvanya LMB pane sero yaunoda. Mumutsara we "Nhamba ye_character" tinoisa nhamba yezvinyorwa mu "Size". Mumuenzaniso uyu, iyi ndiyo nhamba 9, sezvo zviyero zviri kumagumo emunda uye zvine mavara mapfumbamwe. Zvakakosha kuziva kuti "nzvimbo" chiratidzo zvakare. pashure kuurayiwa zvose Action tinodzvanya «Zvakanaka ”.

6. Mushure mekuita zvese manipulations, unofanirwa kudzvanya bhatani rekuti "Enter".

Zvinokosha! Iwe unogona kunyora formula yeanoshanda iwe pachako nekufambisa chinongedzo kune yaunoda sero uye nekutsanangura kukosha: =KURUDZWA(A2).

7. Somugumisiro wekushandiswa kunoitwa, ukuru hwema sneakers hucharatidzwa musero rakasarudzwa, umo takawedzera mushandisi.

8. Tevere, iwe unofanirwa kuve nechokwadi chekuti mushandisi anoshandiswa kune imwe neimwe sero ye "Size" column. Fambisa chinongedzo chembeva kukona yezasi yekurudyi neiyo yakapinda formula kukosha. Iyo cursor inofanira kutora chimiro chediki dema plus chiratidzo. Bata LMB uye fambisa chinongedzo kuzasi chaiko. Mushure mokunge tasarudza yose inodiwa chiyero, sunungura bhatani.

9. Pakupedzisira, mitsetse yose ye "Size" column ichazadzwa neruzivo kubva ku "Zita" column (yekutanga mavara mapfumbamwe anoratidzwa).

10. Uyezve, kana iwe ukadzima kukosha nehukuru kubva pa "Zita" column, ivo vanozobviswawo kubva ku "Size" column. Izvi zvinodaro nekuti makoramu maviri aya akabatana. Tinofanira kubvisa chinongedzo ichi kuitira kuti zvive nyore kwatiri kushanda neruzivo rwetabular. Isu tinosarudza maseru ese e "Size" column, uye ipapo tinya kuruboshwe pane "Copy" icon iri mu "Clipboard" block ye "Home" chikamu. Imwe mutsauko wemaitiro ekukopa ndiyo nzira yekudimbudzira yekhibhodi "Ctrl + C". Yechitatu sarudzo ndeye kushandisa menyu yemukati, iyo inodanwa nekudzvanya-kurudyi pane sero mune yakasarudzwa.

11. Padanho rinotevera, tinya-kurudyi pane 1st cell yenzvimbo yakambotarwa, uyezve mune yemukati menyu tinowana iyo "Namira Sarudzo" block. Pano tinosarudza chinhu "Values".

12. Nekuda kweizvozvo, ruzivo rwese rwakaiswa muchikamu che "Size" rwakave rwakazvimirira uye rusina hukama ne "Zita" column. Iye zvino unogona kugadzirisa nekudzima zvakachengeteka mumaseru akasiyana pasina njodzi yekuchinja kwedata mune imwe column.

Mhedziso uye mhedziso pane RIGHT basa

Iyo spreadsheet Excel ine nhamba hombe yemabasa ayo anobvumidza iwe kuti uite akasiyana mamanipulations ane zvinyorwa, nhamba uye graphic ruzivo. Iyo RIGHT mushandisi inobatsira vashandisi kuderedza zvakanyanya nguva yekushandisa kutora mavara kubva kune imwe koramu kuenda kune imwe. Basa racho rakanakisisa pakushanda nehuwandu hwemashoko, sezvo inokubvumira kubvisa kufungidzira kwenhamba yakawanda yezvikanganiso.