Pakati peiyo seti yezviito arithmetic iyo inokwanisa kuita microsoft Excel, zvakasikwa zviripo uye nekuwedzera. Asi, zvinosuruvarisa kuti havasi vese vashandisi vanoziva zvizere uye kushandisa zvizere mukana uyu. Ngativone maitiro ekuita maitiro mazhinji muMicrosoft Excel.
Nheyo dzekuwedzera muExcel
Semamwe chero imwe arithmetic mhedzisiro muChirongwa cheEnteccEn, kuwanda kunoitwa uchishandisa Special Formulas. Zviito zvekuwedzera zvakanyorwa uchishandisa chiratidzo - "*".Kuwedzera nhamba dzakajairika
Iyo Microsoft Excel chirongwa inogona kushandiswa seCalculator, uye kungowedzera nhamba dzakasiyana.
Kuti uwedzere kuwanda nhamba imwe kune imwe, pinda mune chero sero pane pepa, kana mune formula tambo, chiratidzo chakaenzana (=). Tevere, taura chinhu chekutanga (nhamba). Zvadaro, isa chiratidzo kuti uwande (*). Zvadaro, nyora chechipiri chinhu (nhamba). Saka, general general template icharatidzika seinotevera: "= (nhamba) * (nhamba)".
Muenzaniso unoratidza kuwanda kwe564 kusvika ku25. Chiito chakanyorwa nemhepo inotevera: "= 564 * 25".
Kuti uone mhedzisiro yekuverenga, iwe unofanirwa kudzvanya pane iyo Enter Enter.
Munguva yekuverenga, iwe unofanirwa kuyeuka kuti kukoshesa kweAlithmetic chiito muExcel, zvakafanana mumasvomhu emasvomhu. Asi, chiratidzo chekuwedzera chinoda kuwedzerwa zvakadaro. Kana pavanenge vachinyora chirevo papepa zvinobvumidzwa kudzikisa chiratidzo chekuwedzera pamberi pemabhureki, ipapo muExcel, kuti zvive zvekuverenga zvakakodzera, zvinodikanwa. Semuenzaniso, kutaura 45 + 12 (2 + 4), mukubuda kwaunoda kuti zvinyorwe: "= 45 + 12 * (2 + (2 + 4)".
Cell inowedzera
Maitiro mazhinji ekuwedzera echitokisi pachiteshi chinoderedzwa kune iwo musimboti mumwechete sekuwanda kwemaitiro ehuwandu. Chekutanga pane zvese, iwe unofanirwa kusarudza kuti nderipi sero mhedzisiro icharatidzwa. Mariri akaisa chiratidzo chakaenzana (=). Tevere, neimwe neimwe nzira tinya pamasero, zvirimo zvaunoda kuti uwande. Mushure mekusarudza sero rega rega, isu tinoisa chiratidzo chekuwedzera (*).
Kuwanza kwekamuri pane imwe ikholamu
Kuti muwande iyo ikholamu pane imwe ikholamu, pakarepo inoda kuwanda masero ekumusoro emakoramu aya, sezvakaratidzwa mumuenzaniso pamusoro. Zvadaro, isu tinova pasi pekona yekuruboshwe yechiteshi chakazadzwa. Mazano anozadza anoonekwa. Kufunga iyo pasi neiyo kuruboshwe bhatani bhatani rakanyudzwa. Saka, forplication yekuwedzera inoteedzerwa kumasero ese ekisimusi.
Mushure meizvozvo, makoramu achawedzerwa.
Saizvozvo, iwe unogona kuwedzera matatu kana anopfuura makoramu.
Kuwanza kwemasero nenhamba
Kuti uwedzere kuwanda sero nehuwandu, seyemienzaniso iri pamusoro, kutanga pane zvese, isa chiratidzo chakaenzana ne (=) muchitokisi chaunoshuvira kuratidza mhinduro yeArithmetic chiito. Tevere, iwe unofanirwa kurekodha huwandu hwehuwandu hwehuwandu, isa chiratidzo chekuwedzera (*), uye tinya pane sero raunoda kuwanda.
Kuti ubudise mhedzisiro pachiratidziro, tinya pane bhatani rePeturu.
Nekudaro, iwe unogona kuita zviito uye mune imwe nzira: pakarepo mushure mekunge chiratidzo chakaenzana nekudzvanya muchitokisi chaunoda kuwanza, uye mushure mekunge chiratidzo chekuwedzera, nyora nhamba. Kupfuura zvese, sezvaunoziva, basa racho harisi shanduko kubva mukureva kwekuwedzera.
Nenzira imwecheteyo, iwe unogona, kana zvichikosha, uwande masero akati wandei uye nhamba dzinoverengeka kamwechete.
Kuwanza kwekamuri nenhamba
Kuti uwande chikamu pane imwe nhamba, iwe unofanirwa kunge wakangoerekana wawanda nesero, sezvakatsanangurwa pamusoro. Ipapo, uchishandisa mucherechedzo waizara, kopi fomula kumasero epazasi, uye tinowana mhedzisiro yacho.
Kuwanda kweiyo chikamu pachiteshi
Kana nhamba iri mune imwe sero kuti iwande mubatanidzwa, semuenzaniso, kune imwe coacffient, nzira iri pamusoro haina kukodzera. Izvi zvinokonzerwa nenyaya yekuti kana uchitevedzera zvichachinjirwa nehuwandu hwevose vari vaviri vazhinji, uye isu tinoda imwe yezviwande zvachose.
Kutanga, uwande neyakajairwa nzira yekutanga column muchitokisi, iyo ine coefficient. Kupfuurirazve, mufomula, isu takaisa chiratidzo chemadhora pamberi peganda rekamuri uye mitsara yekutaura nezvechitokisi chine cell. Nenzira iyi, isu takatsausa hama yekutaura nezvake mhedziso, iyo inoronga yeiyo haizoshandurwe kana ichitevedzera.
Zvino, zvinosara nenzira yakajairwa, vachishandisa iyo yekuzadza mucherechedzo, copy the formula kumamwe masero. Sezvauri kuona, mhedzisiro yakagadzirirwa-yakagadzirirwa inokurumidza kuoneka.
Chidzidzo: Maitiro ekuita kuti iclation zvachose
Basa rekugadzira
Pamusoro pekuwanda kwekuwedzera nzira, pane mukana wekushandisa basa rakakosha kune izvi zvinangwa mukubwinya. Iwe unogona kuzvidaidza iyo nzira dzose dzakafanana seimwe basa.
- Uchishandisa mabasa ehuni waunogona kumhanya nekudzvanya pane "isa basa" bhatani.
- Kuburikidza nefomula tab. Kuve mairi, iwe unofanirwa kudzvanya pane "mathematical" bhatani, iyo iri patepi mu "raibhurari yeiyo basa raibhurari". Zvadaro, mune rondedzero inoratidzika, sarudza "kugadzirwa".
- Fonera zita remubasa, uye nharo dzayo, pamurume, mushure mekunge chiratidzo chakaenzana ne (=) muchitokisi chaunoda, kana mune yefomari tambo.
Zvadaro, iwe unofanirwa kuwana basa rechigadzirwa, mune iyo inoshanda wizard hwindo rinovhura, uye tinya bhatani re "OK".
Shanda template yebhuku remagetsi iri seinotevera: "= kugadzirwa (nhamba (kana chinongedzo kune sero); nhamba (kana chinongedzo (kana chinongedzo); ... Ndokunge, kana semuenzaniso, tinoda makumi manomwe nenomwe, uye nekuwanda ne23, tobva tanyora nzira inotevera: "= yakagadzirwa (77; 57; 50; 55; 55; 55; Kuratidza mhedzisiro, tinya pane bhatani rekupinda.
Kana uchishandisa sarudzo mbiri dzekutanga dzekushandisa basa (uchishandisa formula formulas wizard), hwindo rekupokana rinovhura kupinda nharo nenzira yehuwandu, kana nharo. Izvi zvinogona kuitwa nekungodzvanya pamasero anodiwa. Mushure mekupinda nharo, tinya bhatani re "OK" kuita kuverenga, uye kubuditsa mhedzisiro pachiratidziro.
Sezvauri kuona, muChirongwa cheEkutanga pane nhamba huru yesarudzo dzekushandisa yakadaro arithmetic chiito sekuwedzera. Chinhu chikuru ndechekuziva iyo nuances yekushandisa mafomu mazhinji mune imwe neimwe.