Akaunti yeOperator inoreva kubereka mabasa ehuwandu. Basa rayo guru ndere kuverenga pane yakatarwa renji remasero mune iyo nhamba yehuwandu ine. Ngatidzidzei zvimwe zvakawanda zvakadzama izvo zvakasiyana siyana zvekushandisa kweiyi formula.
Kushanda neAishandisi account
Iyo account yebasa inoreva boka rakakura revashandi vehuwandu, izvo zvinosanganisira mazana ezvimwe zvinhu. Iyo iri padyo kwazvo nayo mumabasa ako basa reakaunti. Asi, kusiyana nenyaya yekukurukurirana kwedu, zvinotora masero ezvakawana akazadzwa nedata chero ripi zvaro. Akaunti yeanoshanda iyo isu tichava nekuita hurukuro yakadzama inotungamira chete kumasero izere nedata mune nhamba yehuwandu.Ndeipi data inoenderana nenhamba? Izvi ndizvo chaizvo pakati pehuwandu chaihwo, pamwe neiyo zuva uye nguva yenguva. Logic tsika ("chokwadi", "nhema", etc.) iyo account yebasa inofunga chete kana ivo vakanyatso gakava. Kana ivo vari kungova munharaunda yepepa, iro rinoratidzwa nekupokana, ipapo mune iyi kesi inoshanda isingavake. Mamiriro ezvinhu akafanana nechiratidzo chezvinyorwa zvehuwandu, kureva kuti nhamba dzakanyorwa muzvinyorwa kana zvakakomberedzwa nezvimwe zviratidzo. Pano, kana ivo vakapokana zvakananga, vanotora chikamu mukuverenga, uye kana vari kungova papepa, ivo havagamuchire.
Asi maererano neruzivo rwakachena umo nhamba dzisiri varipo, kana kuitwazve mazwi ("# yezviitiko / 0!", # Zvinoreva! Etc.) mamiriro ezvinhu akasiyana. Tsika dzakadai iyo account yebasa haina hanya mune chero fomu.
Pamusoro pemabasa, iyo account uye account yekuverenga huwandu hwemasero akazadzwa achiri kuita vashandisi vemameto uye vanoverengeka. Uchishandisa aya mafomula, unogona kuverenga nemamiriro ekuwedzera. Iri boka revashandi vehuwandu hwakazvipira kune nyaya yakapatsanurwa.
Chidzidzo: Maitiro ekuverenga huwandu hwemasero akazadzwa muExle
Chidzidzo: Statistical Mabasa muExcel
Nzira 1: Master of Mabasa
Kune mushandisi asina ruzivo, zviri nyore kuverenga masero ane manhamba achishandisa iyo manhamba uchishandisa iyo basa wizard.
- Dzvanya pane imwe sero isina chinhu pane iyo sheet iyo mhedzisiro yekuverenga icharatidzwa. Dzvanya pane "paste basa" bhatani.
Pane imwezve sarudzo yekutanga wizard yemabasa. Kuita izvi, mushure mekusarudzwa kwechitokisi, iwe unofanirwa kuenda kune "mafomu" tab. Pamutepi mu "Basa Rekushandisa" Toolbar, tinya pane "paste basa" bhatani.
Pane imwe sarudzo, ingangove iri nyore, asi panguva imwe chete yaida ndangariro dzakanaka. Isu tinosimbisa sero pane pepa uye tinya musanganiswa wekusanganisa pane iyo shift + f3 keyboard.
- Mune zvese zviitiko zvitatu, basa reIntern tenzi richatanga. Kuti uende kuhwindo rekupokana muChikamu "Statistical" kana "yakazara alfabhethi rondedzero" Tiri kutsvaga chinhu "account". Isu tinoratidza uye tinya pane iyo "OK" bhatani.
Zvakare, hwindo rekupokana rinogona kutangwazve neimwe nzira. Isu tinosimbisa iyo sero kuratidza mhedzisiro uye enda kune "mafomu" tab. PaRibbon mu "Raibhurari Raibhurari" Zvirongwa zveGrounds, tinya pane "mamwe mabasa". Kubva pane rondedzero inoonekwa, iwe unounza iyo inotuka kune iyo nzvimbo "nhamba". Mune menyu inovhura, sarudza iyo "account" chinhu.
- Iyo nharo hwindo rinotanga. Iyo chete nharo yeiyi formula inogona kunge iri kukosha kwakataurwa sechinhu chinongorehwa kana kuti chakanyatsonyorwa munhamba inoenderana. Chokwadi, kutanga kubva ku Execel 2007, tsika dzakadaro dzinogona kusvika 255 zvinosanganisira. Mukutanga shanduro kwaingova nemakumi matatu chete.
Iwe unogona kuisa iyo data iri mumunda nekunyora iwo chaiwo matsika kana masero anoronga kubva kukhibhodi. Asi apo iyo coordinate yakaiswa zviri nyore kungoisa iyo inongori mumunda uye sarudza iyo inoenderana cell kana huwandu pane pepa. Kana iyo manhamba iri imwe, kero yechipiri imwe inogona kuiswa mu "kukosha2" munda, nezvimwe. Mushure mekunge tsika dzakanyorwa, tinya pane "OK" bhatani.
- Mhedzisiro yekuverenga kwemasero ine huwandu hwenhamba mune iyo yakazvipira mhando icharatidzwa munzvimbo yekutanga papepa.
Chidzidzo: Wizard mabasa muExcel
Nzira 2: Kuverenga uchishandisa imwe nharo nharo
Mumuenzaniso pamusoro, isu takarangarira nyaya yacho kana nharo dzacho dziripo dzakarongeka kune sheethes. Zvino ngatitarisei sarudzo kana iyo tsika yakanyorwa zvakananga mundima nharo inoshandiswawo.
- Mune chero sarudzo dzakatsanangurwa munzira yekutanga, mhanyisa hwindo rekupokana rebasa reakaundi. Mu "kukosha1" munda, taura kero yeiyo data renji, uye mu "kukosha2" munda unokodzera kutaura zvine musoro kuti "chokwadi". Dzvanya pane "OK" bhatani kuti uite kuverenga.
- Mhedzisiro yacho inoratidzwa munzvimbo yakasarudzwa pre-yakasarudzwa. Sezvatinogona kuona, chirongwa chacho chakati wandei huwandu hwemasero ane manhamba uye mune yakazara huwandu hwakawedzera kune imwe kukosha, iyo isu takanyora izwi rekuti "chokwadi" mumunda wenhau. Kana kutaura uku kwakanyorwa zvakananga muchitokisi, uye mumunda chete pachave chinongedzo pairi, saka zvaisazowedzerwa kune huwandu hwakazara.
Nzira 3: Manual Sumo yeFomula
Kuwedzera pakushandisa wizard yemabasa uye nharo windows, mushandisi anogona kuisa chirevo pane chayo pachezvako kune chero sero pane pepa kana mune formula tambo. Asi izvi iwe unofanirwa kuziva iyo syntax yeiyi opareta. Haina kuomarara:
= Zviyero (kukosha1; kukosha2; ...)
- Isu tinosuma muchitokisi chirevo chechimiro maererano nesystem.
- Kuti uverenge mhedzisiro uye ubudise pachiratidziro, tinya bhatani rePeturu, rakaiswa pane kabhodhi.
Sezvauri kuona, mushure meizvi zviito, mhedzisiro yekuverenga inoratidzwa pachiratidziri muchitokisi chakasarudzwa. Kune vashandisi vane ruzivo, nzira iyi inogona kutonyanya nyore uye nekukurumidza. Pane yapfuura nekufona kwemiwiwa yemabasa uye hwindo rezvipikiso.
Pane nzira dzinoverengeka dzekushandisa iyo account account, iyo huru basa rauri kuverenga masero ane nhamba yehuwandu. Nerubatsiro rweiyo formula, imwe data inogona kuitwa kuti uverenge zvakananga muFormula nharo dzemunda kana kurekodha zvakananga muchitokisi zvichienderana neiyo syntax yeiyo ouserator. Mukuwedzera, pakati pevashandi vehuwandu pane mamwe maforama akabatanidzwa mukuverenga kwemasero akazadzwa muzvikamu zvakatsaurwa.