Ngenkathi usebenza ku-Microsoft Excel, kuvame ukudingwa ukuhlanganisa inani lemakholomu kanye nemigqa yamathebula, futhi ngokucacile ukucacisa inani lamanani amaseli. Uhlelo luhlinzeka ngamathuluzi ambalwa okuxazulula le nkinga. Ake sibone ukuthi singamisa kanjani amaseli ku-Excel.
Isamba ngokuzenzakalela
Ithuluzi eyaziwa kakhulu nelula ukuyisebenzisa ekunqumeni inani lemininingwane kumaseli ku-Microsoft Excel yi-autosum.
Ukuze ubale inani ngale ndlela, chofoza okungenani iseli elingenalutho lekholomu noma umugqa, futhi, uma usendaweni yasekhaya, chofoza inkinobho ye-AutoSum.
Uhlelo lubonisa ifomula kuseli.
Ukuze ubone umphumela, udinga ukucindezela inkinobho yokungena kukhibhodi.
Ungenza kancane ngokuhlukile. Uma sifuna ukuphoqa amaseli angewona wonke umugqa noma ikholomu, kodwa ebangeni elithile, bese sikhetha lolu hlu. Bese uchofoza inkinobho ethi "AutoSum", esivele esazijwayele.
Umphumela uboniswa ngokushesha esikrinini.
Ukungalungi okuyinhloko kokubala usebenzisa i-autosum yukuthi ikuvumela ukubala uchungechunge lwedatha elisebuseni owodwa noma kukholomu. Kodwa uhlu olubanzi lwemininingwane elisekholomu nezinhlu ezimbalwa, le ndlela ayikwazi ukubalwa. Ngaphezu kwalokho, angeke isetshenziselwe ukubala isamba samaseli amaningana asuka komunye nomunye.
Isibonelo, sikhetha uhla lwamaseli, bese uchofoza inkinobho ethi "AutoSum".
Kodwa isikrini asibonisi isibalo sawo wonke lawa maseli, kodwa inani lakholomu ngalinye noma umugqa ngamunye.
Umsebenzi we-SUM
Ukuze ubuke inani lemikhakha ephelele, noma amanani amaningi wedatha ku-Microsoft Excel, kunomsebenzi othi "SUMM".
Khetha iseli lapho sifuna khona ukuthi inani liboniswe. Chofoza inkinobho "Faka umsebenzi" ongakwesokunxele kwebha yefomula.
Iwindi ye-Function Wizard ivula. Kuhlu lwemisebenzi sibheka umsebenzi "SUMM". Khetha, bese uchofoza inkinobho ethi "Kulungile".
Esikhathini iwindi yokusebenza evulekile, faka izixhumanisi zamaseli, inani esizolibala. Yiqiniso, akunakwenzeka ukufaka ngesandla izixhumanisi, ngakho uchofoze inkinobho ekhona ngakwesokudla kwenkambu yokungena kwedatha.
Emva kwalokho, iwindi lempikiswano yokusebenza lincishisiwe, futhi singakhetha lawo maseli, noma ama-cell array, inani lamanani esifuna ukuwabala. Ngemuva kokuthi i-array ikhethiwe, nekheli layo livela ensimini ekhethekile, chofoza inkinobho ngakwesokunene sale nsimu.
Siphinde sibuyele ewindini lempikiswano yokusebenza. Uma udinga ukwengeza uhlu olulodwa lwedatha kwinani eliphelele, bese uphinda izinyathelo ezifanayo okukhulunywe ngenhla, kodwa kuphela ensimini nepharamitha ye- "Number 2". Uma kunesidingo, ngale ndlela ungangena ikheli lezinombolo ezingenamkhawulo. Ngemuva kokuthi zonke izingqinamba zomsebenzi zifakiwe, chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, esitokisini esabeka ukukhishwa kwemiphumela, idatha ephelele yazo zonke amaseli ecacisiwe izoboniswa.
Ukusetshenziswa kwefomula
Isamba sedatha emaseli e-Microsoft Excel singabuye kubalwa ngokusebenzisa ifomula yokufaka elula. Ukuze wenze lokhu, khetha iseli lapho inani kufanele libe khona, bese ufaka kulo uphawu "=". Ngemuva kwalokho, chofoza ngokungafani esitokisini ngasinye, kulabo abanamanani amanani okudingayo ukuba ubale. Ngemuva kokuthi ikheli leseli lengezwe kubha yefomula, faka uphawu "+" oluvela kukhibhodi, futhi emva kokufaka izixhumanisi zeseli ngalinye.
Uma amakheli azo zonke amaseli efakiwe, cindezela inkinobho yokungenisa kwikhibhodi. Emva kwalokho, inani eliphelele lemininingwane efakiwe liboniswa kuseli elibonisiwe.
Ukungalungi okuyinhloko kwalendlela ukuthi ikheli leseli ngayinye kufanele lifakwe ngokwehlukile, futhi awukwazi ukukhetha lonke uhla lwamaseli ngesikhathi esisodwa.
Buka inani ku-Microsoft Excel
Futhi, ku-Microsoft Excel kungenzeka ukubuka inani lamaseli akhethiwe ngaphandle kokukhipha le mali eseceleni ehlukile. Isimo kuphela ukuthi zonke amangqamuzana, inani elifanele libalwe, kumele libe sesiseduze, ngendlela eyodwa.
Mane ukhethe uhla lwamaseli, inani lemininingwane oyidingayo, futhi ubheke umphumela kubha yomumo we-Microsoft Excel.
Njengoba ungabona, kunezindlela eziningana zokufingqa idatha ku-Microsoft Excel. Ngayinye yalezi zindlela inezinga layo eliyinkimbinkimbi nokuguquguquka. Njengomthetho, ukukhetha okulula, kungabi lula kakhulu. Isibonelo, uma unquma inani usebenzisa i-autosum, ungasebenzisa kuphela idatha ehlanganisiwe. Ngakho-ke, esimeni ngasinye esithile, umsebenzisi ngokwakhe kufanele anqume ukuthi iyiphi indlela efaneleka kakhulu.
