Kutenderera Nhamba muExcel: 4 kushanda Mafashoni

Kana uchiita chikamu kana kushanda nehuwandu hwenhamba, Excel inoburitsa kutenderera. Izvi zvakakodzera, chekutanga pane zvese, neicho chokwadi chekuti nhamba dzakanyatsojeka dzisingawanzo kana zvichidikanwa kuti dzishande pamwe nekutaura kwakawanda nezviratidzo zvakati wandei mushure mekunge comma. Mukuwedzera, pane manhamba ayo musimboti haanyatso kutenderedzwa. Panguva imwecheteyo, kusakwana kwakaringana kutenderera kunogona kutungamira zvikanganiso zvakaoma mumamiriro ezvinhu apo kunyatsodiwa. Neraki, chirongwa ichi chine mukana wekuisa vashandisi vega, kuti nhamba dzakatenderedzwa sei.

Zvimiro zvehuwandu hwekutenderera Excel

Nhamba dzese dziine microsoft Excel mabasa akapatsanurwa mune chaiyo uye yakajeka. Memory inochengeterwa mundangariro yekusvika gumi nemashanu kuraswa, uye yakaratidzwa isati yabuda, iyo icharatidza mushandisi pachayo. Zvese kuverenga zvinoitwa zvichienderana nekuchengetwa mundangariro, uye kwete kuratidzwa pane iyo data yekutarisa.

Uchishandisa kushanda kwakatenderedza, Excel inorerutsa imwe nhamba yemicolons. Inoshandisa nzira inowanzogamuchirwa inotenderera, apo nhamba iri pasi pe5 yakatenderedzwa mudivi diki, uye kupfuura kana yakaenzana ne5 - mune yakawanda shanu.

Kutenderedza nemabhatani pane ribhoni

Nzira iri nyore yekuchinja ndeyekunyatsoratidza iyo cell kana boka remasero uye, nepo pane iyo imba yeTab, tinya tepi kune "Blue Big" bhatani kana "Deredza ukuru". Mabhatani ese ari maviri ari mu "nhamba" yekutonga. Nhamba yakaratidzwa chete ichangobva kutenderedzwa, asi yekuenzanisa, kana zvichidikanwa, kusvika paminda gumi nemashanu yenhamba ichabatanidzwa.

Paunodzvanya pane "Wellarge Big" bhatani, huwandu hwevanyori dzakagadzirwa mushure mekunge comma inowedzera neimwe.

Iyo "Deredza BUT" bhatani, zvichiteerana, inoderedza imwe nhamba yenhamba mushure me comma.

Kutenderera kuburikidza neCell Fomati

Izvo zvinokwanisika zvakare kuisa kutenderera uchishandisa cell yemhando mamiriro. Kuti uite izvi, sarudza huwandu hwemasero pane pepa, tinya pane bhatani rekurudyi mbeva uye sarudza "cell for" chinhu mune menyu inoonekwa.

MuColl Fommer Zvirongwa hwindo rinovhura, enda ku "nhamba" tab. Kana iyo data ye data isina kutaurwa, inodikanwa kuti iise kunze, zvimwe iwe haungazokwanisi kutungamira kutenderera. Muchikamu chepakati pepahwindo padyo neyakagadziriswa "nhamba yezviratidzo zvechiratidzo" ingoratidza huwandu hwezviratidzo zvaunoda kuona kana uchitenderera. Mushure meizvozvo shandisa shanduko.

Kuisa kurongeka kwekuverenga

Kana mune zvakapfuura zviitiko, ma paramita akagadzika chete ekunze data kuratidza, uye panguva yekuverenga, zvimwe zviratidzo, zvinosvika gumi nemashanu mavara), ikozvino tichakuudza nzira yekuchinja chokwadi chekuverenga.

1. Dzvanya iyo faira yefaira kubva ipapo kusvika kune "parameter" chikamu.



2. Iyo Excel parameter windows inovhura. Muhwindo rino, enda kunzvimbo pfupi "inosarudzwa". Isa zvigadziriso block inonzi "kana uchizodzokorora bhuku iri". Zvirongwa muchivharo ichi hazvishandiswe kune pepa rimwe, asi kubhuku racho seyese, kureva kuti iyo yese faira. Isa iyo bhokisi rekutarisa pamberi pe "set seti chaiyo seyechiso" paramende uye tinya OK.



3. Zvino, kana uchiverenga iyo data, iyo nhamba yakaratidzwa pachiratidziro ichaverengerwa, uye kwete iyo iyo inochengeterwa iyo yekunyorera ndangariro. Iko kuiswa kweiyo nhamba yekuratidzwa kunogona kuitwa neiyi nzira mbiri dzatataura pamusoro.

Kushandiswa Kwemabasa

Kana iwe uchida kushandura kukosha kwekutenderera mukuverenga kweimwe kana more masero, asi usingade kuderedza chokwadi chehuwandu kuti uwane iyo gwaro, mune izvo zvakanaka kuti ushandise kugona kuti "kutenderedzwa" basa " uye misiyano yaro dzakasiyana siyana, pamwe nemamwe mamwe mabasa.

Pakati pemabasa makuru ekuti anotonga kutenderera kunofanirwa kugoverwa seinotevera:

• "Yakatenderedzwa" - kutenderera kune nhamba yakatarwa yezviratidzo zvechiratidzo maererano nezvinowanzogamuchirwa mitemo inotenderera inotenderera;
• "Dunhu kumusoro" - kutenderera kusvika kune iyo yepedyo nhamba kumusoro module;
• "Rounddedlic" - kutenderera kumusoro kune iyo yepedyo nhamba pasi module;
• "Kutenderedzwa" - kutenderedza nhamba neyakapiwa chokwadi;
• "Okrwp" - inotenderera iyo nhamba ine yakapihwa kurongeka kumusoro kwe module;
• "Okrvnis" - kutenderera iyo nhamba pasi module ine yakapihwa chokwadi;
• "Otbr" - inotenderera iyo data kune iyo nhamba;
• "Court" - inotenderera iyo data kune iyo iri pedyo kunyange nhamba;
• "Dambudziko" - Round the data kune iyo iri pedyo isinganzwisisike nhamba.

Zvekuita zve "kutenderera", "Roundlower" uye "RoundLice" inoshandisa inotevera yekuisa fomu: zita rebasa (nhamba; nhamba yehuwandu). Izvi ndizvo, kana iwe, semuenzaniso, uchida kutenderedza nhamba 2.56896 kusvika kumatatu kusvika matatu manhamba, wobva washandisa basa "rakatenderedzwa (2,56896; 3)". Semhedzisiro, inozoitika nhamba 2.569.

Zvekuita "Dunhu", "Okrwp" uye "Okrvis" izvi zvinoshandiswa nefomula inotenderera: zita rebasa (nhamba; kunyatso). Saka, kutenderedza nhamba gumi nembiri kune iyo nhamba yepedyo, yakawanda 2, tinopinda iyo basa ". 2; 2)". Kubuditsa kunowana mhedzisiro 12.

Iyo "OTBR" inoshanda, "kunyange" uye "yunifomu" Shandisa inotevera fomati: zita rebasa (nhamba). Kuti titenderane nenhamba 17 kusvika padyo kunyange, isu tinoshandisa basa "redare (17)". Isu tinowana mhedzisiro 18.

Basa racho rinogona kupinda zvese muchitokisi uye mumutsetse wemabasa, mushure mekusarudza sero razvichave ruri. Basa rega rega risati ratarwa "=".

Pane imwe nzira yakasiyana-siyana yekusvitsa mabasa anotenderera. Zvinonyanya kuve nyore kushandisa kana paine tafura ine hunhu hwaunoda kushandura kuita manhamba akakomberedzwa mune imwe ikhoramu.

1. Enda kuTabu "Formulas" uye tinya pane "mathematical" bhatani. Mune rondedzero inovhura, sarudza basa rakakodzera, semuenzaniso, "rakatenderedzwa".



2. Mushure meizvozvo, basa rekupokana newindo rinovhura. Mu "nhamba" munda, iwe unogona kupinda muhuwandu pamurume, asi kana tichida kuti titore data patafura yese, wobva wadzvanya pane iyo bhatani kurudyi kweiyo data yekunyepedzera.



3. Hwindo rekupokana rebasa rakapetwa. Zvino tinya pachiteshi chepamusoro chekamuri ine data ripi ratiri kuenda kutenderedzwa. Mushure mekukosha kwacho kwapinda muhwindo, tinya pane bhatani kurudyi kweiyi kukosha.



4. Iyo basa rekupokana newindo rinovhura zvakare. Mu "nhamba yekubvisa" munda, nyora zvishoma kuti zvatinoda kucheka zvidimbu uye tishandise shanduko.



5. Nhamba yakatenderedzwa. Kuti udzikise pasi uye zvimwe zvese data yekona yaunoda, uyai nekona yekurudyi yekona yekurudyi yechitokisi chine bhatani rokuruboshwe, tinya pasi bhatani rokuruboshwe, uye utambanudzire kusvika kumagumo etafura.



6. Iye zvino tsika dzese dziri mukoramu dzichatenderedzwa.

Sezvauri kuona, pane nzira mbiri huru dzekutenderedza kuratidzwa kwehuwandu: uchishandisa tepi bhatani uye nekuchinja maratidziro eiyo cell form. Mukuwedzera, iwe unogona kushandura kutenderera kwekutenderera kweiyo yakaverengerwa data. Izvo zvinogona zvakare kuitwa nenzira dzakasiyana: Chinja marongero ebhuku rose kana kushandiswa kwemabasa akakosha. Iko kusarudzwa kweimwe nzira kunoenderana nekuti iwe uchashandisa rudzi rwakafanana runotenderera kune ese data mufaira kana chete kune yakatarwa masero.