Lapho wenza izibalo ezithile, kuyadingeka ukuthola isamba semisebenzi. Lolu hlobo lokubalwa kwesinye isikhathi lwenziwa ngababhali bama akhawunti, onjiniyela, abahleli, kanye nabafundi bezikhungo zemfundo. Isibonelo, le ndlela yokubala idinga ulwazi ngenani eliphelele lamaholo ezinsuku ezisetshenzisiwe. Ukuqaliswa kwalesi senzo kungadingeka kwezinye izimboni, ngisho nasezidingweni zasekhaya. Ake sibheke ukuthi ku-Excel ungalibala kanjani inani lemisebenzi.
Ukubalwa kwenani lomsebenzi
Kusuka egameni lesenzo uqobo, kuyacaca ukuthi isamba semikhiqizo ukwengeza kwemiphumela yokuphindaphindeka kwezinombolo ngazinye. E-Excel, lesi senzo singenziwa kusetshenziswa ifomula elula yezibalo noma ngokusebenzisa umsebenzi okhethekile SUMPRuction. Ake sibheke kabanzi lezi zindlela ngazinye.
Indlela yoku-1: sebenzisa ifomula yezibalo
Iningi labasebenzisi liyazi ukuthi ku-Excel ungenza inani elikhulu lezenzo zezibalo ngokumisa nje isibonakaliso "=" esitokisini esingenalutho, bese ubhala leyo nkulumo ngokwemithetho yezibalo. Le ndlela ingasetshenziswa futhi ukuthola isamba semisebenzi. Uhlelo, ngokwemithetho yemathematics, lubala ngokushesha imisebenzi, bese lubafaka enanini eliphelele.
- Setha uphawu olulinganayo (=) esitokisini okuzovezwa ngalo umphumela wokubala. Sibhala phansi ukubonakaliswa kwesamba semisebenzi ngokwethempulethi elandelayo:
= a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...Isibonelo, ngale ndlela ungakwazi ukubala isisho esithi:
=54*45+15*265+47*12+69*78 - Ukwenza ukubala futhi ubonise umphumela wayo esikrinini, cindezela inkinobho ethi Enter kwikhibhodi.
Indlela 2: sebenza ngezixhumanisi
Esikhundleni senombolo ethize kule fomula, ungacacisa izixhumanisi kumaseli lapho zitholakala khona. Izixhumanisi zingafakwa ngesandla, kepha kulula kakhulu ukwenza lokhu ngokugqamisa ngemuva kophawu "=", "+" noma "*" iseli elihambisanayo eliqukethe inamba.
- Ngakho-ke, ngokushesha sibhala phansi isichasiselo, lapho esikhundleni senombolo, izinkomba zeseli zikhonjisiwe.
- Ngemuva kwalokho, ukubala, chofoza inkinobho Ngena. Umphumela wesibalo uzokhonjiswa.
Vele, lolu hlobo lokubala lubala futhi lunembile, kepha uma kunamanani amaningi etafuleni okudingeka ukuthi liphindaphindwe bese lifakwa ngaphezulu, le ndlela ingathatha isikhathi esiningi.
Isifundo: Ukusebenza namafomula ku-Excel
Indlela 3: ukusebenzisa umsebenzi we-SUMPRODUCT
Ukuze kubalwe inani lomsebenzi, abanye abasebenzisi bathanda umsebenzi owenzelwe lo msebenzi ngokukhethekile - SUMPRuction.
Igama lale opharetha likhuluma ngezinhloso zalo uqobo. Inzuzo yale ndlela ngaphezulu kweyedlule ukuthi ingasetshenziswa ukucubungula uhlu lonke ngasikhathi sinye, futhi ungenzi izinto ngenombolo ngayinye noma iseli ngokwehlukana.
I-syntax yalomsebenzi imi kanje:
= SUMPRODUCT (uhlu1; uhlu2; ...)
Izimpikiswano zalo opharetha ngamabanga wedatha. Ngaphezu kwalokho, bahlukaniswe ngamaqembu wezinto. Lokho wukuthi, uma wakhela kuthempulethi esikhulume ngayo ngaphezulu (a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...), ke kokulandelana kokuqala yizici zeqembu a, kwesibili - amaqembu b, kwesithathu - amaqembu c njll. Lama banga kumele afane futhi alingane ngobude. Zingakwazi ukutholakala ngokuqondile nangokuma ngokuqondile. Sekukonke, lo opharetha angasebenza ngenombolo yokuphikisana kusuka ku-2 kuye ku-255.
Ifomula SUMPRuction Ungabhalela iseli ngokushesha ukukhombisa umphumela, kepha kubasebenzisi abaningi kulula futhi kulula kakhulu ukubala nge-Wizard yomsebenzi.
- Khetha iseli eshidini lapho umphumela wokugcina uzokhonjiswa khona. Chofoza inkinobho "Faka umsebenzi". Yakhelwe njengesithonjana futhi ibekwe ngakwesokunxele sensimu yebha yefomula.
- Ngemuva kokuthi umsebenzisi enze lezi zenzo, kuyaqala Isici Wizard. Ivula uhlu lwabo bonke, ngaphandle kwezimbalwa, opharetha ongasebenza nabo e-Excel. Ukuthola umsebenzi esiwudingayo, iya esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi". Ngemuva kokuthola igama SUMMPROIZV, ikhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyaqala SUMPRuction. Ngenombolo yokuphikisana, ingaba nezindima ezi-2 ukuya kwezi-255. Amakheli amabanga angahanjiswa ngesandla. Kepha kuzothatha isikhathi eside. Ungakwenza okuhlukile. Sibeka isikhombisi endle yokuqala bese sikhetha ngenkinobho yegundane kwesobunxele sicindezele uhlu lwezimpikiswano zokuqala ekhasini. Ngendlela efanayo esisebenza ngayo kwesesibili nangawo wonke amabanga alandelayo, izixhumanisi zazo zikhonjiswa ngokushesha endimeni ehambisanayo. Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile" phansi kwewindi.
- Ngemuva kwalezi zenzo, uhlelo lenza ngokuzimela zonke izibalo ezidingekayo futhi libonisa umphumela wokugcina esitokisini esigqanyiswe esigabeni sokuqala salo myalelo.
Isifundo: Umsebenzi Wizard e-Excel
Indlela 4: kusebenza umbandela
Umsebenzi SUMPRuction kuhle nokuthi kungenzeka ukuthi kusetshenziswe ngombandela. Ake sibheke ukuthi kwenziwa kanjani lokhu ngesibonelo esithile.
Sinohlu lwemiholo kanye nezinsuku ezisetshenziswa yizisebenzi izinyanga ezintathu njalo ngenyanga. Sidinga ukuthola ukuthi umholo uParfenov D.F. uhola malini ngalesi sikhathi.
- Ngendlela efanayo nesikhathi esedlule, sibiza iwindi lokuphikisana komsebenzi SUMPRuction. Emikhakheni yokuqala emibili, sibonisa amabanga lapho isilinganiso sabasebenzi kanye nenani lezinsuku esisebenzile kuzo zikhonjiswa njengamalungu afanayo, ngokulandelana. Lokho wukuthi, senza konke, njengasekuqaleni. Kepha emkhakheni wesithathu sibeka izixhumanisi zamalungu afanayo, aqukethe amagama abasebenzi. Masishane ngemuva kwekheli sifaka okufakiwe:
= "Parfenov D.F."Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".
- Isicelo senza ukucabanga. Imigqa kuphela lapho igama likhona elibhekwa "UParfenov D.F.", yilokho esikudingayo. Umphumela wokubala uboniswa kuseli elikhethwe ngaphambilini. Kepha umphumela ungu-zero. Lokhu kungenxa yokuthi ifomula, ngendlela elikhona ngayo manje, ayisebenzi kahle. Sidinga ukukuguqula kancane.
- Ukuze uguqule ifomula, khetha iseli ngenani lokugcina. Yenza izenzo kubha yefomula. Sithatha ingxabano nalesi simo kubakaki, futhi phakathi kwayo nezinye izimpikiswano sishintsha i-semicolon ibe uphawu lokuphindaphinda (*). Chofoza inkinobho Ngena. Uhlelo lubalwa futhi kulokhu kunikeza inani elifanele. Sithole inani lamaholo izinyanga ezintathu, ngenxa yomsebenzi webhizinisi D.F. Parfenov
Ngendlela efanayo, ungafaka imibandela hhayi kumbhalo kuphela, kodwa nezinamba ngezinsuku ngokungeza izimpawu zesimo "<", ">", "=", "".
Njengoba ukwazi ukubona, kunezindlela ezimbili eziphambili zokubala inani lemisebenzi. Uma kungekho idatha eningi, khona-ke kulula ukusebenzisa ifomula elula yezibalo. Lapho inani elikhulu lezinombolo libandakanyeka ekubalweni, umsebenzisi uzokonga inani lesikhathi sakhe nomzamo uma esebenzisa ithuba lamakhono akhethekile womsebenzi SUMPRuction. Ngaphezu kwalokho, usebenzisa i-opharetha efanayo, kungenzeka ukubala ngesimo ifomula evamile engakwazi ukuyenza.
