Uzikhipha kanjani izinombolo ku-Excel - Izibonelo ezi-5 Ezisebenzayo

Isevisi yespredishithi ye-Microsoft Excel ivame ukusetshenziselwa ukuhlela idatha ngefomethi yezinombolo nokwenza izibalo kuyo. Ukukhipha kungomunye wemisebenzi yezibalo eyisisekelo, akukho nokubala okuyinkimbinkimbi okungakwenza ngaphandle kwakho. Kunezindlela ezimbalwa zokushumeka amaseli akhiphayo kuthebula, ngayinye yazo kuzoxoxwa ngayo ngokuningiliziwe ngezansi.

Ungawenza kanjani umsebenzi wokukhipha ku-Excel

Ukukhipha etafuleni kuyafana nasephepheni. Inkulumo kumelwe ibe ne-minuend, i-subtrahend, kanye nophawu “-” phakathi kwakho. Ungafaka i-minuend bese ukhipha ngesandla noma ukhethe amaseli ngale datha.

Nakani! Kunesimo esisodwa esihlukanisa ukususa ku-Excel ekusebenzeni okuvamile. Yonke imisebenzi kulolu hlelo iqala ngophawu olulinganayo. Uma ungalubeki lolu phawu ngaphambi kwesisho esibhaliwe, umphumela ngeke uvele kuseli ngokuzenzakalelayo. Uhlelo luzobona okubhalwe njengombhalo. Ngalesi sizathu, kubalulekile ukubeka uphawu “=" njalo ekuqaleni.

Kudingekile ukwenza ifomula ngophawu "-", hlola ukufaneleka kokukhetha kwamaseli noma ukufakwa kwezinombolo bese ucindezela u- "Enter". Kuseli lapho ifomula yabhalwa khona, umehluko wezinombolo ezimbili noma ngaphezulu uzovela ngokushesha. Ngeshwa, ayikho ifomula yokukhipha eseyenziwe ngomumo Kumphathi Womsebenzi, ngakho-ke kufanele uhambe ngezinye izindlela. Ukusebenzisa ikhathalogi yamafomula kuzosebenza kuphela ezibalweni eziyinkimbinkimbi, isibonelo, lezo ezisebenzisa izinombolo eziyinkimbinkimbi. Ake sibheke zonke izindlela zokusebenza ngezansi.

inqubo yokukhipha

Okokuqala, njengoba kushiwo, udinga ukubhala uphawu olulinganayo ngesikhathi semisebenzi noma kuseli ngokwayo. Lokhu kubonisa ukuthi inani leseli lilingana nomphumela womsebenzi wezibalo. Ngaphezu kwalokho, enkulumweni, okuncishisiwe kufanele kuvele - inombolo ezokwehla ngenxa yesibalo. Inombolo yesibili iyasuswa, eyokuqala iba mncane ngayo. Ukukhipha kubekwa phakathi kwezinombolo. Awudingi ukwenza ideshi kusuka ku-hyphen, ngaphandle kwalokho isenzo ngeke sisebenze. Ake sihlole izindlela ezinhlanu zokukhipha kumaspredishithi e-Excel. Umsebenzisi ngamunye uzokwazi ukuzikhethela indlela elula kulolu hlu.

Isibonelo 1: Umehluko Wezinombolo Ezithize

Ithebula liyadwetshwa, amaseli agcwalisiwe, kodwa manje udinga ukususa inkomba eyodwa kwenye. Ake sizame ukususa inombolo eyodwa eyaziwayo kwenye.

1. Okokuqala udinga ukukhetha iseli lapho umphumela wokubala uzoba khona. Uma kukhona ithebula eshidini, futhi linekholomu yamanani anjalo, kufanele ume kwelinye lamaseli akule kholomu. Esibonelweni, sizocabangela ukususa ngeseli engahleliwe.
2. Chofoza kabili kuyo ukuze kuvele inkambu ngaphakathi. Kulo mkhakha, udinga ukufaka isisho ngendlela echazwe ngaphambilini: uphawu “=", luncishisiwe, khipha futhi lukhishwe. Ungaphinda ubhale isisho emugqeni wokusebenza, otholakala ngenhla kweshidi. Umphumela wazo zonke lezi zenzo ubukeka kanje:

Nakani! Kungaba nanoma iyiphi inombolo yama-subtrahends, kuya ngenhloso yokubala. Ngaphambi kwalowo nalowo kubo, i-minus iyadingeka, ngaphandle kwalokho izibalo ngeke zenziwe ngendlela efanele.

3. Uma izinombolo zenkulumo nezinye izingxenye zayo zibhalwe ngendlela efanele, kufanele ucindezele inkinobho ethi “Enter” kukhibhodi. Umehluko uzovela ngokushesha kuseli ekhethiwe, futhi kulayini wokusebenza ungabuka isisho esibhaliwe bese usihlolela amaphutha. Ngemva kokwenza izibalo ezizenzakalelayo, isikrini sibukeka kanje:

I-spreadsheet i-Microsoft Excel nayo yakhelwe ukubala okulula, ngakho-ke isebenza ngezinombolo eziphozithivu nezingezinhle. Akudingekile ukuthi i-minuend ibe inombolo enkulu, kodwa umphumela uzoba ngaphansi kuka-zero.

Isibonelo sesi-2: ukukhipha inombolo kuseli

Ukusebenza ngamaseli wetafula kuwumsebenzi oyinhloko we-Excel, ukuze ukwazi ukwenza izenzo ezihlukahlukene ngawo. Isibonelo, ungaqamba isisho sezibalo lapho iseli incishiswa futhi inombolo ikhishwa, noma okuphambene nalokho.

1. Isenzo sokuqala ukukhetha iseli yefomula futhi bese ufaka uphawu olulinganayo kuyo.
2. Okulandelayo, udinga ukwenza ngokuhlukile kunendlela yokuqala - udinga ukuthola iseli etafuleni ngenani elizokwehla ngenxa yokukhipha, bese uchofoza kulo. Uhlaka olunamachashazi oluhambahambayo lwakhiwa luzungeze leli seli, futhi ukuqokwa kwalo ngendlela yohlamvu nenombolo kuzovela kufomula.
3. Okulandelayo, sibeka uphawu "-", futhi ngemva kwalo sibhala ngesandla i-subtrahend kufomula. Kufanele uthole isisho esifana nalesi:

4. Ukuqala ukubala, udinga ukucindezela inkinobho ethi "Enter". Ngesikhathi sokubala, uhlelo luzokhipha inombolo kokuqukethwe kweseli. Ngendlela efanayo, umphumela uzovela kuseli ngefomula. Isibonelo somphumela:

Isibonelo sesi-3: umehluko phakathi kwezinombolo kumaseli

Akudingekile ukuthi inkulumo ibe nenombolo eyodwa - zonke izenzo zingenziwa ngamaseli kuphela. Lokhu kuyasiza uma kunamakholomu amaningi etafuleni futhi udinga ukubala ngokushesha umphumela wokugcina usebenzisa ukususa.

1. Isibalo siqala ngokubeka uphawu olulinganayo kuseli ekhethiwe.
2. Ngemva kwalokho, udinga ukuthola iseli equkethe minuend. Kubalulekile ukuthi ungaphambanisi izingxenye zetafula nomunye nomunye, ngoba ukususa kuhluke ekuhlanganiseni ngokulandelana okuqinile lapho kubhalwa khona inkulumo.
3. Ngemva kokuchofoza kuyo, umsebenzi uzoba negama ngendlela yemigqa nekholomu, isibonelo, A2, C12, njalonjalo. Faka ukususa bese uthola etafuleni iseli eline-subtrahend.
4. Udinga futhi ukuchofoza kukho, futhi inkulumo izophelela - ukuqokwa kwe-subtrahend kuzowela kuyo ngokuzenzakalelayo. Ungangeza imali edonswayo nezenzo eziningi ngendlela ofuna ngayo - uhlelo luzobala ngokuzenzakalelayo yonke into. Bheka ukuthi isisho sokugcina sibukeka kanjani:

5. Sicindezela ukhiye "Enter" futhi sithola umehluko phakathi kokuqukethwe kwamaseli amaningana ngaphandle kwezenzo ezingadingekile ngendlela yokukopisha noma ukufaka kabusha izinombolo ngesandla.

Kubalulekile! Umthetho oyinhloko wokusebenzisa le ndlela ukwenza isiqiniseko sokuthi amaseli kusisho asezindaweni ezifanele.

Isibonelo sesi-4: ukususa ikholomu kwenye

Kunezimo lapho udinga ukususa okuqukethwe kwamaseli ekholomu eyodwa kumaseli wenye. Akuvamile ukuthi abasebenzisi baqale ukubhala amafomula ahlukene omugqa ngamunye, kodwa lokhu kuyinqubo edla isikhathi kakhulu. Ukuze wonge isikhathi esichithwe ubhala inqwaba yezinkulumo, ungasusa ikholomu eyodwa kwenye ngomsebenzi owodwa.

Izizathu zokusebenzisa le ndlela zingase zihluke, kodwa enye yezinto ezivame kakhulu isidingo sokubala inzuzo. Ukuze wenze lokhu, udinga ukususa izindleko zezimpahla ezithengisiwe enanini lemali engenayo. Cabangela indlela yokukhipha usebenzisa lesi sibonelo:

1. Kudingeka uchofoze kabili kuseli eliphezulu lekholomu engenalutho, faka uphawu "=".
2. Okulandelayo, udinga ukudweba ifomula: khetha iseli elinemali engenayo, ulibeke ku-minus function ngemva kokuqokwa kwalo, bese uchofoza iseli ngezindleko.

Qaphela! Uma amaseli ekhethwe kahle, akufanele uchofoze kwezinye izakhi zeshidi. Kulula ukungaboni ukuthi i-minuend noma i-subtrahend ishintshe ngephutha ngenxa yephutha elinjalo.

3. Umehluko uzovela kuseli ngemva kokucindezela inkinobho ethi “Enter”. Ngaphambi kokwenza ezinye izinyathelo, udinga ukwenza ukubala.

4. Bheka ekhoneni elingezansi kwesokudla seseli ekhethiwe - kukhona isikwele esincane. Uma uhambisa phezu kwayo, umcibisholo uphenduka ube isiphambano esimnyama - lokhu umaka wokugcwalisa. Manje udinga ukubamba phansi ekhoneni elingezansi kwesokudla seseli ngekhesa bese uhudulela phansi kuseli lokugcina elifakwe kuthebula.

Kubalulekile! Ukukhetha amaseli aphansi ngemva kokubopha uhlaka lweseli engenhla kwezinye izindawo ngeke kuholele ekudlulisweni kwefomula emigqeni engezansi.

5. Ifomula yokukhipha izoya kuseli ngalinye lekholomu, esikhundleni se-minuend ne-subtrahend ngomugqa wokukhomba ohambisanayo. Nansi indlela ebukeka ngayo:

Isibonelo sesi-5: ukukhipha inombolo ethile kukholomu

Kwesinye isikhathi abasebenzisi bafuna ukuthi kube noshintsho oluyingxenye kuphela lapho bekopisha, okungukuthi, lelo seli elilodwa kumsebenzi lihlala lingashintshiwe. Lokhu kungenzeka futhi ngenxa yesipredishithi seMicrosoft Excel.

1. Kufanele uqale futhi ngokukhetha iseli yamahhala nezakhi zenkulumo, ubeke izimpawu “=" kanye “-“. Cabanga ukuthi esimweni esithile, i-subtrahend kufanele ihlale ingashintshiwe. Ifomula ithatha ifomu elijwayelekile:

2. Ngaphambi kokuphawula kweseli engaphansi, incwadi kanye nenombolo, udinga ukubeka izimpawu zamadola. Lokhu kuzolungisa i-subtrahend kufomula, ngeke kuvumele iseli ukuthi lishintshe.

3. Masiqale ukubala ngokuchofoza inkinobho ethi “Faka”, kuzovela inani elisha emugqeni wokuqala wekholomu.
4. Manje usungakwazi ukugcwalisa ikholomu yonke. Kuyadingeka ukubamba umaka ekhoneni elingezansi kwesokudla seseli yokuqala bese ukhetha izingxenye ezisele zekholomu.

5. Isibalo sizokwenziwa ngawo wonke amaseli adingekayo, kuyilapho i-subtrahend ngeke ishintshe. Ungahlola lokhu ngokuchofoza kwelinye lamaseli akhethiwe - inkulumo egcwaliswe ngayo izovela emugqeni wokusebenza. Inguqulo yokugcina yethebula ibukeka kanje:

Iseli elincishisiwe lingase libe iseli elihlala njalo - kuya ngokuthi zifakwa kuphi izimpawu "$". Isibonelo esibonisiwe siyicala elikhethekile, ifomula akudingeki ukuthi ibukeke kanje. Inombolo yezingxenye zenkulumo ingaba yinoma iyiphi.

Ukukhipha izinombolo ngezikhawu

Ungakwazi ukususa inombolo eyodwa kokuqukethwe ikholomu usebenzisa umsebenzi we-SUM.

1. Khetha iseli yamahhala bese uvula "Umphathi Womsebenzi".
2. Udinga ukuthola umsebenzi we-SUM bese uwukhetha. Kuzovela iwindi lokugcwalisa umsebenzi ngamavelu.
3. Sikhetha wonke amaseli omugqa oncishisiwe, lapho kukhona amanani, isikhawu sizowela emgqeni "Inombolo 1", umugqa olandelayo awudingi ukugcwaliswa.

4. Ngemuva kokuchofoza inkinobho ethi "KULUNGILE", isamba sawo wonke amaseli oncishisiwe azovela efasiteleni lokukhetha inombolo esitokisini, kodwa lokhu akukona ukuphela - udinga ukususa.
5. Chofoza kabili kuseli ngefomula bese wengeza uphawu lokususa ngemva kukabakaki wokuvala.
6. Okulandelayo, udinga ukukhetha iseli ezokhishwa. Ngenxa yalokho, ifomula kufanele ibukeke kanje:

7. Manje ungacindezela u-"Enter", futhi umphumela oyifunayo uzovela kuseli.
8. Esinye isikhawu singasuswa, ngenxa yalokhu udinga ukusebenzisa umsebenzi we-SUM futhi ngemva kokukhipha. Ngenxa yalokho, isikhawu esisodwa siyasuswa kwesinye. Ake sengeze kancane ithebula ngamavelu kukholamu ye-subtrahend ukuze kucace:

Umsebenzi we-IMSUBTR

Ku-, lo msebenzi ubizwa nge-IMNIM.DIFF. Lona omunye wemisebenzi yobunjiniyela, ngosizo lwayo ungakwazi ukubala umehluko wezinombolo eziyinkimbinkimbi. Inombolo eyinkimbinkimbi iqukethe amayunithi angempela nawomqondo. Ngaphandle kweqiniso lokuthi kukhona ukuhlanganisa phakathi kwamayunithi, le notation iyinombolo eyodwa, hhayi isisho. Eqinisweni, akunakwenzeka ukucabanga into enjalo, kuyizibalo kuphela. Izinombolo eziyinkimbinkimbi zingamelwa endizeni njengamaphoyinti.

Umehluko ocatshangwayo uyinhlanganisela yomehluko phakathi kwezingxenye zangempela nezicatshangelwayo zenombolo eyinkimbinkimbi. Umphumela wokukhipha ngaphandle kwethebula:

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

10-7 3 =

2i-10i= -8i

1. Ukuze wenze izibalo, khetha iseli elingenalutho, vula “Umphathi Womsebenzi” bese uthola umsebenzi othi IMAGINARY DIFF. Itholakala esigabeni esithi “Engineering”.
2. Ewindini lokukhetha izinombolo, udinga ukugcwalisa yomibili imigqa - ngamunye kufanele ube nenombolo eyodwa eyinkimbinkimbi. Ukuze wenze lokhu, chofoza umugqa wokuqala, bese - esitokisini sokuqala esinenombolo, yenza okufanayo ngomugqa wesibili neseli. Ifomula yokugcina ibukeka kanje:

3. Okulandelayo, cindezela "Enter" futhi uthole umphumela. Akukho okungaphansi kokukodwa kufomula, ungakwazi ukubala umehluko ongokomfanekiso wamaseli amabili kuphela.

Isiphetho

Amathuluzi e-Excel enza ukususa kube lula ukusebenza kwezibalo. Uhlelo lukuvumela ukuthi wenze zombili izenzo ezilula ngophawu lokususa, futhi uzibandakanye ezibalweni ezigxile kancane usebenzisa izinombolo eziyinkimbinkimbi. Usebenzisa izindlela ezichazwe ngenhla, ungenza okuningi ngenkathi usebenza ngamatafula.