Umsebenzi wokuthutha umsebenzi wokuthola inketho enhle kakhulu yokuhambisa uhlobo olufanayo lwezimpahla ukusuka kumphakeli kuya kumthengi. Isisekelo saso siyimodeli esetshenziswa kabanzi emikhakheni ehlukene yezibalo nakwezomnotho. IMicrosoft Excel inamathuluzi asiza kakhulu isixazululo senkinga yokuhamba. Sizothola ukuthi singazisebenzisa kanjani ekwenzeni.
Incazelo ejwayelekile yenkinga yokuhamba
Inhloso esemqoka yomsebenzi wokuhamba ukuthola uhlelo oluphelele lokuhamba ukusuka kumhlinzeki kuya kumthengi ngezindleko eziphansi. Izimo zomsebenzi onjalo zibhalwe ngesimo somdwebo noma we-matrix. I-Excel isebenzisa uhlobo lwe-matrix.
Uma umthamo ophelele wezimpahla ezindaweni zokugcina zomhlinzeki ulingana nesidingo, umsebenzi wokuhamba ubizwa ngokuthi uvaliwe. Uma lezi zinkomba zingalingani, khona-ke inkinga enjalo yokuhamba ibizwa ngokuthi ivulekile. Ukuyixazulula, imibandela kufanele incishiswe yohlobo oluvaliwe. Ukuze wenze lokhu, engeza umthengisi oqanjiwe noma umthengi oqanjiwe onamasheya noma odinga okulingana umehluko phakathi kokulethwa nokufunwa esimweni sangempela. Ngasikhathi sinye, ikholomu eyengeziwe noma umugqa onamanani zero zero wengezwe etafuleni lezindleko.
Amathuluzi okuxazulula inkinga yokuhamba e-Excel
Ukuxazulula inkinga yokuhamba e-Excel, sebenzisa umsebenzi “Ukuthola Isixazululo”. Inkinga ukuthi ikhutshaziwe ngokuzenzakalelayo. Ukuze unikeze amandla leli thuluzi, udinga ukwenza ezinye izinto.
- Hambisa ithebhu Ifayela.
- Chofoza esigatshaneni "Izinketho".
- Ewindini elisha, iya kokubhaliwe "Okengezwayo".
- Ebhlokini "Abaphathi", ebekwe ezansi kwewindi elivulayo, ohlwini olwehliswayo, yeka ukukhetha lapho I-Excel-Ins-Ins. Chofoza inkinobho "Hambani ...".
- Iwindi lokuqalisa kokuqalisa liqala. Bheka ibhokisi eliseduze "Ukuthola isisombululo". Chofoza inkinobho "Kulungile".
- Ngenxa yalezi zenzo, ithebhu "Idatha" kwibhlokhi yezilungiselelo "Ukuhlaziywa" kuzovela inkinobho kubambo "Ukuthola isisombululo". Sizoyidinga lapho sifuna isisombululo senkinga yokuhamba.
Isifundo: "Sesha isixazululo" umsebenzi e-Excel
Isibonelo sokuxazulula inkinga yokuhamba e-Excel
Manje ake sibheke isibonelo esithile sokuxazulula inkinga yokuhamba.
Izimo zomsebenzi
Sinabahlinzeki aba-5 nabathengi abayi-6. Amanani wokukhiqizwa kwalaba abahlinzeki zingama-48, 65, 51, 61, 53 amayunithi. Abathengi badinga: 43, 47, 42, 46, 41, 59 amayunithi. Ngakho-ke, ukulethwa okuphelele kulingana nenani lesidingo, okungukuthi, sibhekene nenkinga yokuhamba evaliwe.
Ngaphezu kwalokho, lesi simo sinikeza i-matrix yezindleko zokuhamba ukusuka kwelinye iphuzu ukuya kwelinye, elikhonjiswe ngokuluhlaza emfanekisweni ongezansi.
Ukuxazululwa kwezinkinga
Sibhekene nomsebenzi, ngaphansi kwemibandela esishiwo ngenhla, yokunciphisa izindleko zokuhamba.
- Ukuze kuxazululwe le nkinga, sakha itafula elinenombolo efanayo yamaseli ngenani lama-matrix angenhla.
- Khetha noma isiphi isitokisi esingenalutho eshidini. Chofoza isithonjana "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.
- Kuvulwa i- "Work Wizard". Uhlu alunikezayo, kufanele sithole umsebenzi SUMPRuction. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokufaka lomsebenzi liyavula SUMPRuction. Njengokuphikisana kokuqala, sethula uhla lwamaseli we-matrix yezindleko. Ukuze wenze lokhu, vele ukhethe idatha yeseli ngesikhombisi. Ingxabano yesibili izoba yibanga lamaseli etafuleni elalilungiselelwe izibalo. Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Sichofoza kuseli, elitholakala ngakwesobunxele seseli elingaphezulu ngakwesobunxele letafula ukubalwa. Njengokugcina lapho sibiza Umsebenzi Wizard, vula izimpikiswano zomsebenzi kuyo ISUM. Ngokuchofoza kunkundla yengxabano yokuqala, khetha wonke umugqa ophezulu wamaseli etafuleni wokubala. Ngemuva kokuthi izixhumanisi zabo zifakiwe emkhakheni ofanele, chofoza inkinobho "Kulungile".
- Singena ekhoneni elingakwesokudla leseli nomsebenzi ISUM. Umaka wokugcwalisa uyavela. Chofoza inkinobho yegundane kwesobunxele bese uhudula umaki wokugcwalisa uze ufike ekugcineni kwetafula. Ngakho-ke sakopisha ifomula.
- Sichofoza kuseli elingaphezulu kweseli elingaphezulu kwesokunxele kwetafula ukubalwa. Njengasesikhathini esedlule, sibiza umsebenzi ISUM, kepha kulokhu, njengokuphikisana, sisebenzisa ikholomu yokuqala yetafula ukubala. Chofoza inkinobho "Kulungile".
- Kopisha ifomula ukugcwalisa umugqa wonke ngomaka wokugcwalisa.
- Iya kuthebhu "Idatha". Lapho ebhokisini lamathuluzi "Ukuhlaziywa" chofoza inkinobho "Ukuthola isisombululo".
- Izinketho zokusesha isixazululo zivulekile. Ensimini "Lungiselela umsebenzi wenhloso" chaza iseli eliqukethe umsebenzi SUMPRuction. Ebhlokini "Ku" inani elisethiwe "Ubuncane". Ensimini "Ukushintsha Amaseli Aguqukayo" chaza lonke uhla lwethebula ekubalweni. Ebhuthini yezilungiselelo "Ngokuya ngemikhawulo" chofoza inkinobho Fakaukufaka imikhawulo embalwa ebalulekile.
- Iwindi lokukhawulela lokufaka liqala. Okokuqala, kudingeka sengeze isimo sokuthi inani ledatha emigqeni yetafula lokubala kufanele lilingane nesamba semininingwane emigqeni yetafula enaleso simo. Ensimini Isixhumanisi Seseli khombisa uhla wenamba emigqeni yethebula lokubala. Ngemuva kwalokho setha uphawu olulinganayo (=). Ensimini "Ukukhawulela" chaza uhla lwamanani emigqeni yetafula ngesimo. Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Ngokufanayo, singeza isimo sokuthi amakholomu wamathebula amabili kufanele alingane. Sifaka umkhawulo wokuthi isamba sobubanzi bawo wonke amaseli asetafuleni ukubalwa kumele kube likhulu kunalokho noma lilingane no-0, kanye nesimo sokuthi kumele kube yisamba. Ukubuka okujwayelekile kwemikhawulo kufanele kube njengoba kuboniswe esithombeni esingezansi. Qiniseka ukuthi uqiniseka ngani "Yenza okuguqukayo kungabi kubi kungabi kubi" kwakukhona uphawu lokuhlola, bese kukhethwa indlela yesisombululo "Sesha izisombululo zezinkinga ezingekho emthethweni ngendlela yamaqembu obugebengu obuhleliwe". Ngemuva kokuthi wonke amasethingi akhonjisiwe, chofoza inkinobho "Thola ikhambi".
- Ngemuva kwalokho, ukubalwa kwenzeka. Idatha iboniswa kumaseli etafula wokubala. Kuvulwa iwindi lemiphumela yokusesha. Uma imiphumela ikunelisa, chofoza inkinobho. "Kulungile".
Njengoba ukwazi ukubona, isixazululo senkinga yezokuhamba e-Excel sehlela ekwakhiweni kwemininingwane efanelekile. Izibalo ngokwazo zenziwa uhlelo esikhundleni somsebenzisi.
