Maitiro ekuverenga huwandu hwetsika muExcel ikholmn. 6 Nzira dzekuverenga huwandu hwehuwandu hwezvikamu zviri muEKStel column

Kazhinji, pamberi pevashandisi vepepeti yetafura, mubvunzo unomuka zvinoenderana nekuverenga huwandu hwechiratidzo muColumn. Mune mamwe mazwi, zvinodikanwa kuti uverenge nhamba yeminda mukoramu yakazadzwa neruzivo rwechokwadi kana ruzivo rwehuwandu. Mugadziri wetafura ane mimwe misiyano yakawanda inobvumidza iwe kuti uite chinhu ichi.

Maitiro ekuverenga muColumn

Zvichienderana nezvinangwa zvemushandisi mumupepeti wetafura, unogona kuita kuverenga kweiyo data rese muColumn. Isu tichaongorora imwe neimwe nzira mune zvimwe zvakadzama.

Nzira 1: Inoratidza huwandu hwehuwandu mune chimiro chebhari

Iyi nzira ndiyo iri nyore kushandisa. Iyo inoshandisa kuverenga nhamba uye zvinyorwa zvemavara, asi hazvigone kushandiswa kana uchishanda nemamiriro ezvinhu. Chiitiko chakawanda algorithm:

1. Sarudza nzvimbo inodiwa data.
2. Isu tinotarisa mumutsara wenyika.
3. Isu tinodzidza huwandu hwetsika.

Poshi

Nzira yacho iri nyore kushandisa chete kana ichishanda neavhareji data mavhoriyamu, zvimwe iwe unofanirwa kushandisa dzimwe sarudzo. Imwe minus yenzira - iyo mhedzisiro inoonekwa chete panguva yekuzviparadzanisa nevamwe, saka iwe unofanirwa kubviswa kana kuyedzwa kana kugadziriswa kumwewo. Nhanho-ne-nhanho gwara rekubatanidza iyo "nhamba" chiratidzo:

1. Dzvanya PCM pane iyo Status Bar.
2. Iyo skrini inoratidza rondedzero. Hezvino zvinodikanwa kuti utarise kana mucherechedzo uri pamusoro pe "huwandu" paramende. Kana zvisiri, saka inofanira kuiswa nekudzvanya pane bhatani rekuruboshwe bhatani.

2.

1. Kugadzirira! Zvino "nhamba" chiratidzo chiri mune chimiro bar yetafura processor.

Nzira yechipiri: Kushandiswa kweRC Basa

Iyi inoshanda inoshandisa chinhu chimwe chete nenzira yakapfuura, asi panguva imwe chete inogadzirisa mhedzisiro yacho. Zvimwe zvikanganiso zvinosara, sezvo basa renyama harigone kushanda nemamiriro ezvinhu.

Kune marudzi maviri akajairika emushandi:

1. = Bar (marekodhi1; mitezo2; ... Sero).
2. = Maruva (cell1: cell).

Mune 1st fomu, anoshanda anoverengera imwe neimwe yakasarudzwa sero rakasarudzwa. Mune fomu yechipiri, nhamba yehuwandu hwakazadzwa inoverengwa mune iyo huwandu kubva kuCell nhamba 1 kusvika kuCell neNhamba N. Nhanho yeNhanho Nhanho:

1. Isu tinoburitsa kusarudzwa kwechitokisi umo kuverenga kuchiratidzwa.
2. Kufamba mune iyo Subsection "mafomu". Dzvanya "Isa basa."

3.

1. Imwe nzira sarudzo - kudzvanya iyo "Insert basa" icon, iyo iri padyo nemutsara weiyo seti yeiyo mafomula.

ina

1. Zvishoma zvidiki "zvinoisa mabasa" akaonekwa pachiratidziri. Vhura rondedzero iri padyo ne "chikamu" chakanyorwa. Mune iyo yakabviswa rondedzero, sarudza iyo "nhamba" chinhu. Mu "sarudza basa:" Munda, tinowana anoshanda weinvoice uye tinya pairi neiyo lkm. Mushure mekunyengedza kwese, tinya pane "ok" chinhu.

shanu

1. Iyo inoratidzira inoratidza hwindo kuti unyore operator nharo. Hezvino Izvo zvinodikanwa nekuendesa masero kana iyo yekuisa huwandu kuti uise nharo. Izvo zvakakosha kucherechedza kuti huwandu hunogona kuiswa nemusoro. Mushure mezvose zvekunyengedza, tinya pane "ok" element, iri pazasi pewindo.

6.

1. Kugadzirira! Nekuda kweizvozvo, takagamuchira mhedzisiro yekuverenga muchitokisi chakatemerwa. Izvo zvakafunga nezvechokwadi chega chechitokisi chakazadzwa.

7 nzira 3: Kushandisa iyo account account

Iyo account yakanakira kushanda neyenzi zviratidzo. Kune marudzi maviri akajairika emushandi:

1. = Account (masaga1; mitezo2; ... Sero).
2. = Account (mell1: Cell).

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa kusarudzwa kwechitokisi umo kuverenga kuchiratidzwa.
2. Kufamba mune iyo Subsection "mafomu". Dzvanya pane "isa basa" chinhu. Iyo skrini inoratidza iwindo diki inonzi "basa isa". Ratidza rondedzero iri padyo ne "chikamu" chakanyorwa. Mune iyo yakabviswa rondedzero, sarudza iyo "nhamba" chinhu. Mu "Sarudza basa:" Munda, tinowana iyo account account uye tinya pairi neLKM. Mushure mekunyengedza kwese, tinya pane "ok" chinhu.

sere

1. Hwindo rekupokana kuzadza marongero emasero anodiwa. Mushure mezvose zvekunyengedza, tinya pane "ok" element, iri pazasi pewindo.

pfumbamwe

1. Kugadzirira! Nekuda kweizvozvo, takagamuchira mhedzisiro yekuverenga muchitokisi chakatemerwa. Heano anofanirwa kuve neakafanirwa neakazadzwa maseru, kunze kwekusina chinhu uye izvo izvo ruzivo rwunowanikwa rugwaro ruri.

10 Maitiro 4: Operator 8

Iyi inoshanda inokubvumira kuti uverenge nhamba yezvinhu zvemamiriro ezvinhu chaiwo. Kuonekwa kwakawanda kweanoshanda: = 8 (huwandu; maitiro).

1. Range - Izvi zvinoratidza nzvimbo iyo iyo inodiwa kuti uverenge nhamba yeCoincidles pane yakatarwa mamiriro.
2. Chiitiko ichi chimiro chekuti ndeapi kubatana kuchaiswa.

Tichaongorora zvese zvakafanana muenzaniso. Nhanho-BY-STEPT NGUVA:

1. Semuenzaniso, isu tichaona huwandu hweshoko rinoti "kumhanya" mukoramu nemitambo. Kufamba mumunda umo iwe urikuzoratidza mhedzisiro yacho.
2. Kufamba mune iyo Subsection "mafomu". Dzvanya pane "isa basa" chinhu. Iyo skrini inoratidza iwindo diki inonzi "basa isa". Ratidza rondedzero iri padyo neyakanyorwa "chikamu:". Mune iyo yakabviswa rondedzero, sarudza iyo "nhamba" chinhu. Mu "Sarudza basa:" Munda, tinowana anoshanda uye tinya pairi neLKM. Mushure mekunyengedza kwese, tinya pane "ok" chinhu.

gumi neimwe

1. Iyo skrini inooneka "basa rekuita" hwindo. Mumutsara wakasiyana, isu tinosuma marongero emasero anotora chikamu mukuverenga. Mumutsetse "chinongedzo" tinobvunza mamiriro acho pachacho. Kutyaira pano: "Mhanya". Mushure mekuita zvese manipupolations, tinya pane "ok" chinhu.

12

1. Anoshanda akaverengerwa uye akaratidzira huwandu hwezvibvumirano mumunda wakaratidzirwa neshoko rekuti "rune". Tine gumi nenhanhatu zvibodzwa.

13

Ngatiedzei kurongedza mamiriro ezvinhu kuti unzwisise zviri nani basa reanoshanda. Nhanho-BY-STEPT NGUVA:

1. Ngativei kuverenga mimwe tsika mune ino ikholamu, kunze kwe "kumhanya" kukosha.
2. Isu tinodzokorora iyo yechipiri pfungwa kubva kumurayiridzo pamusoro apa.
3. Mumutsara wakasiyana, isu tinopinda iyo kero imwechete semuenzaniso pamusoro. Mumutsetse "unoti" isu tinotyaira chiratidzo chekusaenzana "" "kukosha kwe" kumhanya ". Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

gumi neina

1. Semhedzisiro, takagamuchira nhamba yegumi nemanomwe - nhamba yemashoko ari mukamuri yakasarudzwa pasina kufunga nezve izwi rekuti "kumhanya".

Pakupera kwekufunga kwenzira, tinoona kuti Mushandi anoshanda sei nemamiriro ezvinhu umo mavara ">" uye "

1. Uchishandisa mirayiridzo yepamusoro, isa opareta kuti utarise chitokisi chakakodzera.
2. Mumutsara wakabuda, isu tinopinda izvo zvinodikanwa kuronga kwemasero emutauri. Mu "Contrion" mutsara, isa kukosha "> 350". Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

gumi neshanu

1. Nekuda kweizvozvo, takagamuchira kukosha kwegumi - huwandu hwehuwandu hwakakura kupfuura mazana matatu emuchadenga.

16 mienzaniso yekushandisa basa rekuita muExcel

Isu tichaongorora mumwe muenzaniso wekunzwisisa kwakazara kwebasa remushandi. Semuenzaniso, isu tine zvinotevera zvinotevera zvine ruzivo rwekutengesa:

17.

Chinangwa: Tsvaga kuti yakawanda sei yezvinhu zvinotengeswa zvigadzirwa kubva kuSamsung. Isu tinoshandisa iyo inotevera formula: = c3: C3: C3: "Samsung") / A17. Semhedzisiro, tinowana mhedzisiro ye40%:

18 zvinhu zvekushandisa basa rebasa racho muExcel

Taura nezve zvimwe zvinhu zveanoshanda:

• Iyo kunyoreswa kwezviratidzo hazvina basa kana mutsara wemhando yemhando yakatarwa sedanho;
• Mhedzisiro yekuverenga ichave zero kana iyo kutaurwa kweiyo isina chinhu sero kana mutsara usina chinhu uchaziviswa seyakaganhurirwa;
• Anoshanda anogona kuiswa semhando yerudzi rwezvirongwa, mune iyo nhamba yemasero neruzivo rwakaenderana nemamiriro ezvinhu akati wandei achaitika.

Nzira 5: Uchishandisa Mushandi ane 8 Operator

Mushandi anowanzofanana neiyo yakananga kune yakataurwa pamusoro basa. Izvo zvinosiyana mukuti zvinokutendera iwe kuwedzera imwe nhamba yemarangi ane akasiyana siyana kana akafanana mamiriro. Semuenzaniso, isu tinofanirwa kuverengera huwandu hwezvigadzirwa zvinotengeswa muhuwandu hwezvikamu mazana matatu. Pamusoro pezvo, zvinodikanwa kuti uverenge kuti mutengo weiyo chigadzirwa chinopfuura kukosha kwezvikamu zvitanhatu zvenduru. Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa kusarudzwa kwechitokisi umo kuverenga kuchiratidzwa.
2. Kufamba mune iyo Subsection "mafomu". Dzvanya "Isa basa." Iyo skrini inoratidza iwindo diki inonzi "basa isa". Ratidza rondedzero iri padyo ne "chikamu" chakanyorwa. Mune iyo yakabviswa rondedzero, sarudza iyo "nhamba" chinhu. Mu "Sarudza basa:" Munda, tinowana chiratidzo cheanoshanda uye tinya pairi neiyo lkm. Mushure mekunyengedza kwese, tinya pane "ok" chinhu.

gumi nepfumbamwe

1. Iwindo raizivikanwa nesu pasi pezita rekuti "kupopotedzana kwebasa" kwakaonekwa. Pano, kana uchipinda mumwe mamiriro, mutsara mutsva unoonekwa nekukurumidza kuzadza imwe mamiriro. Mumutsara "Range 1", tinofambisa kero yekamuri iyo iyo ruzivo rwekutengesa rwuri kuita zvidimbu. Mumutsetse "mamiriro 1", isu tinotyaira iyo "> 300" chiratidzo. Mutsetse "Range 2", tyaira kero yekamuri iyo ruzivo rwunowanikwa. Mune "mamiriro maviri" mutsara, wedzera kukosha "> 6000". Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

makumi maviri

1. Nekuda kweizvozvo, takawana mhedzisiro inoratidza kuti ndeapi masero akakodzera mamiriro akawedzerwa akaonekwa mune yakatarwa renji. Tine huwandu hwegumi nemana.

21 Nzira 6: Clamp Basa

Iyi sarudzo inotevera inokutendera kuti uverenge nhamba yemasero asina chinhu. Kuita izvi maitiro, zvakanyatsokodzera. Kuonekwa kwakawanda kweanoshanda: = akachenesa (range). Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa kusarudzwa kwechitokisi umo kuverenga kuchiratidzwa.
2. Kufamba mune iyo Subsection "mafomu". Dzvanya pane "isa basa" chinhu. Iyo skrini inoratidza iwindo diki inonzi "basa isa". Ratidza rondedzero iri padyo neyakanyorwa "chikamu:". Mune iyo yakabviswa rondedzero, sarudza iyo "nhamba" chinhu. Mu "sarudza basa:" Munda, tinowana mushandi wekuchenesa uye tinya pairi neLKM. Mushure mekunyengedza kwese, tinya pane "ok" chinhu.

22.

1. Mu "kupokana kwebasa" kwakaonekwa, isu tinotyaira marongero anodiwa emasero, obva tinya pane "ok" chinhu.

23.

1. Nekuda kweizvozvo, takawana mhedzisiro iyo huwandu hwemasero asina chinhu acharatidzwa.

24.

Kuverenga Akasarudzika Zvinyorwa Zvinokosha muMS Excel

Semuenzaniso, funga nezvechiratidzo chinotevera:25.

Chinangwa: Verenga nhamba yehuwandu hwakasarudzika mavara muA7: A15. Kuti aite izvi, tinoshandisa nzira: = Sumpacy ((A7: A15 "") / 8: A7: A15; A7: A15)).

Nzira yekuwana sei kudzokorora tsika muExcel.

Semuenzaniso, tine ndiro inotevera:

26.

Kuti uverenge zvekudzokorora kukosha, zvinodikanwa kuti uise fomu inotevera muG5: = $ 5: $ 10; A5) >>>>>>>>>>>>>>>>>> Ipapo iwe unofanirwa kutevedzera iyi formula pane imwe ikoreji yese.

Verenga nhamba yehuwandu hwekudzokorora muColumn

Kuti uverenge nhamba inodiwa yezvikamu zvakapetwa mukoramu, iwe unofanirwa kuita zvinotevera:

1. Shandisa isu tese tichangoitawo chiratidzo kubva pane zviri pamusoro muenzaniso. Isu tinoburitsa kusarudzwa kwecolum masero.
2. Sanganisa mune yehwindo rekugadzira.
3. Mu "Sarudza Term Type:" Munda, tinya pane chinhu "shandisa formula kuti uone masero emhando yepamusoro".
4. Mumutsara "fomati iyo formula yekuziva masero emhando", drive = 8 ($ A: $ A; A5)> 1.

27.

1. Kugadzirira! Isu takaita zvekuverenga zvevakaratidzira zvakafanana mukoramu, uye zvakare akagovera ruzivo rwekudzokorora mune mamwe mavara.

Kuverenga nhamba yeiyo chaiyo cell kukosha muExcel yakapihwa

Funga zvino panguva yakatarwa chaiyo. Ngatiti isu tine inotevera tafura yetafura:

28.

Isu tinogovera iyo e2: e5 range uye tuma fomula: = 8: B3: B3: B19; D2: D5). B3: B19 - Masero ane fungidziro, uye D5: D5 - masero, umo maitiro ayo anowanikwa kuverenga nhamba yekunyorerana. Semhedzisiro, tinowana mhedzisiro yakadaro:

29.

Mhedziso

Iyo EXEEL Tafura Yekudzidzisa chikamu cheltifaunical chirongwa chinokubvumira kuti ugadzirise huwandu hukuru hwemabasa akasiyana siyana. Chirongwa ichi chinopa mari dzinoverengeka dzinobvumidza iwe kuti uverenge huwandu hwehunhu mune yakatarwa renji. Mumwe nemumwe mushandisi anozogona kuzvimiririra kusarudza nzira yakakodzera kwazvo yakakodzera mabasa ake.

Mharidzo Maitiro Ekuverenga huwandu hwehuwandu hwehunhu muExcel chikamu. 6 Nzira dzekuverenga huwandu hwetsika dziri muEksel column yakaonekwa kutanga pane tekinoroji yeruzivo.