Nhamba kusvika padanho - chimwe chezvinhu zvekuverenga zvakakomba, saka mashandiro muMicrosoft Excel haasiwo achivapo. Kunyanya, zvinowanzodiwa kuvaka kukosha muchikamu. Chirongwa ichi chinopa midziyo yakati wandei kune ino - yakapusa uye yakaoma. Funga nezve nzira dzese dzekuisa nhamba mune imwe mraba kana imwe degree, pamwe nekuverenga mudzi kubva kuhuwandu kubva kuhuwandu - izvo zvakajairwa kana kusvika padanho.
Usati wamboverenga, zorodza mundangariro yehwaro hwemasvomhu mumunda madhigiri:
- 0 kune chero dhigirii zero;
- 1 kusvika pamwero wakaenzana neumwe;
- nhamba kusvika zero degree, kana isiri 0, ndeye 1;
- Iko kukosha kune degree 1 hakuchinje.
Erection yenhamba iri muweredzi
Nzira iri nyore yekuvaka kukosha kuita mraba kana chero imwe degree - kuisa iyo "..." icon uye nyora pasi degree. Iyi nzira yakakodzera kukurumidza kuverenga kuverenga kuverenga. Iyo formula yekurekodha iyo mraba yehuwandu inotaridzika seiyi: = nhamba yekutanga ^ 2. Iko kukosha kunoratidzwa pamurume, kana kuti dhizaini yesero nenhamba yaunoda kuvaka chikamu.
- Vhura pepa reExcel uye sarudza sero risina chinhu.
- Isu tinonyora formula neinodiwa kukosha - mune uyu muenzaniso, nhamba yacho yakanyorwa nemaoko. Chikwangwani chakaenzana mukutanga chinodiwa kuti uve nechokwadi chekuti iyo otomatiki yekuverenga basa.
- Dzvanya iyo "Enter" kiyi. Muchitokisi chichaonekwa chakaenzana nhamba yekutanga. Kana iwe ukadzvanya pachiteshi, iwe unogona kuona mumutambo pamusoro peheti rakashandiswa formula.
Edza iyo fomu imwe chete, asi panzvimbo yeiyo yenguva dzose nhamba yekuisa dhizaini yesero kubva kune rimwe chete pepa mune formula. Iyo inoronga yakatwasuka uye yakatwasuka yakanyorwa pakutanga kwechirevo - uko kukosha kwakambomira.
- Iwe unofanirwa kusarudza chero sero uye unyore nhamba iyo yakavakwa mune yakaenzana.
- Pedyo pepa rinotinyora chiratidzo chekuenzana uye gadzira fomula. Mushure mechiratidzo "=" nekudzvanya pasero nenhamba yakanyorwa, tobva tanyora zvese zvakafanana.
- Dzvanya bhatani re "Pinda" - Chirongwa ichi chinoratidza mhedzisiro papepa.
Kugadzwa uchishandisa basa racho
Kuisa kukosha muchikamu, cube kana imwe degree zvakare inogoneka uchishandisa formula yezita rimwe chete. Iyo inogoneswa mune rondedzero yemaneja maneja, saka kuzadza kwemasero kunoitwa kurerutswa.
- Dzvanya pachiteshi chisina chinhu.
- Iwe unofanirwa kuvhura iyo mabasa Master - Dzvanya pane "f (x)" icon padyo nemutsara apo mafomula akaratidzwa.
- Mune dialog box, sarudza iyo "chikamu chemasvomhu" uye tsvaga iyo degree basa mune rondedzero. Dzvanya pane iyi rondedzero yerondedzero uye tinya iyo "OK" bhatani.
- Zadza nharo dzebasa. Kana iyo nhamba iyo yakaiswa mune iyo degree yakanyorwa papepa, iyo indingi yemunda inofanirwa kushanda uye kudzvanya pachiteshi chakakodzera. Iko kududzwa kuchaonekwa mu "nhamba" munda. Dhigirii rinogona kunyorwa mumannu kana kusarudza kubva kuhuwandu hwakanyorwa papepa (semuenzaniso, kana paine dhigirii patafura). Mushure mekuzadza muminda miviri, tinya "Enter" kana "Zvakanaka".
- Uchishandisa formula, iwe unogona kuzadza iyo ikholamu ine tsika mumasekondi mashoma. Iwe unofanirwa kusarudza iyo sero repamusoro, kusaverenga macaps, uye clamp yakaenzana mruki mukona yepazasi kurudyi. Dhonza pasi uye simbisa masero ese ari mukoramu. Sunungura bhatani re mbeva, uye mhedzisiro yekuverenga ichaonekwa pachiratidziri.
Kuverenga kwemuti kubva pakati pebenzi
Iyo Microsoft Excel chirongwa ine otomatiki midzi yekubvisa chishandiso. Uku kuvhiyiwa kunoraswa mumwere.
- Dzvanya pane imwe sero isina chinhu uye vhura iyo "mafomu" tab pane mudziyo wekushandisa. Iyi ndiyo imwe nzira yekuenda kuna tenzi wemabasa. Iwe unogona kushandisa iyo yakamboratidzwa nzira - tinya pane chiratidzo "f (x)" padyo netambo apo mafomula anoratidzwa.
- Vhura chikamu "chemasvomhu". Kana mabasa akavhurika, chikamu chacho chinosarudzwa kubva pane iyo rondedzero inovhura nekudzvanya bhatani reArrow. Iyo "Fomula" tab ichangobva kuratidza bhatani rezvikamu zvechikamu ichi. Isu tinosarudza iyo midzi fomula.
- Iwe unofanirwa kuzadza iyo yemahara munda mu "basa rekuita" hwindo. Isa iyo nhamba yemanachira kana sarudza sero uine kukosha kubva kune iyo midzi ichabviswa. Dzvanya "Zvakanaka" kana tambo izere nemazvo.
- Sero rinoratidza mhedzisiro yekuverenga. Kana nhamba dzinoverengeka dzakataurwa kuti dziburitse mudzi, unogona kusarudza iwo masero anoenderana padyo navo.
Sarudza iyo formula mumabasa wizard uye nyora nharo mbiri mumabhureki: yekutanga kubva kune iyo iyo mudzi unobviswa kusvika padanho, yechipiri ndeye 1 / N. Iko kukosha kwe n ndiyo mwero wemidzi. Kuti uwane mhedzisiro, vhara mabhureki uye pinda "Enter".
Kurekodha kwehuwandu nechiratidzo
Dzimwe nguva zvinodikanwa kuti unyore pasi nhamba iri mumushumo neiyo degree reko, sezvazvinoitika mumasvomhu. Kupinda uku kunotaridzika kuchena, uye kunogona kushandiswa pamwe chete neiyo mafomula. Gadzira tafura semuenzaniso. Mune imwe yemakoramu pane materu enhamba. Ngavanyore zvavanokoshesa nedhigirii. Kuti uwane nhamba yekutanga, unogona kushandisa iyo midzi basa, asi pano makomendi ari nyore ehuwandu anotorwa pano semuenzaniso.
- Neiyo kurudyi mbeva bhatani pachiteshi chisina chinhu uye vhura iyo "cell form fomati" menyu.
- Isu tinoisa iyo fomu yemhando kuburikidza neiyo dialog box inoonekwa uye tinya "Zvakanaka".
- Isu tinonyora muchitunha padyo nekwere, nhamba yekutanga uye degree. Isu tinosimbisa nhamba iyo zvinoreva degree.
- Vhura iyo "cell form fomati" mune iyo mamiriro menyu mushure mekumanikidza bhatani rekurudyi re mbeva. Iyo dialog bhokisi rinoshandurwa - ikozvino ingori "font" tab. Izvo zvinodikanwa kuisa tick muColumn "nekukurumidza" chikamu "chinoshandura".
- Dzvanya "Zvakanaka" uye tora nhamba nedhigirii asi isina kuvakwa mariri. Sero iri rine nhamba, asi dzakaumbwa semavara, Excel inogona kunyevera nezvazvo.
Mharidzo seyekupedzisira yakaisa mraba yakaonekwa kutanga pane tekinoroji yeruzivo.