Ukusebenza ububanzi obuqanjwe ku-Microsoft Excel

Enye yamathuluzi elula ukusebenza ngamafomula futhi ikuvumela ukuba ukwandise umsebenzi ngemigqa yedatha yisabelo samagama kulezi zigaba. Ngakho-ke, uma ufuna ukubheka uhla lwemininingwane ehambisanayo, awudingi ukubhalela isixhumanisi esiyinkimbinkimbi, kodwa okwanele ukukhombisa igama elilula, owake wachaza ngaphambili. Ake sithole ukuthi yiziphi izinhlayiyana kanye nezinzuzo zokusebenza ngezigaba eziqanjwe ngamagama.

Indawo ebizwa ngokuthi i-manipulations

Ububanzi obuqanjwe yiyona ndawo yamaseli abelwe igama elithile ngumsebenzisi. Kulesi simo, leli gama libhekwa yi-Excel njengekheli lendawo ecacisiwe. Ingasetshenziselwa amafomula kanye nezimpikiswano zomsebenzi, kanye namathuluzi akhethekile we-Excel, isibonelo, "Ukuqinisekisa Amanani Wokufaka".

Kunezidingo ezidingekayo zegama leqembu lamaseli:

  • Akufanele kube nezikhala;
  • Kumele uqale ngencwadi;
  • Ubude bayo akumele kudlulele izinhlamvu ezingu-255;
  • Akufanele imelwe yizixhumanisi zefomu. A1 noma R1C1;
  • Le ncwadi akufanele ibe igama elifanayo.

Igama lendawo yeseli lingabonakala uma likhethwa egameni legama, elitholakala ngakwesokunxele kwibha yefomula.

Uma igama lingabelwe ebangeni, bese kunsimu engenhla, uma kuqokonyiswa, ikheli leseli eliphezulu elingakwesokunxele lombhalo liyaboniswa.

Ukwakha ububanzi obuqanjwe

Okokuqala, funda indlela yokwakha ububanzi obuqanjwe ku-Excel.

  1. Indlela esheshayo futhi elula yokwabela igama ohlwini kumele uyilobe ensimini egameni ngemuva kokukhetha indawo ehambelana nayo. Ngakho, khetha uhlu bese ungena ensimini igama esiyicabanga ukuthi liyadingeka. Kuyinto efiselekayo ukuthi ikhunjulwa kalula futhi ihambisana nokuqukethwe kwamaseli. Futhi-ke, kuyadingeka ukuthi ihlangabezana nezimfuneko ezidingekayo ezibekwe ngenhla.

  2. Ukuze uhlelo lufake leli gama kubhaliso walo bese ulumkhumbula, chofoza ukhiye Ngena. Igama lizokwabiwa endaweni yeseli ekhethiwe.

Ngasenhla ibizwe ngokuthi yiyona ndlela yokusheshisa igama elinikezwayo, kodwa likude kuphela. Le nqubo ingenziwa futhi ngokusebenzisa imenyu yokuqukethwe.

  1. Khetha uhlu ofuna ukwenza ngalo ukusebenza. Sichofoza ekukhethweni nge inkinobho yegundane kwesokudla. Kulolu hlu oluvula, hlela ukukhethwa kukho okukhethwa kukho "Yika igama ...".

  2. Iwindi lokudala igama livuleka. Endaweni "Igama" igama kufanele liqhutshwe ngokuhambisana nezimo ezibalulwe ngenhla. Endaweni "Range" ibonisa ikheli le-array ekhethiwe. Uma ukhethe kahle, awudingi ukwenza izinguquko kule ndawo. Chofoza inkinobho "Kulungile".

  3. Njengoba ungabona egameni legama, igama lesifunda linikezwe ngempumelelo.

Olunye uhlobo lomsebenzi luhilela ukusetshenziswa kwamathuluzi kule tape.

  1. Khetha indawo yamaseli ofuna ukuguqula kuwo obizwa ngokuthi. Hambisa kuthebhu "Amafomula". Eqenjini "Amagama aqondile" chofoza kusithonjana "Bika igama".

  2. Ivula iwindi elifanayo lokubiza igama njengalokhu kunguqulo yangaphambilini. Yonke imisebenzi eqhubekayo yenziwa ngokufanayo ngokufanayo.

Okukhethwa kukho kokugcina ngokunikezela igama lesigcawu se-cell, esizobheka, ukusebenzisa Umphathi wegama.

  1. Khetha uhlu. Ithebhu "Amafomula"sicindezela kusithonjana esikhulu Umphathi wegamakonke okukhona eqenjini elifanayo "Amagama aqondile". Ngaphandle kwalokho, ungasebenzisa isinqamuleli sekhibhodi esikhundleni. Ctrl + F3.

  2. Iwindi elisebenzayo Umphathi wegama. Kufanele uchofoze inkinobho "Dala ..." ekhoneni eliphezulu elingakwesokunxele.

  3. Khona-ke, ifasitela lokudala lefayili elaziwa kakade liqalisiwe, lapho udinga khona ukufeza izinyathelo ezixoxwe ngenhla. Igama elizokwabiwa kuhlu liboniswa Isiphazamisi. Kungavalwa ngokuchofoza inkinobho yokuvala evamile ekhoneni elingenhla elingakwesokudla.

Isifundo: Indlela yokwabela igama leseli ku-Excel

Ukusebenza kwezinkampani ezibizwa ngegama

Njengoba kushiwo ngenhla, ama-arrays angasetshenziswa angasebenzisa ngenkathi enza imisebenzi ehlukahlukene e-Excel: amafomula, imisebenzi, amathuluzi akhethekile. Ake sithathe isibonelo sokhonkolo sokuthi lokhu kwenzeka kanjani.

Ekhasini elilodwa sinalo uhlu lwamamodeli wemishini yekhompyutha. Sinomsebenzi eshadini lesibili etafuleni ukwenza uhlu oludonsa phansi kulolu hlu.

  1. Okokuqala, ohlwini lwehlu, sibeka ibanga igama ngezinye izindlela ezichazwe ngenhla. Ngenxa yalokho, uma ukhetha uhlu egameni legama, kufanele sibonise igama lohlu. Masibe igama "Amamodeli".

  2. Emva kwalokho sithuthela eshadini lapho ithebula likhona lapho kufanele senze uhlu lokudonsa phansi. Khetha indawo etafuleni esilungiselela ukushumeka uhlu lokudonsa phansi. Hambisa kuthebhu "Idatha" bese uchofoza inkinobho "Ukuqinisekiswa kwedatha" ebhodini lamathuluzi "Ukusebenza nedatha" kwi-tape.

  3. Kuwindidi yokuqinisekisa idatha eqala, iya kuthebhu "Izinketho". Ensimini "Uhlobo Lwedatha" khetha inani "Bhala". Ensimini "Umthombo" esimweni esivamile, kufanele ufake ngesandla zonke izakhi zohlu oluhla lwe-down-down, noma unike isixhumanisi ohlwini lwabo, uma itholakala kwidokhumenti. Lokhu akulula kakhulu, ikakhulu uma uhlu lukhona kwelinye ishidi. Kodwa kithi, konke kulula kakhulu, ngoba sinikeze igama ku-ehambisanayo. Ngakho nje faka uphawu kufana bese ubhala leli gama ensimini. Le nkulumo elandelayo itholakala:

    = Amamodeli

    Chofoza "Kulungile".

  4. Manje, uma uhambisa isikhala phezu kwanoma yiliphi iseli ebangeni lapho sisebenzise khona ukuhlola idatha, unxantathu ibonakala ngakwesokudla. Ukuchofoza kule nxantathu kuvula uhlu lwemininingwane yokufaka, okudonsa ohlwini oluvela kwelinye ishidi.

  5. Sidinga nje ukukhetha inketho oyifunayo ukuze inani kusuka kuhlu liboniswe kuseli elikhethiwe etafuleni.

Ububanzi obunqunyiwe buphinde busebenziseke njengemibono yemisebenzi ehlukahlukene. Ake sibuke ukuthi lokhu kusetshenziselwa kanjani ekusebenzeni ngesibonelo esithile.

Ngakho-ke, sinetafula lapho kutholakala khona izinzuzo zezinyanga ezinhlanu zamabhizinisi. Sidinga ukwazi imali engenayo yegatsha 1, igatsha 3 negatsha 5 sonke isikhathi esibonisiwe etafuleni.

  1. Okokuqala, sibanika igama emgqeni ngamunye wegatsha elihambisanayo etafuleni. KuGatsha 1, khetha indawo ngamaseli aqukethe idatha kwimali yawo ngezinyanga ezingu-3. Ngemuva kokukhetha igama egameni legama "Branch_1" (ungakhohlwa ukuthi igama alikwazi ukuqukatha isikhala) bese uchofoza ukhiye Ngena. Igama lendawo ehambelanayo izokwabiwa. Uma ufisa, ungasebenzisa noma iyiphi enye indlela yokuqamba igama, okukhulunywe ngayo ngenhla.

  2. Ngendlela efanayo, ukugqamisa izindawo ezifanele, sinikeza amagama emigqa kanye namanye amagatsha: "Branch_2", "Branch_3", "I-Branch_4", "Branch_5".

  3. Khetha isici sekhasi lapho inani lokufometha lizoboniswa khona. Sichofoza kusithonjana "Faka umsebenzi".

  4. Ukuqala kuqalisiwe. Amakhosi omsebenzi. Ukuhambisa ukuvimba "Isibalo". Misa ukhetho ohlwini lwabo opharetha olutholakala egameni "SUMM".

  5. Ukuqalisa ifasitela lokuphikisa opharetha SUM. Lo msebenzi, oyingxenye yeqembu labasebenzisa izibalo, uklanyelwe ngokuqondile ukuhlanganisa izintengo zamanani. I-syntax imelelelwe ifomula elandelayo:

    = SUM (inombolo1; inombolo2; ...)

    Njengoba kunzima ukuyiqonda, u-opharetha ufingqa zonke izingxabano zeqembu. "Inombolo". Ngendlela yezimpikiswano, kokubili amanani wezinombolo ngokwawo angasetshenziswa, kanye nezinkomba zamaseli noma amabanga lapho akhona khona. Uma ama-arrays asetshenziswa njengama-arguments, inani lamanani aqukethwe ezakhiweni zawo, elibalwe ngemuva, lisetshenziswe. Singasho ukuthi "sidlula" ngokusebenza. Kungenxa yokuxazulula inkinga yethu ukuthi ukufakwa kwezigaba kuzosetshenziswa.

    Inani lomqhubi SUM kungenzeka ukuthi ube nokuphikisana okukodwa kuya kwezingu-255. Kodwa kithi, sizodinga izimpikiswano ezintathu kuphela, ngoba sizofaka izigaba ezintathu: "Branch_1", "Branch_3" futhi "Branch_5".

    Ngakho, setha isikhangiso ensimini "Number1". Njengoba sinikeze amagama wamabanga adinga ukungezwa, ngakho akudingeki ukuthi ufake izixhumanisi endle noma uqokomise izindawo ezihambelanayo eshadini. Kwanele nje ukucacisa igama lamalungu okungeziwe: "Branch_1". Emasimini "Number2" futhi "Number3" ngokufanele wenze irekhodi "Branch_3" futhi "Branch_5". Ngemuva kokusebenza okungenhla kwenziwe, sichofoza "Kulungile".

  6. Umphumela wokubala uboniswa esitokisini esabelwe ngaphambi kokuya Umsebenzi weWebhu.

Njengoba ubona, ukwabiwa kwegama ngamachungechunge amangqamuzana kulokhu kwenza kube lula ukwenza umsebenzi wokwengeza izindinganiso ezibalwe kuzo, uma kuqhathaniswa nokuthi sisebenza ngamakheli, hhayi amagama.

Yiqiniso, lezi zibonelo ezimbili esizikhulume ngenhla zikhombisa kude nezinzuzo zonke kanye namathuba okusebenzisa amareythi akhethiwe uma uwasebenzisa njengengxenye yemisebenzi, amafomula namanye amathuluzi we-Excel. Izinhlobonhlobo zokusetshenziswa kwezigaba, ezinikezwe igama, ezingenakubalwa. Noma kunjalo, lezi zibonelo zisasisiza ukuba siqonde izinzuzo eziyinhloko zokwazisa amagama ezindaweni zetshe uma kuqhathaniswa nokusetshenziswa kwamakheli abo.

Isifundo: Indlela yokubala inani ku-Microsoft Excel

Ukuphathwa kweRange ebizwa ngokuthi

Ukuphatha izigaba ezifakwe ohlwini kulula kakhulu Umphathi wegama. Ukusebenzisa leli thuluzi, ungabela amagama kuma-arrays namaseli, ushintshe izindawo ezikhona ngaphambili eziqanjwe futhi uziqede. Indlela yokwabela igama nge Isiphazamisi sesivele sikhulume ngenhla, futhi manje sifunda ukwenza ezinye izinyathelo kuwo.

  1. Ukuya ku Isiphazamisithuthela kuthebhu "Amafomula". Lapho kufanele uchofoze kwisithonjana, esibizwa ngokuthi Umphathi wegama. Isithonjana esicacisiwe siseqenjini "Amagama aqondile".

  2. Ngemva kokuya Isiphazamisi ukuze wenze ukuphathwa okudingekile kobubanzi, kuyadingeka ukuthola igama layo ohlwini. Uma uhlu lwezinto ezingenayo kakhulu, ke kulula kakhulu ukwenza lokhu. Kodwa uma encwadini yamanje kunezinqwaba eziningi zezinhlaka ezibizwa ngamagama angaphezu kwalokho noma ngaphezulu, khona-ke ukwenza lula umsebenzi kuqondakale ukusebenzisa isihlungi. Sichofoza inkinobho "Hlunga"efakwe ekhoneni elingenhla kwesokudla kwewindi. Ukuhlunga kungenziwa ezindaweni ezilandelayo ngokukhetha into efanele kwimenyu evula:
    • Amagama eshidi;
    • encwadini;
    • ngephutha;
    • akukho amaphutha;
    • Amagama aqondile;
    • Amagama amatafula.

    Ukuze ubuyele ohlwini olugcwele lwezinto, khetha nje inketho "Sula isihlungi".

  3. Ukuze ushintshe imingcele, amagama, noma ezinye izakhiwo zohlu olukhethiwe, khetha into oyifunayo Isiphazamisi bese ucindezela inkinobho "Shintsha ...".

  4. Igama lokushintsha iwindi livuleka. Iqukethe ncamashi amasimu afana nefasitela ekwakheni uhla olukhethiwe, esixoxe ngakho ngaphambili. Kuphela nje kuphela amasimu azogcwala idatha.

    Ensimini "Igama" Ungashintsha igama lendawo. Ensimini "Qaphela" Ungangeza noma uhlele inothi elikhona. Ensimini "Range" Ungashintsha ikheli legama elikhethiwe. Kungenzeka ukwenza lokhu ngokusebenzisa ukufaka okubhaliwe kwezixhumanisi ezidingekayo, noma ngokusetha isikhombisi ensimini bese ukhetha uhlu olufanayo lwamaseli eshidi. Ikheli lakhe lizovela masinyane ensimini. Insimu kuphela lapho amanani angakwazi ukuhlelwa khona - "Indawo".

    Ngemuva kokuhlela kwedatha kuqedile, chofoza inkinobho. "Kulungile".

Futhi ku Isiphazamisi uma kunesidingo, ungenza inqubo yokususa ububanzi obuqanjwe. Kulesi simo, yiqiniso, akuyona indawo eshadini ngokwayo ezosuswa, kodwa igama elinikezwe lona. Ngakho, ngemuva kokuba inqubo isuqedile, i-array ecacisiwe ingatholakala kuphela ngezixhumanisi zayo.

Lokhu kubaluleke kakhulu, ngoba uma usuvele ususebenzise igama elisusiwe kwifomula, ngemuva kokususa igama, ifomula izoba iphutha.

  1. Ukufeza inqubo yokususa, khetha into oyifunayo ohlwini bese uchofoza inkinobho "Susa".

  2. Emva kwalokhu, ibhokisi lengxoxo liqalisiwe, elikucela ukuba uqinisekise ukuzimisela kwakho ukususa into ekhethiwe. Lokhu kwenziwa ukuvimbela umsebenzisi ngokulandela iphutha ngokulandela le nqubo. Ngakho-ke, uma uqiniseka ngesidingo sokususa, kuzomele uchofoze inkinobho. "Kulungile" ebhokisini lokuqinisekisa. Esimweni esihlukile, chofoza inkinobho. "Khansela".

  3. Njengoba ungabona, into ekhethiwe isusiwe ohlwini. Isiphazamisi. Lokhu kusho ukuthi uhlu oluhlanganisiwe lwalahlekelwa igama layo. Manje kuzobonakala kuphela ngezixhumanisi. Ngemuva kwazo zonke izindlela zokusebenza Isiphazamisi qedela, chofoza inkinobho "Vala"ukuqedela iwindi.

Ukusebenzisa ububanzi obunziwe kungenza kube lula ukusebenza ngamafomula, imisebenzi, namanye amathuluzi we-Excel. Izakhi eziqanjwe ngokwazo zingalawulwa (ziguquliwe futhi zisusiwe) zisebenzisa isakhiwo esikhethekile Isiphazamisi.

Okuthunyelwe Popular

https://termotools.com zu.termotools.com © I-Excel 2024