Maitiro Ekuisa Mufananidzo muTexcel tafura. Isa uye kumisikidza mufananidzo muExcel

Mamwe mabasa anoitwa muTafura Excel tafura processor inoda kuwedzera akasiyana-siyana ekudhirowa uye mafoto kune tabular data. Chirongwa ichi chine huwandu hwezvishandiso zvinokutendera kuti uise mufananidzo. Mune chinyorwa, isu tichazoongorora nzira dzinoverengeka dzekuita izvi zvakadzama zvakadzama: Kupfuura kuchengetedzwa kweshizha rekushanda, iyo modhi yekuvandudza uye wedzera manotsi kune pepa rebasa.

Zvimiro zvinoisa mifananidzo

Kuti uwedzere kunyora mufananidzo kune iyo yekushanda pepa rebrow processor, zvakafanira kuti mufananidzo pachayo uri pane hard disk yePC kana pane inobvisa media yakabatana nayo.

Isa mifananidzo pane pepa

Kutanga, isu tinotsanangura kuti maitiro ekuisa anoisa sei pabasa rebasa, obva aziva nzira yekuwedzera mufananidzo kuita chimwe chitokisi. Nhanho-ne-Score Nhungamiro Inotaridzika seiyi:

1. Isu tinoburitsa kusarudzwa kwesero ratinoronga kutsvaga iyo dhirowa. Isu tinoenda kuchikamu chinonzi "isa", iyo iri kumusoro kweiyo tafura processor. Isu tinowana block yemirairo "mufananidzo" uye tinya chinhu "chiumbwa".

Poshi

1. Hwindo rinoratidza hwindo rakanzi "Kuisa Kuisa". Chiyero chinogara chichiratidzwa mumufananidzo wechifananidzo. Izvo zvinokwanisika kuendesa kumberi kune ino folda saka mufananidzo watinoronga kuisa pane yekushanda pepa reTabular processor. Imwe sarudzo - kugara muhwindo rimwe chete, enda kune imwe folda yekombuta yemunhu uye yakabatana inobvisa media. Kana wapedza zvese zvakanangana, pane kusarudzwa kwemifananidzo, tinya pane "paste" bhatani.

2.

1. Kugadzirira! Iyo yaunoda mufananidzo yakaonekwa pane yebasa pepa reiyo tabular processor. Izvo zvakakosha kucherechedza kuti iyo dhizaini parizvino haina kubatanidzwa kune chero sero regwaro. Isu tichataura nezve chirevo chekuita zvishoma gare gare.

3 mufananidzo wekugadzirisa

Ngatitaurei nezve nzira yekuchinja iyo yakaiswa mufananidzo kuti iwane zviyero zvakakodzera, zvinowirirana nekutarisa kune iyo yekushanda pepa reTabular processor. Nhanho-ne-Score Nhungamiro Inotaridzika seiyi:

1. Dzvanya pane iyo yakaiswa pkm mufananidzo. Iyo skrini inoratidza mamiriro menyu, iyo inokutendera kuti uchinje imwe kana imwe mufananidzo paramende. Sarudza chinhu chinonzi "saizi uye zvivakwa".

ina

1. Iwindo diki inonzi "Forature fomati" yakaonekwa pane kuratidzwa. Heino nhamba huru yemapepa okusiyana anokubvumira kuti ugadzirise zvivakwa zvechifananidzo. Basic marongero: saizi, mumvuri, trimming, dzakasiyana siyana dzemhedzisiro uye zvichingodaro. Nhamba huru yemarongero yakagadzirwa kuti ive nechokwadi chekuti mushandisi anogona kugadzirisa iyo yakaiswa pikicha kune iyo yakawanda mabasa akasiyana.

shanu

1. Kana pasina chikonzero chekunyatsotaurwa kugadzirisa iwo mufananidzo wakaiswa, saka isu hatizoda hwindo "hwindo uye zvivakwa". Imwe nzira yekuchinja shanduko sarudzo - enda kune imwe chikamu chekuwedzera "kushanda nemadhirowa", iri kumusoro kweiyo tafura processor.

6.

1. Kana tinoshuva kuisa mifananidzo muchitokisi, ipapo iwe unofanirwa kugadzirisa iwo mufananidzo kuitira kuti zviyero zvaro zvinowirirana nehukuru hwesero. Saizi yekugadzirisa inoitwa nenzira inotevera nzira: kuburikidza ne "saizi uye zvivakwa" hwindo; Kufambisa miganhu yekudhirowa uchishandisa LKM; Uchishandisa tape zvishandiso, pamwe nezvakanyorwa menyu.

7.

Kuchinjisa Mifananidzo

Mushure mekuita zvese zvakanyengera zvinotsanangurwa pamusoro apa, iyo yakaiswa pikicha mune chero mamiriro aripo akasarudzika muchitokisi. Semuenzaniso, kana mushandisi akashandisa kurongedza kwedatha pabasa rebasa, masero anochinja nzvimbo yavo, uye chifananidzo chicharamba chiri munzvimbo imwechete iyo yakaiswa. Mune iyo tabular processor kune nzira dzinoverengeka dzinobvumidza iwe kuti ubatanidze mufananidzo kune yakasarudzwa gwaro sero. Ngatitaurei nezve izvi zvakadzama.

Nzira 1: SHETE Dziviriro

Kuchengetedza pepa rekushanda regwaro kubva pakurongedza kwakasiyana siyana ndeimwe yenzira dzekusanganisa mufananidzo kune sero. Nhanho-ne-Score Nhungamiro Inotaridzika seiyi:

1. Isu tinoita baction yemufananidzo wechikuru pasi pehukuru hwesero uye kuita kuti kuisirwa nzira dzakatsanangurwa pamusoro apa.

sere

1. Dzvanya pane iyo yakaiswa pikicha. Mhando diki menyu inoonekwa. Dzvanya pane "saizi uye zvinhu" chinhu.

pfumbamwe

1. Iyo skrini "chimiro chimiro" chakaonekwa pachiratidziri. Isu tinofambisa ku "saizi" chikamu uye ita shuwa kuti saizi yemufananidzo haipfuure kukosha kwesero. Pamusoro pezvo, iwe unove nechokwadi chekuti pane mabhokisi ekutarisa pedyo ne "Sevha kuenzana" zvinhu uye "hama yekutanga". Kana chero zvivakwa zvisingaenderane nezviri pamusoro, zvakazvirongedza.

10

1. Muwindo imwe chete isu tinowana chikamu "chivakwa" uye famba kwazviri. Kana pasina cheki marketks padhuze nezvinhu zve "PRINDA chinhu" uye "chinhu chinodzivirira", ipapo chinofanira kupihwa. Isu tinowana iyo "inosungira chinhu kusvika kumashure" chivakwa uye kuisa mucherechedzo wepedyo "fambisa uye kushandura chinhu chine masero". Mushure mezvose zvemanyoka, tinya pane "padyo" bhatani, iyo iri pazasi pewindo remifananidzo.

gumi neimwe

1. Uchishandisa kiyi musanganiswa pa "Ctrl + a" khibhodi, isu tinogadzira kugovera iyo yakazara yepepa rekushanda. Fonera mamiriro emenyu uye tinya pane iyo cell Fomati chinhu ... ".

12

1. Iwindo rakaonekwa pachiratidziro inonzi "cell form fomati". Enda ku "dziviriro" chikamu uye bvisa mucherechedzo kubva kune yakachengetedzwa masero midziyo. Mushure mezvose zvekumanikidza, tinya pane "OK" bhatani, iri pazasi pewindo.

13

1. Zvino isu tinoburitsa kusarudzwa kwechitokisi umo iyo yakaiswa mufananidzo inowanikwa, iyo yatinoronga kubatanidza. Iyo nzira yakatsanangurwa pamusoro iri pamusoro iri kufamba mu "cell form form fomati" newindo, uchishandisa mamiriro emenyu. Zvekare zvakare, isu tinoenda kuchikamu che "Dziviriro" uye panguva ino takaisa tick padivi pe "Cell yakachengetedzwa sero" pfuma. Mushure mekuita zvese manipupolations, tinya pane "Zvakanaka".

gumi neina

1. Enda kune "ongororo" chikamu, chiri pamusoro petafura processor interface. Tsvaga block inonzi "shanduko" uye tinya pane "Dzivirira pepa" chinhu.

gumi neshanu

1. Hwindo rinoratidza hwindo rakanzi "SHEP Dziviriro". Mu "password yekudzima mashizha ekudzivirira", kutyaira password. Dzvanya pane "OK" bhatani. Rimwe hwindo rakaonekwa pane kuratidzwa, umo iwe unofanirwa kunyatsoisa zvakare password.

gumi nenhanhatu

1. Kugadzirira! Takadzivirira iyo sero nemufananidzo wakaiswa kubva kune chero shanduko. Mune mamwe mazwi, dhirowa rakabatanidzwa kuchitokisi.

Nzira 2: Mufananidzo unoisa mucherechedzo

Uchishandisa cherechedzo, iwe unogona zvakare kusunga mifananidzo. Nhanho-ne-Score Nhungamiro Inotaridzika seiyi:

1. Isu tinodzvanya pkm pane sero ratinoshuvira kuisa mufananidzo. Mhando diki menyu yakaratidzwa. Dzvanya pane chinhu chinonzi "isa chinyorwa".

17.

1. Iwindo diki rinoonekwa pachiratidziro, ichikubvumira kuti urege kunyora chinyorwa. Fambisa iyo pointer kune hwindo chimiro uye tinya pairi. Iyo skrini inoratidza chirevo chitsva menyu. Dzvanya pane iyo "Zvinyorwa fomati" chinhu.

gumi nesere

1. Hwindo idzva rakaonekwa pane kuratidzwa, rakagadzirirwa kugadzirisa zvinyorwa. Isu tinoenda kune "mavara uye mitsara" chikamu. Isu tinowana iyo "kuzadza" midziyo uye inoratidza rondedzero yemumvuri mu "ruvara". Muzvinyorwa zvakarambidzwa, tinya pane zvakanyorwa "nzira dzekuzadza ...".

gumi nepfumbamwe

1. Iwindo rinoratidzwa mauri iwe unogona kusarudza nzira inozadza. Famba mu "nhamba" chikamu, uye wobva wadzvanya pane chinhu "dhiza ...".

makumi maviri

1. Kujaira isu pane nzira dziri pamusoro apa dzekuisa nhamba yewindows yakatsanangurwa pamusoro apa. Isu tinoita sarudzo yematanho. Mushure mekuita zvese zvakanyengera, tinya pane iyo "paste" bhatani, iyo iri pazasi pe "kuisa pfungwa" newindo.

21.

1. Mufananidzo wakasarudzwa wakaratidzwa mu "zadza nzira" hwindo. Isu tinoisa tick padivi pechinyorwa "chengetedza huwandu hwembiro". Mushure mezvose zviito, tinya pane "Zvakanaka".

22.

1. Isu tinodzoka kune "manhamba fomati" hwindo. Isu tinoenda ku "dziviriro" chikamu. Bvisa mucherechedzo padhuze neyakagadzirirwa "chinhu chinodikanwa".

23.

1. Isu tinoenda kune "zvivakwa" chikamu. Mu "kusungira chinhu kusvika kumashure" block, tinoisa chiratidzo padhuze ne "fambisa uye kushandura chinhu chine maseru" chinhu. Mushure mekuita zvese manipupolations, tinya pane "Zvakanaka".

24.

1. Kugadzirira! Pashure pokunge tashandisa matanho ese akatsanangurwa pamusoro apa, mufananidzo wacho hauna kungowedzerwa kune iyo tsamba, asi zvakare yakanamatira kuchitokisi. Ehezve, nzira iyi haina kukodzera zvachose mabasa ese akagadziriswa uchishandisa processor processor, sezvazvinoreva zvimwe.

25 nzira 3: Dhizaina maitiro

Iwe unogona kusunga mufananidzo kune sero uchishandisa yakakosha "yekuvandudza" maitiro, yakabatanidzwa mune tabular processor. Iyo huru yakaoma - iyo mode iri kubva pasi. Pakutanga, tichazvidzosera. Nhanho-ne-Score Nhungamiro Inotaridzika seiyi:

1. Enda kune "faira" chikamu, uye sarudza iyo "parameter" chinhu.

26.

1. Muwindo rakataridzika, enda ku "tepi rutsigiro" chikamu. Isu tinoisa mucherechedzo unotevera kunyorwa "kuvaka". Mushure mekunyengedza kwese, tinya "Zvakanaka".

27.

1. Isu tinoburitsa kusarudzwa kwenzvimbo iyo yatinoda kuisa iyo nzira. Enda kuChikamu chekuvandudza, icho chakaonekwa pamusoro petafura processor interface. Mu "Wedzera-mu" block, tinya "paste". Mune rondedzero yekudzvanya pane iyo "mufananidzo" icon, iri muchikamu chinoshanda chezvinhu.

28.

1. Iyo diki quadrangle yemhando isina chinhu yakaonekwa muchitokisi. Isu tinoburitsa kugadzirisa saizi kuitira kuti nhamba yacho ive muchitokisi chakasarudzwa. Kurongedza isu tinoita nemiganhu inofamba neLKM. Dzvanya PCM pane nhamba. Mhando diki yemamenyu yakaratidzwa, umo kudzvanya "zvivakwa".

29.

1. Iyo skrini inoratidza iyo nzvimbo hwindo. Tevere kumanyorerwo "kuiswa" isa unit. Mumutsara "mufananidzo" tinowana iyo icon muchimiro chezvikamu zvitatu uye tinya pairi neiyo kuruboshwe bhatani bhatani.

makumi matatu

1. Yakaonekwa hwindo Wedzera mufananidzo. Isu tinowana iyo dhizaini yatinoda kuisa. Isu tinosimbisa, tobva tinya pane "Vhura" bhatani, iri pazasi pehwindo.

31.

1. Kana wapedza matanho ese, vhara iyo nzvimbo yepahwindo. Mufananidzo waunoda wakaiswa muchitokisi. Tevere, zvinodikanwa kuburitsa maitiro ekusunga chifananidzo kuchitokisi. Isu tinoshandisa kusarudzwa kweiyo nzira pane yebasa uye tikaenda ku "Peji Markup" chikamu, chiri pamusoro petafura processor. Isu tinowana iyo "kuronga" block uye sarudza iyo "kuwiriranisa" chinhu " Mune rondedzero yerondedzero, tinya pane "yakasungirirwa kune grid" uye zvishoma kuendesa kunze kwenyika.

32.

1. Kugadzirira! Mushure mekushandisa maitiro ari pamusoro, tanga tichisunga mufananidzo kuchitokisi.

Mhedziso

MuTafura processor, Budiriro kune nzira dzakawanda dzekuisa pikicha uye kusunga iyo kuchitokisi, asi kwete nzira imwe neimwe yakakodzera kugadzirisa mabasa ese. Semuenzaniso, nzira yakavakirwa pakushandiswa kwemanyorero ndeyekunyorwa-zvakapetwa, uye iyo "yekuvandudza nzira" uye "SHETETAS Dziviriro" - Yenyika Sarudzo dzakakodzera kune vese vashandisi.

Mharidzo Maitiro Ekuisa mufananidzo mutsafura yekunyanyisa. Isa uye kumisikidza mufananidzo kuti ubudise wakatanga kuoneka kune tekinoroji yeruzivo.