Lapho usebenza namatafula, kuvame ukudingeka ukufaka ama totali ngamagama athile. Leli gama lingabi negama lomlingani, igama lokugcina lomsebenzi, inombolo yomnyango, usuku, njll. Ngokuvamile, lamagama yizihloko zezintambo, ngakho-ke, ukuze ubale inani lezinto ngayinye, kubalulekile ukuhlanganisa okuqukethwe kwamaseli womugqa othize. Ngezinye izikhathi ukwengezwa kwedatha emigqeni eyenziwe ngezinye izinhloso. Ake sibuke ngezindlela ezahlukene ukuthi lokhu kungenziwa kanjani ku-Excel.
Bheka futhi: Indlela yokubala inani ku-Excel
Ukunciphisa Amanani Ku-String
Ngokuvamile, amanani emgqeni ku-Excel angagcwaliswa ngezindlela ezintathu eziyinhloko: besebenzisa ifomula ye-arithmetic, besebenzisa imisebenzi kanye nesamba semoto. Kulesi simo, lezi zindlela zingahlukaniswa izinketho eziningi.
Indlela 1: ifomula ye-arithmetic
Okokuqala, ake sibheke ukuthi, ngokusebenzisa ifomula ye-arithmetic, ungakwazi ukubala inani lemigqa. Ake sibone ukuthi le ndlela isebenza kanjani esibonelweni esithile.
Sinetafula elibonisa imali yezitolo ezinhlanu ngosuku. Amagama okugcina amabizo emigqa kanye nezinsuku amagama amakholomu. Sidinga ukubala inani lemali yesitoreji sokuqala sonke isikhathi. Ukuze senze lokhu, kufanele senze ukuhlanganisa kuwo wonke amaseli omugqa, okubhekisela kulolu shilo.
- Khetha iseli lapho umphumela ophelele wokubala inani lizoboniswa. Sabeka uphawu lapha "=". Sokuchofoza ngakwesokunxele esitokisini sokuqala kulolu hlu, equkethe amanani ezinombolo. Njengoba ungabona, ikheli layo liboniswa ngokushesha entweni ukubonisa inani. Sabeka uphawu "+". Bese uchofoza esiteleni esilandelayo emgqeni. Ngale ndlela senza esinye isibonakaliso "+" ngamakheli amaseli womugqa osesitolo sokuqala.
Ngenxa yalokho, esimeni sethu, sithola ifomula elandelayo:
= B3 + C3 + D3 + E3 + F3 + G3 + H3Ngokwemvelo, uma usebenzisa amanye amatafula, ukubonakala kwalo kuzohluka.
- Ukuze uthole inani lemali engenayo yokuchofoza kokuqala ku-inkinobho Ngena kwikhibhodi. Umphumela uboniswa esitokisini lapho ifomula itholakala khona.
Njengoba ungabona, le ndlela ilula futhi inembile, kodwa inomphumela owodwa omkhulu. Ekusetshenzisweni kwayo, udinga ukuchitha isikhathi esiningi uma uqhathaniswa nalabo okukhethwa kukho esikucabangayo ngezansi. Futhi uma kukhona amakholomu amaningi etafuleni, izindleko zesikhathi ziyokwandisa ngisho nangaphezulu.
Indlela 2: Isibalo Sokuzenzakalela
Indlela esheshayo yokwengeza idatha emgqeni ukusebenzisa i-auto-sum.
- Khetha wonke amaseli anenani lamanani wenombolo yomugqa wokuqala. Ukukhethwa kwenziwa ngokubamba inkinobho yegundane lesokunxele. Ukuya kuthebhu "Ikhaya"chofoza kusithonjana "I-Autosum"okuyinto itholakala ku-tape ebhodini lamathuluzi Ukuhlela.
Enye indlela yokubiza umthamo wemoto ukuya kuthebhu. "Amafomula". Kukhona ibhulogi lamathuluzi "I-Function Library" kwi-Ribbon chofoza inkinobho "I-Autosum".
Uma ungafuni ukuhamba ngokusebenzisa amathebhu nhlobo, ngemuva kokukhetha umugqa, ungamane uthayiphe inhlanganisela yamakhi aphuthumayo Alt + =.
- Kungakhathaliseki ukuthi isenzo esivela kuzinyathelo ezichazwe ngenhla ozikhethayo, inombolo izoboniswa ngakwesokudla ebangeni elikhethiwe. Kuyoba inani lamanani wezintambo.
Njengoba ungabona, le ndlela ikuvumela ukuthi ubale inani elilandelanayo ngokushesha kakhulu kunenguqulo yangaphambilini. Kodwa futhi unesici. Iqukethe ukuthi inani lizoboniswa kuphela ngakwesokudla kwendawo ekhethiwe ekhethiwe, hhayi endaweni lapho umsebenzisi efuna khona.
Indlela 3: Umsebenzi we-SUM
Ukuze unqobe ukwehluleka kwezindlela ezimbili ezichazwe ngenhla, ukhetho usebenzisa umsebenzi ohlanganisiwe we-Excel obizwa SUM.
I-Operator SUM kungokwaqembu lemisebenzi yezibalo Excel. Umsebenzi wakhe wukufaka izinombolo. I-syntax yalo msebenzi ilandelayo:
= SUM (inombolo1; inombolo2; ...)
Njengoba ungabona, izingxabano zalolu opharetha ziyizinombolo noma amakheli wamaseli asezindaweni zazo. Inani labo lingaba ngu-255.
Ake sibone ukuthi ungagcwalisa kanjani izinto ezilandelanayo usebenzisa lo opharetha usebenzisa isibonelo setafula lethu.
- Khetha noma yiliphi iseli elingenalutho kushidi, lapho sicabanga ukubonisa umphumela wokubala. Uma ufisa, ungayikhetha ngisho nakwesinye ishidi lencwadi. Kodwa lokhu akuvamile ukuthi kwenzeke, ngoba ezimweni eziningi kuyinto elula ngokwengeziwe ukubeka iseli ukubonisa amanani elayini elifanayo njengedatha ebalwa. Emva kokukhethwa kwenziwa, chofoza isithonjana "Faka umsebenzi" ngakwesokunxele kwebha yefomula.
- Igijima ithuluzi elinalo igama Umsebenzi weWebhu. Siya kuwo kusigaba "Isibalo" futhi ohlwini lwama-opharetha oluvula, khetha igama "SUMM". Bese uchofoza inkinobho. "Kulungile" phansi kwefasitela Amakhosi omsebenzi.
- Ivuselela iwindi lempikiswano ye-opharetha SUM. Izinkambu ezingafika ku-255 zingatholakala kuleli festile, kodwa ukuxazulula inkinga yethu sidinga insimu eyodwa kuphela - "Number1". Kuyo udinga ukufaka izixhumanisi zomugqa, izindinganiso okufanele zengezwe ngazo. Ukuze senze lokhu, sibeka isikhombisi ensimu ecacisiwe, bese-ke, uma ucindezela inkinobho yesinxele segundane, khetha lonke uhla lwamanani welayini esikudingayo ngesikhombisi. Njengoba ubona, ikheli laleli hlu lizobonakala masinyane emkhakheni wewindi lempikiswano. Bese uchofoza inkinobho. "Kulungile".
- Ngemuva kokuthi senze isenzo esicacisiwe, inani lamanani omugqa uzovela ngokushesha esitokisini esiyikhethile esigabeni sokuqala sokuxazulula inkinga ngale ndlela.
Njengoba ungabona, le ndlela iguquguquka futhi ihamba ngokushesha. Iqiniso, hhayi kubo bonke abasebenzisi, inembile. Ngakho-ke, labo abangazi ngokuphila kwalo kusuka emithonjeni ehlukahlukene akuvamile ukuthola ku-interface ye-Excel ngokwabo.
Isifundo: I-Master of Imisebenzi e-Excel
Indlela 4: Ama-Mass Summing Value emigqeni
Kodwa yini okufanele uyenze uma udinga ukufingqa hhayi eyodwa futhi hhayi imigqa emibili, kodwa, uthi 10, 100 noma ngisho 1000? Ingabe kudingekile ukuthi umugqa ngamunye usebenzise izinyathelo ezingenhla? Njengoba kuvela, hhayi ngempela. Ukuze wenze lokhu, mane nje ukopishe ifomula yokufometha kwamanye amaseli ohlela ukubonisa inani lemigqa esele. Lokhu kungenziwa ngokusebenzisa ithuluzi elinegama lomaka wokugcwalisa.
- Senza ukufakwa kwamanani emgqeni wokuqala wetafula nganoma iyiphi yezindlela ezichazwe ekuqaleni. Beka isikhombisi ekhoneni elingaphansi kwesokudla leseli lapho umphumela wefomula noma umsebenzi osebenzayo uboniswa. Kulesi simo, isikhombisi kufanele sishintshe ukubukeka kwayo futhi siguquke sibe uphawu lokugcwalisa, olubukeka njengesiphambano esincane. Khona-ke sibamba inkinobho yesinxele segundane bese uhudula phansi isikhombisi, ngokufana namaseli anegama lemigqa.
- Njengoba ubona, wonke amaseli agcwele idatha. Lona inani lamagugu ngokwehlukana emigqeni. Le mphumela itholakale ngoba, ngokuzenzakalelayo, zonke izixhumanisi ku-Excel zihlobene, hhayi ngokuphelele, futhi zishintsha izixhumanisi zazo uma zikopisha.
Isifundo: Indlela yokuqedela ngokuzenzakalela ku-Excel
Njengoba ubona, ku-Excel kunezindlela ezintathu eziyinhloko zokubala inani lamagugu emigqeni: ifomula ye-arithmetic, sum sum and function SUM. Ngayinye yalezi zinketho inezinzuzo nezinkinga zayo. Indlela elula kunazo zonke intuitively ukusebenzisa ifomula, inketho esheshayo isamba semali, futhi iningi jikelele usebenzisa i-operator ye-SUM. Ukwengeza, usebenzisa uphawu lokugcwalisa, ungenza ukufingqwa kwamanani emigqa, okwenziwa ngezindlela ezintathu ezibalwe ngenhla.
