Umsebenzi wokuthutha kuwumsebenzi wokuthola indlela enhle kakhulu yokuthutha izimpahla zohlobo olufanayo kusuka kumphakeli kumthengi. Isisekelo saso siyisibonelo esetshenziswa kabanzi emikhakheni ehlukene yezibalo kanye nezomnotho. Ku-Microsoft Excel, kunezindlela ezisiza kakhulu isixazululo senkinga yokuthutha. Thola ukuthi ungayisebenzisa kanjani ngokusebenza.
Incazelo jikelele yenkinga yokuthutha
Umgomo oyinhloko wezokuthutha umsebenzi ukuthola uhlelo oluhle lokuthutha kumphakeli kumthengi ngezindleko ezincane. Imibandela yalowo msebenzi ibhaliwe ngesimo se-scheme noma i-matrix. Ku-Excel, uhlobo lwe-matrix lisetshenzisiwe.
Uma inani lezimpahla ezinqolobaneni zomthengisi lilingana nobukhulu besidingo, umsebenzi wokuthutha ubizwa ngokuthi uvaliwe. Uma lezi zinkomba zingalingani, umsebenzi wokuthutha onjalo ubizwa ngokuthi uvulekile. Ukuze uyixazulule, izimo kufanele zinciphise luhlobo oluvaliwe. Ukuze wenze lokhu, engeza umdayisi onenkohliso noma umthengi ongeyena onamasheya noma izidingo ezilingana nohlobo phakathi kokunikezwa nokufunwa esimeni sangempela. Ngesikhathi esifanayo, ikholomu eyengeziwe noma umugqa ngamanani we-zero ungeziwe kuthebula lezindleko.
Amathuluzi wokuxazulula izinkinga zokuthutha ku-Excel
Ukuxazulula inkinga yokuthutha ku-Excel, umsebenzi usetshenziswa "Funa isisombululo". Inkinga ukuthi ngokuzenzakalelayo ikhutshaziwe. Ukuze unike amandla leli thuluzi, udinga ukwenza izenzo ezithile.
- Hambisa kuthebhu "Ifayela".
- Chofoza esigatshaneni "Izinketho".
- Ewindini elisha, iya kokubhalisiwe Engeza-ons.
- Ku-block "Ukuphathwa"esezansi kwefasitela evulekayo, kuhlu lokudonsa phansi, yeka ukukhethwa kwento Faka i-Excel. Chofoza inkinobho. "Hamba ...".
- Iwindi yokuqalisa yokufaka iqala. Hlola ibhokisi eliseduze nento "Ukuthola isisombululo". Chofoza inkinobho "Kulungile".
- Ngenxa yalezi zenzo kuthebhu "Idatha" ebhokisini lesethingi "Ukuhlaziywa" inkinobho ibonakala ku-ribbon "Ukuthola isisombululo". Sizodinga lapho sifuna isisombululo senkinga yokuthutha.
Isifundo: Sesha isici seSolution ku-Excel
Isibonelo sokuxazulula inkinga yokuthutha ku-Excel
Manje ake sibheke isibonelo esithile sokuxazulula inkinga yokuthutha.
Izimo zenkinga
Sinabahlinzeki abangu-5 nabathengi abangu-6. Amanani amaningi okukhiqizwa kwabahlinzeki ngamayunithi angu 48, 65, 51, 61, 53. Abathengi badinga: ama-43, 47, 42, 46, 41, ama-59 amayunithi. Ngakho-ke, ivolumu yenani eliphelele lezinhlinzeko lilingana nalokho okudingekayo, okungukuthi, sibhekene nomsebenzi wokuthutha ovaliwe.
Ngaphezu kwalokho, lesi simo sinikezwa i-matrix yezindleko zokuhamba kusuka kwelinye iphuzu kuya kwelinye, eliboniswa eluhlaza emfanekisweni ongezansi.
Ukuxazulula izinkinga
Sibhekene nomsebenzi, ngaphansi kwezimo okukhulunywe ngenhla, ukunciphisa izindleko zokuhamba ezingeni eliphansi.
- Ukuze sixazulule le nkinga, sakha itafula ngokulinganayo nenani elifanayo lamaseli njengendlela echazwe ngenhla ebizwa ngokuthi i-matrix.
- Khetha noma iyiphi iseli elingenalutho kushidi. Chofoza kusithonjana "Faka umsebenzi"ngakwesokunxele kwebha yefomula.
- "I-Function Wizard" ivula. Uhlu olunikezayo, kufanele sithole umsebenzi SUMPRODUCT. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokufaka i-argument yokusebenza livuleka. SUMPRODUCT. Njengengxabano yokuqala, faka ububanzi bamaseli ku-matrix yezindleko. Ukuze wenze lokhu, vele ukhethe idatha yeseli ne-cursor. Ingxabano yesibili ibanga lamaseli etafuleni alungiselwe ukubalwa. Bese uchofoza inkinobho "Kulungile".
- Chofoza kuseli elitholakala ngakwesokunxele kweseli eliphezulu elingakwesokunxele etafuleni lamanani. Njengangaphambili, simbiza ngokuthi uMphathi Wezenzo, vula izimpendulo zomsebenzi kuwo. SUM. Ukuchofoza emkhakheni wokuphikisana kokuqala, khetha wonke umugqa ophezulu wamaseli etafuleni wokubala. Ngemuva kokuthi izixhumanisi zabo zifakwe ensimini efanelekile, chofoza inkinobho "Kulungile".
- Sifika ekhoneni elingaphansi kwesokudla leseli ngomsebenzi SUM. Uphawu lokugcwalisa luvela. Chofoza inkinobho yegundane lesokunxele bese uhudula isibambo sokugcwalisa phansi ekupheleni kwethebula lokubala. Ngakho sikopishe ifomula.
- Chofoza kuseli elitholakala phezulu kweseli eliphezulu elingakwesokunxele kwetafula ukubalwa. Njengangaphambili, sibiza umsebenzi. SUM, kodwa manje njengengxabano sisebenzisa ikholomu yokuqala yetafula ngezibalo. Sicindezela inkinobho "Kulungile".
- Kopisha umaki ogcwalisa ifomula yonke umugqa.
- Iya kuthebhu "Idatha". Kukhona ibhulogi lamathuluzi "Ukuhlaziywa" chofoza inkinobho "Ukuthola isisombululo".
- Izinketho zokusesha izixazululo zivulekile. Ensimini "Ukwandisa Umsebenzi Wezinkomba" ucacise iseli eliqukethe umsebenzi SUMPRODUCT. Ku-block "Kuze kube" setha inani "Okuncane". Ensimini "Ukushintsha amangqamuzana eguquguqukayo" sibonisa lonke uhla lwetafula lokubala. Ebhokisini lesethingi "Ngokuhambisana nemingcele" cindezela inkinobho "Engeza"ukwengeza ukulinganiselwa okubalulekile.
- Iwindi lokungeniswa lokungeza liqala. Okokuqala, sidinga ukwengeza isimo sokuthi inani lemininingwane emigqeni yetafula yezibalo kufanele lilingane nesamba semininingwane emigqeni yetafula ngesimo. Ensimini Ikholi yeselula ucacise inani lemali emigqeni yethebula lokubala. Bese usethe uphawu olulinganayo (=). Ensimini "Ukuvimbela" ucacise ububanzi bemali emigqeni yetafula nesimo. Emva kwalokho, chofoza inkinobho "Kulungile".
- Ngokufanayo, sengeza isimo sokuthi amakholomu amatafula amabili kufanele alingane. Engeza umkhawulo wokuthi isibalo sobubanzi bazo zonke amaseli etafuleni sokubala kufanele sibe sikhulu kunaleyo noma silingane no-0, kanye nesimo ukuthi kufanele sibe yinani eliphelele. Umbono jikelele wemikhawulo kufanele ifane nokuboniswa esithombeni ngezansi. Qinisekisa ukuqinisekisa ukuthi eduze kwephuzu "Yenza izinguquko ngaphandle komkhawulo okungewona ongalungile" kwakukhona uphawu, futhi indlela yesisombululo ikhethiwe "Cinga ukuxazulula izinkinga ezingekho emthethweni nge-OPG indlela". Ngemuva kokuthi zonke izilungiselelo zicacisiwe, chofoza inkinobho. "Thola isixazululo".
- Emva kwalokho, ukubalwa kwenzeka. Idatha iboniswa kumaseli etafuleni wokubala. Ifasitela lemiphumela yokusesha ixazululo ivuleka. Uma imiphumela iyanelisa, chofoza inkinobho. "Kulungile".
Njengoba ubona, isixazululo senkinga yokuthutha e-Excel sihlehlela ekubunjweni okulungile kwedatha yokufaka. Uhlelo ngokwalo lwenza izibalo esikhundleni somsebenzisi.
