Shanda neFordelas muExcel

Chimwe chezvinhu chikuru cheMicrosoft Excel ndiko kugona kushanda pamwe mafomula. Izvi zvine simba zvikuru uye nekumhanya maitiro ekuverenga zvakajairika mhedzisiro uye kuratidza iyo inodiwa data. Ngatione kuti tichagadzira mafomula uye sei kushanda navo muchirongwa.

Kugadzira iyo yakapfava mafomula muExcel

Iyo yakapfava mafomu ezvidavho ari exle's mazwi eArithmetic chiito pakati pe data iri mumasero. Kuti ugadzire fomu yakafanana, kutanga pane zvese isu tinonyora chiratidzo chekuenzana muchitokisi ichocho, mazviri chakagadzirirwa kubvisa mhedzisiro yekubva kubva kuArithmetic chiito. Kana iwe unogona kusimbisa iyo sero, asi isa chiratidzo chehurongwa hwekuenzana mune formula tambo. Aya manipulations akaenzana uye akangodzokorora.

Wobva wasarudza imwe sero yakazadzwa nedata, uye isa chiratidzo chaunoda arithmetic ("+" "" - "" "" ",", "", ", nezvimwewo). Zviratidzo zvakadaro zvinodaidzwa kunzi Foraters Operator. Zvino sarudza iyo inotevera sero uye dzokorora zviito neimwe nzira kusvika masero ese anodikanwa anobatanidzwa. Mushure mekutaura kwapera zvakakwana, tinya Enter pane iyo keyboard kuratidza kuverenga.

Excel kuverenga

Ngatiti isu tine tafura umo huwandu hwezvinhu zvinoratidzwa, uye mutengo wemauniti wawo. Isu tinofanirwa kutsvaga huwandu hwakazara hwekukosha kwezita rega rega rechigadzirwa. Izvi zvinogona kuitwa nekuwedzera iyo nhamba pamutengo wezvinhu.

1. Isu tinosarudza sero panofanira kuratidzwa huwandu, uye isa ipapo =. Tevere, isu tinosimbisa sero nehuwandu hwezvinhu - chinongedzo kune icho chinobva charatidza kuti chinoratidzika mushure mechiratidzo chekuenzana. Mushure mekuronga kwesero iwe unofanirwa kuisa chiratidzo chechiratidzo. Kwatiri, ichava chiratidzo chekuwedzera - *. Zvino tinya pachiteshi, uko data rinoiswa nemutengo wechinhu chezvinhu zvezvinhu. Iyo arithmetic formula yakagadzirira.



2. Kuti utarise mhedzisiro, tinya Enter.



3. Kuitira kuti usapinda iyi formula nguva dzese kuverenga kukosha kwezita rega rega rechigadzirwa, Hover The Commor kukona yekurudyi yeSero nemhedzisiro yacho zvinhu zvinowanikwa.



4. Iyo formula yakaiswa uye iyo yakazara mutengo otomatiki otomatiki kune imwe neimwe mhando yechigadzirwa, maererano nedata pane huwandu hwayo uye mutengo.

Saizvozvo, iwe unogona kuverenga mafomula mune akati wandei zviito uye nezviratidzo zvakasiyana arithmetic. Muchokwadi, Excel mafomula inonyorwa zvinoenderana nemisimboti imwechete iyo iyo yakajairika arithmetic mienzaniso inoitwa mune masvomhu. Inoshandisa inenge yakafanana neyntax.

Pedzisa basa racho, kukamura huwandu hwezvinhu zviri patafura mumapati maviri. Zvino, kuti uwane mutengo wakazara, iwe unofanirwa kutanga wapeta huwandu hwemapato ese echigadzirwa uye mhedzisiro yacho yakawedzerwa nemutengo. MuArithmetic, kuverenga kwakadaro kunoitwa uchishandisa mabhureki, zvikasadaro zvekutanga kuita kuchaitwa kuwanda, izvo zvichatungamira mukuverenga zvisiri izvo. Isu tinoshandisa ivo uye kugadzirisa basa racho muExcel.

1. Saka, isu tinonyora = muchitokisi chekutanga checumn "huwandu". Ipapo tinovhura bracket, tinya pachiteshi chekutanga mu "1 pati" ikhoramu, isa + tinya pasero rekutanga mu "2 batch" mutsara. Tevere, tinovhara bracket uye set *. Dzvanya pane yekutanga Sero mu "Mutengo" Column - saka isu tine formula.



2. Dzvanya ENTER kuti uzive mhedzisiro yacho.



3. Sezvinoita nguva yekupedzisira, uchishandisa nzira yekudhonza kopi iyi formula uye kune mamwe mitsara yetafura.



4. Izvo zvinofanirwa kucherechedzwa kuti hazvisi hazvo zvese izvi mafomula zvinofanirwa kuve mumasero emuvakidzani kana mukati memiganhu ye tafura imwe. Ivo vanogona kuve mune imwe tafura kana kunyange pane rimwe pepa regwaro. Chirongwa ichi chichiri kuverenga nenzira kwayo.

Uchishandisa Excel seCalculator

Kunyangwe basa guru rechirongwa ndere kuverenga mumatafura, rinogona kushandiswa seCalculator iri nyore. Isu tinopinda chiratidzo chakaenzana uye tikaisa nhamba dzavanoda uye vashandisi mune chero sero rebepa kana mune formula tambo.

Kuwana mhedzisiro, pinda Enter.

Basic Excel Operators

Iwo mainonyanya kuverenga vashandisi vanoshandiswa muMicrosoft Excel vanosanganisira zvinotevera:

• = ("Chiratidzo chekuenzana") - zvakaenzana;
• + ("Kuwedzera") - Kuwedzera;
• - ("minus") - kubvisa;
• * ("Nyeredzi") - Kuwedzera;
• / ("Inosimbisa hunhu") - kupatsanurana;
• ^ ("Repartlex") - kurovedza muviri.

Microsoft Excel inopa yakazara mushandisi yekushandisa yekushandisa kuita zvakasiyana-siyana arithmetic chiito. Vanogona kuitwa vari vaviri mukugadzirira matafura uye zvakasiyana kuti vaunganidze mhedzisiro yemamwe mashandiro ehumwe.