Ungayisebenzisa kanjani i-Function Wizard ku-Excel. Ukushaya ucingo, ukukhetha imisebenzi, ukugcwalisa izimpikiswano, ukwenza umsebenzi

I-Microsoft Excel Function Manager yenza kube lula ukusebenza ngezibalo. Iqeda isidingo sokufaka ifomula uhlamvu olulodwa ngesikhathi, bese ubheka amaphutha ezibalweni ezivele ngenxa yokuthayipha. Umtapo wezincwadi ocebile we-Excel Function Manager uqukethe izifanekiso zokusetshenziswa okuhlukahlukene, ngaphandle kwalapho udinga ukwakha ifomula efakwe esidlekeni. Ukwenza ukusebenza ngamatafula kunciphe isikhathi, sizohlaziya ukusetshenziswa kwaleli thuluzi isinyathelo ngesinyathelo.

Isinyathelo #1: Vula Isilekeleli Somsebenzi

Ngaphambi kokufinyelela ithuluzi, khetha iseli ukuze ubhale ifomula - chofoza ngegundane ukuze kuvele uhlaka olujiyile eduze kweseli. Kunezindlela ezimbalwa zokuqalisa i-Function Wizard:

  1. Cindezela inkinobho ethi "Fx", etholakala kwesokunxele somugqa ukuze usebenze ngamafomula. Le ndlela ishesha kakhulu, ngakho-ke idumile phakathi kwabanikazi be-Microsoft Excel.
  2. Iya kuthebhu “Amafomula” bese uchofoza inkinobho enkulu enegama elifanayo elithi “Fx” kwesokunxele sephaneli.
  3. Khetha isigaba osifunayo kokuthi “Ilabhulali Yemisebenzi” bese uchofoza umbhalo othi “Faka umsebenzi” ekugcineni komugqa.
  4. Sebenzisa inhlanganisela yokhiye Shift + F Lena futhi indlela elula, kodwa kunengozi yokukhohlwa inhlanganisela oyifunayo.
Ungayisebenzisa kanjani i-Function Wizard ku-Excel. Ukushaya ucingo, ukukhetha imisebenzi, ukugcwalisa izimpikiswano, ukwenza umsebenzi
Izakhi zesixhumi esibonakalayo ezinikeza ukufinyelela Kumphathi Womsebenzi

Isinyathelo #2: Khetha Isici

Umphathi Womsebenzi uqukethe inani elikhulu lamafomula ahlukaniswe izigaba eziyi-15. Amathuluzi okusesha akuvumela ukuthi uthole ngokushesha ukungena okufunayo phakathi kwabaningi. Ukusesha kwenziwa ngeyunithi yezinhlamvu noma ngezigaba ngazinye. Ngayinye yalezi zindlela idinga ukucutshungulwa. Phezulu ewindini Lomphathi kukhona umugqa "Sesha umsebenzi". Uma ulazi igama lefomula oyifunayo, yifake bese uchofoza okuthi “Thola”. Yonke imisebenzi enegama elifanayo negama elifakiwe izovela ngezansi.

Ukusesha kwesigaba kuyasiza lapho igama lefomula kumtapo wezincwadi we-Excel lingaziwa. Chofoza umcibisholo osekupheleni kwesokudla komugqa "Isigaba" bese ukhetha iqembu olifunayo lemisebenzi ngesihloko.

Ungayisebenzisa kanjani i-Function Wizard ku-Excel. Ukushaya ucingo, ukukhetha imisebenzi, ukugcwalisa izimpikiswano, ukwenza umsebenzi
Amaqembu asohlwini

Kukhona ezinye izintambo phakathi kwamagama ezigaba. Ukukhetha "Uhlu olugcwele lwama-alfabhethi" kubangela uhlu lwayo yonke imisebenzi yelabhulali. Inketho ethi "10 Esanda Kusetshenziswa" isiza labo abavame ukukhetha amafomula afanayo abazosebenza ngawo. Iqembu elithi “Ukuhambisana” liwuhlu lwamafomula asuka ezinguqulweni ezindala zohlelo.

Uma umsebenzi oyifunayo utholakala esigabeni, chofoza kukho ngenkinobho yegundane kwesokunxele, umugqa uzophenduka ube luhlaza okwesibhakabhaka. Hlola ukuthi ukukhetha kulungile yini bese ucindezela "KULUNGILE" efasiteleni noma "Faka" kukhibhodi.

Isinyathelo #3: Gcwalisa izimpikiswano

Iwindi lokubhala ama-agumenti omsebenzi lizovela esikrinini. Inombolo yemigqa engenalutho kanye nohlobo lwe-agumenti ngayinye incike ebunkingeni befomula ekhethiwe. Ake sihlaziye isiteji sisebenzisa umsebenzi onengqondo othi “IF” njengesibonelo. Ungakwazi ukwengeza inani le-agumenti ngokubhala usebenzisa ikhibhodi. Thayipha inombolo oyifunayo noma olunye uhlobo lolwazi emugqeni. Uhlelo futhi likuvumela ukuthi ukhethe amaseli okuqukethwe kwawo okuzoba ingxabano. Nazi izindlela ezimbili zokukwenza:

  1. Faka igama leseli kuyunithi yezinhlamvu. Inketho ayilungile uma iqhathaniswa neyesibili.
  2. Chofoza iseli oyifunayo ngenkinobho yegundane engakwesokunxele, kuzovela uhlaka olunamachashazi onqenqemeni. Phakathi kwamagama amaseli, ungafaka izimpawu zezibalo, lokhu kwenziwa ngesandla.

Ukuze ucacise ububanzi bamaseli, bamba elokugcina bese ulihudulela eceleni. Uhlaka olunamachashazi anyakazayo kufanele luthwebule wonke amaseli afunekayo. Ungakwazi ukushintsha ngokushesha phakathi kwemigqa yokungqubuzana usebenzisa ukhiye we-Tab.

Ungayisebenzisa kanjani i-Function Wizard ku-Excel. Ukushaya ucingo, ukukhetha imisebenzi, ukugcwalisa izimpikiswano, ukwenza umsebenzi
Izakhi zesixhumi esibonakalayo ezisetshenziswa lapho kukhethwa ama-agumenti

Kwesinye isikhathi inani lezingxabano liyanda ngokwalo. Asikho isidingo sokwesaba lokhu, ngoba kwenzeka ngenxa yencazelo yomsebenzi othile. Lokhu kuvame ukwenzeka uma usebenzisa amafomula ezibalo oMphathi. I-agumenti ayiqukethe izinombolo - kukhona imisebenzi yombhalo lapho izingxenye zenkulumo zivezwa ngamagama noma imisho.

Isinyathelo #4: Yenza umsebenzi

Uma wonke amanani esethiwe futhi aqinisekiswa ukuthi alungile, cindezela u-OK noma u-Enter. Inombolo noma igama elifiswayo lizovela kuseli lapho ifomula yengezwe khona, uma wenze konke kahle.

Esimeni sephutha, ungakwazi njalo ukulungisa ukunemba. Khetha iseli enomsebenzi bese ungena kuMphathi, njengoba kukhonjisiwe esinyathelweni #1. Iwindi lizovela futhi esikrinini lapho udinga ukushintsha khona amanani ama-agumenti emigqeni.

Ungayisebenzisa kanjani i-Function Wizard ku-Excel. Ukushaya ucingo, ukukhetha imisebenzi, ukugcwalisa izimpikiswano, ukwenza umsebenzi
Iwindi lokushintsha inani lama-agumenti

Uma kukhethwe ifomula engalungile, sula okuqukethwe kweseli bese uphinda izinyathelo zangaphambilini. Ake sithole ukuthi ungawususa kanjani umsebenzi etafuleni:

  • khetha iseli oyifunayo bese ucindezela Susa kukhibhodi;
  • chofoza kabili kuseli ngefomula - uma kuvela isisho kulo esikhundleni senani lokugcina, sikhethe bese ucindezela inkinobho ethi Backspace;
  • chofoza kanye kuseli obusebenza kulo Kumphathi Womsebenzi bese ususa imininingwane kubha yefomula - itholakala ngenhla nje kwetafula.

Manje umsebenzi ufeza injongo yawo - yenza ukubala okuzenzakalelayo futhi ikukhulule kancane emsebenzini oyisidina.

shiya impendulo