Maitiro ekubvisa manhamba muExcel - 5 Mienzaniso Inoshanda

Iyo Microsoft Excel spreadsheet sevhisi inowanzo shandiswa kuronga data mune nhamba fomati uye kuita masvomhu pairi. Kubvisa ndeimwe yeakakosha masvomhu mashandiro, hapana kana imwe yakaoma kuverenga inogona kuita pasina iyo. Pane nzira dzinoverengeka dzekumisikidza subtractive masero mutafura, imwe neimwe ichakurukurwa zvakadzama pazasi.

Maitiro ekuita kubvisa basa muExcel

Kubvisa mutafura kwakafanana nepapepa. Chirevo chacho chinofanira kunge chine minuend, subtrahend, uye "-" chiratidzo pakati pazvo. Iwe unogona kuisa minuend uye subtrahend nemaoko kana kusarudza maseru ane iyi data.

Teerera! Pane chimiro chimwe chinosiyanisa kubvisa muExcel kubva kune yakajairika kushanda. Chese basa muchirongwa ichi chinotanga nechiratidzo chakaenzana. Kana ukasaisa chiratidzo ichi pamberi pekutaura kwakagadzirwa, mhedzisiro haizoonekwe muchitokisi otomatiki. Iyo purogiramu ichaona zvakanyorwa semavara. Nechikonzero ichi, zvakakosha kugara uchiisa chiratidzo "=" pakutanga.

Izvo zvinodikanwa kugadzira fomula ine "-" chiratidzo, tarisa kurongeka kwesarudzo yemasero kana kupinda kwenhamba uye tinya "Enter". Musero makanyorwa fomula, musiyano wenhamba mbiri kana kupfuura unobva waoneka. Nehurombo, hapana yakagadzirira-yakagadzirwa yekubvisa formula muBasa Maneja, saka unofanirwa kuenda dzimwe nzira. Kushandisa catalogue yemafomula kunongoshanda kune mamwe macalculation akaoma, semuenzaniso, ayo anoshandisa manhamba akaomarara. Ngatitarisei nzira dzese dzekushanda pazasi.

nzira yekubvisa

Kutanga, sezvakataurwa, unoda kunyora chiratidzo chakaenzana muzwi remabasa kana musero pachayo. Izvi zvinoratidza kuti kukosha kwesero kwakaenzana nemugumisiro wekushanda kwemasvomhu. Uyezve, mukutaura, imwe yakaderedzwa inofanira kuonekwa - nhamba inozove shoma semugumisiro wekuverenga. Nhamba yechipiri inobviswa, yekutanga inova shoma nayo. A minus inoiswa pakati penhamba. Iwe haufanirwe kuita dash kubva kune hyphen, zvikasadaro chiito hachishande. Ngationgororei nzira shanu dzekubvisa muExcel spreadsheets. Wese mushandisi achakwanisa kuzvisarudzira nzira yakanakira ivo kubva pane iyi runyorwa.

Muenzaniso 1: Musiyano Wenhamba Dzakananga

Iyo tafura inodhirowewa kumusoro, masero akazadzwa, asi ikozvino iwe unofanirwa kubvisa imwe chiratidzo kubva kune imwe. Ngatiedzei kubvisa imwe nhamba inozivikanwa kubva kune imwe.

1. Kutanga iwe unoda kusarudza sero umo mugumisiro wekuverenga uchava. Kana pane tafura pane pepa, uye iine mbiru yezvinokosha zvakadaro, unofanira kumira pane imwe yemasero ari mumutsara uyu. Mumuenzaniso, isu tichafunga nezvekubvisa musero isina kujairika.
2. Dzvanya kaviri pairi kuitira kuti munda uoneke mukati. Mundima iyi, unofanirwa kuisa chirevo muchimiro chakatsanangurwa kare: chiratidzo "=", kuderedzwa, minus chiratidzo uye kubviswa. Iwe unogona zvakare kunyora chirevo mumutsara webasa, uri pamusoro pepepa. Mhedzisiro yezviito izvi zvese zvinotaridzika seizvi:

Teerera! Panogona kuve nechero nhamba ye subtrahends, zvinoenderana nechinangwa chekuverenga. Pamberi peumwe neumwe wavo, minus inodiwa, kana zvisina kudaro kuverenga hakuzoitwe nemazvo.

3. Kana nhamba dziri mukutaura uye zvimwe zvikamu zvaro zvakanyorwa nemazvo, unofanira kudzvanya kiyi "Enter" pane keyboard. Musiyano unobva wangooneka musero rakasarudzwa, uye mumutsara webasa unogona kuona chirevo chakanyorwa uye chekutarisa pane zvikanganiso. Mushure mekuita otomatiki kuverenga, skrini inotaridzika seizvi:

The spreadsheet Microsoft Excel yakagadzirirwawo kuverenga zviri nyore, saka inoshanda nenhamba dzakanaka uye dzisina kunaka. Hazvidikanwi kuti minuend ive nhamba huru, asi zvino chigumisiro chichava pasi pe zero.

Muenzaniso 2: kubvisa nhamba kubva musero

Kushanda nemasero etafura ndiro basa guru reExcel, saka iwe unogona kuita zvakasiyana-siyana zviito navo. Semuenzaniso, unogona kunyora chirevo chesvomhu apo sero rinoderedzwa uye nhamba yobviswa, kana zvakasiyana.

1. Chiito chekutanga ndechekusarudza sero reformula zvakare uye woisa chiratidzo chakaenzana mairi.
2. Zvadaro, unofanirwa kuita zvakasiyana pane nenzira yekutanga - unoda kuwana sero mutafura ine kukosha kunoderera semugumisiro wekubvisa, uye chengeta pairi. Nharembozha ine doti rondedzero inoumbwa yakatenderedza sero iri, uye zita rayo muchimiro chebhii nenhamba zvinozoonekwa mufomula.
3. Zvadaro, tinoisa chiratidzo che "-", uye mushure mezvo isu tinonyora pasi subtrahend mufomu. Iwe unofanirwa kuwana chirevo chakadai:

4. Kuti utange kuverenga, unofanirwa kudzvanya "Enter" kiyi. Panguva yekuverenga, purogiramu ichabvisa nhamba kubva kune zviri mukati mesero. Nenzira imwecheteyo, mhedzisiro ichaonekwa musero ine formula. Muenzaniso wemhedzisiro:

Muenzaniso 3: musiyano pakati penhamba mumaseru

Hazvina kudikanwa kuti chirevo chacho chine nhamba imwe chaiyo - zviito zvose zvinogona kuitwa chete nemasero. Izvi zvinobatsira kana paine makoramu akawanda patafura uye iwe unofanirwa kukurumidza kuverenga mhedzisiro uchishandisa kubvisa.

1. Iko kuverenga kunotanga nekuisa chiratidzo chakaenzana musero rakasarudzwa.
2. Mushure meizvozvo, iwe unofanirwa kuwana sero rine minuend. Zvakakosha kuti usapesanisa zvikamu zvetafura kune mumwe nemumwe, nokuti kubvisa kunosiyana nekuwedzera muhurongwa hwakasimba hunonyorwa mazwi.
3. Mushure mekudzvanya pairi, basa racho richava nezita muchimiro chemutsara uye makoramu mazita, semuenzaniso, A2, C12, zvichingodaro. Isa minus uye tsvaga mutafura sero ine subtrahend.
4. Iwe zvakare unofanirwa kudzvanya pairi, uye chirevo chinozove chakazara - iyo zita reiyo subtrahend inongowira mairi. Iwe unogona kuwedzera akawanda anobviswa uye zviito sezvaunoda - chirongwa chinozoverengera zvese. Tarisa uone kuti izwi rekupedzisira rinotaridzika sei:

5. Isu tinodzvanya kiyi ye "Enter" uye tinowana mutsauko pakati pezviri mukati memasero akati wandei pasina zviito zvisina basa nenzira yekukopa kana kuisazve manhamba.

Zvinokosha! Mutemo mukuru wekushandisa nzira iyi kuve nechokwadi chekuti masero ari mukutaura ari munzvimbo dzakakodzera.

Muenzaniso 4: kubvisa imwe koramu kubva kune imwe

Pane zviitiko apo iwe unofanirwa kubvisa zviri mukati memasero eimwe column kubva kumaseru eimwe. Hazvisi zvisizvo kuti vashandisi vatange kunyora mafomula akasiyana emutsetse wega wega, asi iyi inguva inopedza nguva. Kuti uchengetedze nguva yakashandiswa kunyora akawanda ezvirevo, unogona kubvisa koramu imwe kubva kune imwe nebasa rimwechete.

Zvikonzero zvekushandisa nzira iyi zvinogona kusiyana, asi chimwe chezvakawanda kudiwa kwekuverenga purofiti. Kuti uite izvi, unofanirwa kubvisa mutengo wezvinhu zvinotengeswa kubva pahuwandu hwemari. Funga nezve nzira yekubvisa uchishandisa iyi muenzaniso:

1. Izvo zvinodikanwa kudzvanya kaviri pasero repamusoro rekoramu isina chinhu, isa iyo "=" chiratidzo.
2. Tevere, iwe unofanirwa kudhirowa fomula: sarudza sero nemari, isa muminus basa mushure mekudomwa kwayo, uye tinya pane sero nemutengo.

Chenjerera! Kana maseru akasarudzwa nemazvo, haufanirwe kudzvanya pane zvimwe zvinhu zvebepa. Zviri nyore kusaona kuti minuend kana subtrahend yachinja netsaona nekuda kwekukanganisa kwakadaro.

3. Musiyano uchaonekwa muchitokisi mushure mekudzvanya "Enter" kiyi. Usati waita mamwe matanho, unofanirwa kumhanya kuverenga.

4. Tarisa pakona yekurudyi yekona yakasarudzwa sero - pane diki diki. Paunofamba pamusoro payo, museve unoshanduka kuita muchinjikwa mutema - ichi chiratidzo chekuzadza. Iye zvino iwe unofanirwa kubata pasi pasi pakona yekurudyi yesero nechisungo uye kukwevera pasi kune yekupedzisira sero inosanganisirwa mutafura.

Zvinokosha! Kusarudza maseru ezasi mushure mekurovera ratidziro yekumusoro sero mune dzimwe nzvimbo hakuzotungamira mukufambiswa kwefomula kune mitsetse iri pazasi.

5. Iyo yekubvisa fomula inoenda kune imwe neimwe sero yekoramu, ichitsiva minuend uye subtrahend neinoenderana mutsara wezita. Hezvino zvazvinoita:

Muenzaniso 5: kubvisa nhamba chaiyo kubva mukoramu

Dzimwe nguva vashandisi vanongoda shanduko shoma kuti iitike kana uchikopa, ndiko kuti, sero rimwe riri mubasa rinoramba risina kuchinjwa. Izvi zvinogoneka zvakare nekuda kwespredishiti Microsoft Excel.

1. Iwe unofanirwa kutanga zvakare nekusarudza sero remahara uye zvinhu zvekutaura, uchiisa zviratidzo "=" uye "-". Fungidzira kuti mune imwe nyaya, iyo subtrahend inofanira kuramba isina kuchinjwa. Iyo formula inotora yakajairwa fomu:

2. Pamberi pezvinyorwa zve subtrahend cell, tsamba uye nhamba, unofanirwa kuisa zviratidzo zvemadhora. Izvi zvichagadzirisa subtrahend mufomula, hazvibvumire sero kuchinja.

3. Ngatitangei kuverenga nekudzvanya pa "Enter" kiyi, kukosha kutsva kuchaonekwa mumutsara wekutanga wekoramu.
4. Iye zvino unogona kuzadza mutsara wose. Izvo zvinodikanwa kubata chiratidzo mukona yezasi yekurudyi yesero rekutanga uye sarudza zvikamu zvasara zvekoramu.

5. Iko kuverenga kuchaitwa nemaseru ese anodiwa, nepo subtrahend isingashanduke. Iwe unogona kutarisa izvi nekudzvanya pane imwe yemasero akasarudzwa - chirevo icho chakazadzwa nacho chichaonekwa mumutsara webasa. Iyo yekupedzisira vhezheni yetafura inoita seizvi:

Sero rakaderedzwa rinogonawo kuva sero zvachose - zvinoenderana nekuisa kupi "$" zviratidzo. Muenzaniso unoratidzwa inyaya yakakosha, fomula haifanire kutaridzika seizvi. Nhamba yezvikamu zvekutaura zvinogona kuva chero.

Kubvisa nhamba muzvikamu

Iwe unogona kubvisa nhamba imwe chete kubva pane zviri mukati mekororamu uchishandisa iyo SUM basa.

1. Sarudza sero yemahara uye vhura iyo "Function Manager".
2. Iwe unofanirwa kutsvaga iyo SUM basa uye sarudza iyo. Hwindo richaonekwa rekuzadza basa nemakoshero.
3. Isu tinosarudza masero ose emutsara wezvakaderedzwa, uko kune maitiro, nguva yacho ichawira mumutsara "Nhamba 1", mutsara unotevera haudi kuzadzwa.

4. Mushure mekudzvanya bhatani re "OK", chiyero chemasero ese eakaderedzwa achaonekwa muhwindo rekusarudza nhamba muchitokisi, asi iyi haisi magumo - unofanirwa kubvisa.
5. Dzvanya kaviri pasero neformula woisa minus sign mushure mekuvhara bracket.
6. Zvadaro, unofanira kusarudza sero kubviswa. Nekuda kweizvozvo, iyo formula inofanirwa kutaridzika seizvi:

7. Iye zvino unogona kudzvanya "Enter", uye mhedzisiro yaunoda ichaonekwa muchitokisi.
8. Imwe nguva inogona kuderedzwa, nekuda kweizvi iwe unofanirwa kushandisa iyo SUM basa zvakare mushure meminus. Somugumisiro, imwe nguva inobviswa kubva kune imwe. Ngatiwedzerei zvishoma tafura ine kukosha mu subtrahend column kuti ijekeswe:

IMSUBTR basa

Muna , basa iri rinonzi IMNIM.DIFF. Iyi ndeimwe yemabasa einjiniya, nerubatsiro rwayo unogona kuverenga mutsauko wenhamba dzakaoma. Nhamba yakaoma ine mayuniti chaiwo uye ekufungidzira. Zvisinei nekuti pane kuwedzera pakati pemayuniti, notation iyi inhamba imwe chete, kwete kutaura. Muchokwadi, hazvibviri kufungidzira chiitiko chakadaro, inongova masvomhu. Nhamba dzakaoma dzinogona kumiririrwa mundege semapoinzi.

Musiyano wekufungidzira kusanganiswa kwemisiyano pakati pezvikamu zvechokwadi uye zvekufungidzira zvenhamba yakaoma. Mhedzisiro yekubvisa kunze kwetafura:

(10+2i)-(7+10i) = 3-8i

10-7 3 =

2i-10i= -8i

1. Kuti uite kuverenga, sarudza sero isina chinhu, vhura iyo "Function Manager" uye tsvaga basa IMAGINARY DIFF. Inowanikwa muchikamu che "Engineering".
2. Muwindo rekusarudza nhamba, unoda kuzadza mitsara miviri - imwe neimwe inofanira kuva nenhamba imwe yakaoma. Kuti uite izvi, tora pamutsara wekutanga, uye ipapo - pane sero yekutanga ine nhamba, ita zvakafanana nemutsara wechipiri uye sero. Iyo yekupedzisira formula inoita seizvi:

3. Tevere, tinya "Enter" uye uwane mhedzisiro. Iko hakuna inopfuura imwe subtrahend mune fomula, unogona kuverenga mutsauko wekufungidzira wemasero maviri chete.

mhedziso

Zvishandiso zveExcel zvinoita kuti kubvisa kuve nyore kushanda kwemasvomhu. Chirongwa ichi chinokutendera kuti uite ese ari maviri zviito zviri nyore nechiratidzo cheminus, uye kuita masvomhu akatarisana nekuverenga uchishandisa nhamba dzakaoma. Uchishandisa nzira dzakatsanangurwa pamusoro apa, unogona kuita zvakawanda uchishanda nematafura.