Ungavimbela kanjani oxhumana naye ku-iPhone

Ngezinye izikhathi ngaphambi kokuba abasebenzisi be-Excel kuba umbuzo ukuthi banganezela kanjani inani eliphelele lamanani amakholomu amaningana? Umsebenzi unzima nakakhulu uma lezi zinsika zingekho endaweni eyodwa, kodwa zihlakazekile. Ake sibone ukuthi singazihlanganisa kanjani ngezindlela ezihlukahlukene.

Ukwengezwa kwekholomu

Ukufakwa kwamakholomu ku-Excel kwenzeka ngokuvumelana nemigomo jikelele yokufaka idatha kuloluhlelo. Yiqiniso, le nqubo inezinto ezithile ezikhethekile, kodwa ziyingxenye ethile yomthetho jikelele. Njenganoma yikuphi okunye okufakiwe kule prosesa ye-tabular, ukungezwa kwamakholomu kungenziwa ngokusebenzisa ifomula elula ye-arithmetic, usebenzisa umsebenzi ohlanganisiwe we-Excel SUM noma isamba semali.

Isifundo: Ukubala amanani ku-Excel

Indlela 1: Sebenzisa i-Auto Sum

Okokuqala, ake sibheke ukuthi singagcwalisa kanjani amakholomu ku-Excel ngosizo lwethuluzi njengemali yesamba.

Isibonelo, thatha itafula, elibonisa imali yansuku zonke yezitolo ezinhlanu ezinsukwini eziyisikhombisa. Idatha yesitolo ngasinye itholakala kukholomu ehlukile. Umsebenzi wethu uzoba ukuthola inzuzo ephelele yalezi zitolo ngesikhathi esiboniswe ngenhla. Ngalesi sizathu, nje udinga ukuphinda ikholomu.

1. Ukuze uthole imali engenayo yezinsuku ezingu-7 esitolo ngasinye ngokwehlukana, sisebenzisa isamba semali. Khetha isikhombisi ngenkinobho yegundane lesokunxele esicindezelwe kukholomu "Thenga 1" zonke izinto ezinamanani ezinombolo. Bese, uhlala kuthebhu "Ikhaya", chofoza inkinobho "I-Autosum"okuyinto itholakala ku-ribbon eqenjini lezilungiselelo Ukuhlela.



2. Njengoba ungabona, inani lemali engenayo kwezinsuku ezingu-7 esitokisini sokuqala lizoboniswa kuseli ngaphansi kwekholomu yethebula.



3. Senza umsebenzi ofanayo, usebenzisa isamba semoto kanye nawo wonke amakholomu aqukethe idatha kwimali yezitolo.

   Uma kunezinsika eziningi, ngakho-ke kungenzeka ukuthi ungabalwa ngamunye wabo imali yemali ngokwahlukana. Sisebenzisa uphawu lokugcwalisa ukukopisha ifomula equkethe isamba semali sokuqala kokungena kumakholomu asele. Khetha isici lapho ifomula itholakala khona. Hambisa isikhombisi ekhoneni elingezansi kwesokudla. Kufanele iguqulwe kumaka wokugcwalisa, obukeka njengesiphambano. Khona-ke senza i-clamp inkinobho yesinxele segundane bese uhudula isibambo sokugcwalisa ngokuhambisana negama lekholomu kuze kube sekugcineni kwetafula.



4. Njengoba ubona, amanani entengiselwano ezinsukwini ezingu-7 for ngayinye i-outlet ibalwa ngokwehlukana.



5. Manje sidinga ukungeza ndawonye imiphumela ephelele yendawo ngayinye. Lokhu kungenziwa nge-auto sum sum. Yenza okukhethiwe ngesikhombisi ngenkinobho yegundane lesokunxele egcinwe phansi wonke amaseli lapho inani lemali engenayo yezitolo ngabanye likhona, futhi ngaphezu kwalokho sibamba elinye iseli elingenalutho ngakwesokudla kubo. Bese ukhetha ngokuchofoza kwisithonjana esiphezulu esivele sijwayele kithi kubhere.



6. Njengoba ungabona, inani lemali engenayo kuzo zonke izindawo zokuthenga izinsuku ezingu-7 lizoboniswa esitokisini esingenalutho, esasibe ngakwesokunxele kwetafula.

Indlela 2: Sebenzisa ifomula elula yezibalo

Manje ake sibone ukuthi singafingqa kanjani amakholomu wetafula, ukusebenzisa lezi zinhloso kuphela ifomula elula yezibalo. Isibonelo, sizosebenzisa itafula elifanayo elisetshenziselwa ukuchaza indlela yokuqala.

1. Njengesikhathi sokugcina, okokuqala, sidinga ukubala inani lemali ezinsukwini ezingu-7 esitolo ngasinye ngokwehlukana. Kodwa sizokwenza lokhu ngendlela ehlukile. Khetha iseli lokuqala elingenalutho ngaphansi kwekholomu. "Thenga 1"bese ufaka uphawu lapho "=". Okulandelayo, chofoza engxenyeni yokuqala yale kholomu. Njengoba ungabona, ikheli lakhe liboniswa ngokushesha esitokisini semali. Emva kwalokho sibeka uphawu "+" kusuka ikhibhodi. Okulandelayo, chofoza esiteleni esilandelayo kukholomu efanayo. Ngakho-ke, ukubhekisela okunye okushiwo ezakhiweni zeshidi nesibonakaliso "+", sicubungula wonke amaseli wekholomu.

   Esikhathini sethu esithile, sithole ifomula elandelayo:

   = B2 + B3 + B4 + B5 + B6 + B7 + B8

   Yiqiniso, esimeni ngasinye kungase kuhluke kuye ngokuthi indawo yetafula kushidi kanye nenani lamaseli kukholomu.



2. Ngemuva kokuthi amakheli azo zonke izakhi zekholomu afakwe, ukuze abonise umphumela wokufakela imali engenayo izinsuku ezingu-7 kokuqala kokuchofoza, chofoza inkinobho Ngena.



3. Khona-ke ungenza okufanayo kwezinye izitolo ezine, kodwa kuyoba lula futhi ngokushesha ukuhlanganisa idatha kwezinye izinsika usebenzisa uphawu lokugcwalisa ngendlela efanayo ngendlela esenze ngayo endleleni yangaphambilini.



4. Manje kusele kithi ukuthola inani eliphelele lamakholomu. Ukuze wenze lokhu, khetha noma iyiphi into engenalutho kushidi, lapho sihlela khona ukubonisa umphumela, bese ufaka kuso isibonakaliso "=". Khona-ke sengeza amangqamuzana lapho izibalo zamakholomu, esabalwa ngaphambilini, zitholakala.

   Sinefomula elandelayo:

   = B9 + C9 + D9 + E9 + F9

   Kodwa leli fomula libuye libe yilowo nalowo icala ngalinye.



5. Ukuthola umphumela jikelele wokungezwa kwamakholomu, chofoza inkinobho. Ngena kwikhibhodi.

Akunakwenzeka ukuthi ungaboni ukuthi le ndlela ithatha isikhathi esiningi futhi idinga umzamo owedlula ukwedlule, ngoba icabanga ukuthi ukuze ukhiqize inani lemali engenayo, ukuchofoza ngokuphindaphindiwe kweseli ngayinye okudingeka yengezwe. Uma kukhona imigqa eminingi etafuleni, le nqubo ingaba nzima. Ngesikhathi esifanayo, le ndlela inenzuzo engenakuphikiswa: umphumela ungavela kunoma yisiphi iseli elingenalutho kushidi lomsebenzisi elikhethayo. Uma usebenzisa isamba semali, akunjalo.

Ngokwenza, lezi zindlela ezimbili zingahlanganiswa. Isibonelo, ukuxuba ama-totali kukholomu ngayinye ngokwehlukana usebenzisa isamba semoto, futhi uthola inani eliphelele ngokusebenzisa ifomula ye-arithmetic esitokisini eshicilelwe ngumsebenzisi.

Indlela 3: Sebenzisa umsebenzi we-SUM

Ukungahleleki kwezindlela ezimbili zangaphambilini kungaqedwa ngokusebenzisa umsebenzi ohlanganisiwe we-Excel obizwa ngokuthi SUM. Inhloso yalolu opharetha yilezi zibalo eziningana. Yingxenye yesigaba semisebenzi yezibalo futhi ine-syntax elula elandelayo:

= SUM (inombolo1; inombolo2; ...)

Izimpikiswano, inombolo yayo engafinyelela ku-255, izinombolo ezifinyelelekayo noma amakheli eseli, lapho zitholakala khona.

Ake sibone ukuthi lo msebenzi we-Excel usetshenziswe kanjani ekusebenziseni isibonelo setafula elifanayo lemali yezokuthengisa eziyisihlanu ezinsukwini ezingu-7.

1. Sibeka isici kushidi lapho inani lemali engenayo kukholomu yokuqala lizoboniswa. Chofoza kusithonjana "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.



2. Ukuqaliswa kwenziwa Amakhosi omsebenzi. Ukuba esigabeni "Isibalo"ngifuna igama "SUMM"ukhethe futhi ukhethe inkinobho "Kulungile" ezansi kule window.



3. Ukuqalisa kwewindi lempikiswano yokusebenza. Kungaba nezindawo ezingafika ku-255 negama "Inombolo". Lezi zinkambu ziqukethe iziphakamiso ze-opharetha. Kodwa ngenxa yendaba yethu insimu eyodwa izokwanela.

   Ensimini "Number1" ufuna ukubeka izixhumanisi ebangeni eliqukethe amaseli ekholomu "Thenga 1". Lokhu kwenziwa ngokumane kakhulu. Beka isikhombisi emkhakheni wewindi lezingxoxo. Okulandelayo, ngokufaka imicibisholo yesinxele segundane, khetha wonke amaseli kukholomu. "Thenga 1"ezinamanani ezinombolo. Ikheli laboniswa masinyane ebhokisini lempikiswano njengoba izixhumanisi zezinhlaka zicutshungulwa. Chofoza inkinobho "Kulungile" phansi kwefasitela.



4. Inani lezinsuku eziyisikhombisa ze-esitolo sokuqala lizobonakala ngokushesha kuseli eliqukethe umsebenzi.



5. Khona-ke ungenza imisebenzi efanayo nomsebenzi SUM kanye namakholomu asele etafuleni, ebala kuwo inani lemali yezinsuku ezingu-7 ezitolo ezahlukene. I-algorithm yokusebenza iyofana nalokho echazwe ngenhla.

   Kodwa kukhona inketho yokusiza kakhulu umsebenzi. Ukwenza lokhu, sisebenzisa uphawu olufanayo lokugcwalisa. Khetha iseli esivele iqukethe umsebenzi. SUM, futhi welula uphawu oluhambisanayo nezihloko zekholomu kuze kube sekupheleni kwetafula. Njengoba ungabona, kulokhu, umsebenzi SUM ikopiwe ngendlela efanayo njengoba sasikopishe ngaphambilini ifomula elula yezibalo.



6. Ngemuva kwalokho, khetha iseli elingenalutho kushidi, lapho sicabanga khona ukubonisa umphumela ophelele wokubala kuzo zonke izitolo. Njengendlela yangaphambilini, ingaba yinoma iyiphi into yekhredithi yamahhala. Ngemuva kwalokho sibiza ngendlela eyaziwayo Umsebenzi weWebhu bese uhambisa efasiteleni lempikiswano yokusebenza SUM. Kufanele sigcwalise insimu "Number1". Njengokwesikhashana esidlule, sabeka isikhombisi ensimini, kodwa ngalesi sikhathi inkinobho yegundane lesokunxele egcinwe phansi, khetha yonke umugqa wezindalini zemali ezenzelwe izitolo ngabanye. Ngemuva kokuthi ikheli lale khoyunithi njengereferensi ehlanganisiwe ingene emkhakheni wewindi lempikiswano, chofoza inkinobho. "Kulungile".



7. Njengoba ungabona, inani lemali engenayo kuzo zonke izitolo ngenxa yomsebenzi SUM Kuboniswe esitokisini esakhelwe ngaphambilini.

Kodwa ngezinye izikhathi kunezimo lapho udinga ukubonisa umphumela jikelele kuwo wonke amabhizinisi ngaphandle kokubheka phezulu ama-subtotals ezitolo zomuntu ngamunye. Njengoba kuvela, opharetha SUM futhi ingakwazi, futhi ikhambi le nkinga lilula ngisho nokusebenzisa inguqulo yangaphambilini yale ndlela.

1. Njengoba njalo, khetha iseli kushidi lapho umphumela wokugcina uzoboniswa khona. Shayela Umsebenzi weWebhu chofoza kusithonjana "Faka umsebenzi".



2. Ivula Umsebenzi weWebhu. Ungahambisa esigabeni "Isibalo"kodwa uma usanda kusebenzisa opharetha SUMnjengoba senza, khona-ke ungahlala esigabeni "Kamuva Kusetshenziswa" bese ukhetha igama elifunayo. Kufanele kube khona. Chofoza inkinobho "Kulungile".



3. Iwindi lempikiswano iqala futhi. Faka i-cursor ensimini "Number1". Kodwa ngalesi sikhathi sibamba inkinobho yesinxele segundane bese ukhetha yonke i-tabular array, equkethe imali yazo zonke izindawo. Ngakho, insimu kufanele ithole ikheli lonke uhla lwetafula. Esimweni sethu, inefomu elilandelayo:

   B2: F8

   Kodwa-ke, eqinisweni, ikheli lizohluka. Isikhathi esivamile kuphela ukuthi izixhumanisi zeseli eliphezulu elingakwesokunxele le-array zizoba ngowokuqala kuleli kheli, futhi isici sokunene ngezansi sizoba ngowokugcina. Lezi zixhumanisi zizohlukaniswa nge-colon (:).

   Ngemuva kokuthi ikheli elihle lifakwe, chofoza inkinobho "Kulungile".



4. Emva kwalezi zenzo, umphumela wokwengezwa kwedatha uzoboniswa kuseli elihlukile.

Uma sicabangela le ndlela kusuka kumbono wezobuchwepheshe kuphela, asikho phansi amakholomu, kodwa wonke uhlaka. Kodwa umphumela waba okufanayo, njengokungathi ikholomu ngayinye yanezelwa ngokuhlukile.

Kodwa zikhona izimo lapho udinga ukungeza wonke amakholomu wetafula, kodwa kuphela okunye. Umsebenti uba nzima nakakhulu uma bengangeni emngceleni. Ake sibheke ukuthi lolu hlobo lokungezelela lwenziwa kanjani ngokusebenzisa opharetha be-SUM ngesibonelo setafula elifanayo. Ake sithi sidinga kuphela ukwengeza amakholomu wekholomu "Thenga 1", "Thenga 3" futhi "Thenga 5". Lokhu kudinga ukuthi umphumela ubalwa ngaphandle kokususa ama-subtotals ngamakholomu.

1. Setha isikhombisi esitokisini lapho umphumela uzoboniswa khona. Shayela ifasitela lezingqinamba zomsebenzi SUM ngendlela efanayo okwenziwe ngaphambili.

   Ewindini evuliwe ensimini "Number1" faka ikheli lebanga ledatha kukholomu "Thenga 1". Senza ngendlela efanayo nangaphambili: setha isikhangiso endle bese ukhetha ibanga elifanele letafula. Emasimini "Number2" futhi "Number3" ngokulandelana, sifaka amakheli we-data arrays kukholomu "Thenga 3" futhi "Thenga 5". Esikhathini sethu, izixhumanisi zangena zilandelayo:

   B2: B8
I-D2: D8
F2: F8

   Khona-ke, njengoba njalo, chofoza inkinobho. "Kulungile".



2. Ngemuva kokuba lezi zenzo ziphelile, umphumela wokwengeza inani lemali engenayo kusuka ezitolo ezintathu eziphuma ezinhlanu kuzoboniswa esakhiweni esilitshe.

Isifundo: Ukusebenzisa i-Wizard Wizard ku-Microsoft Excel

Njengoba ubona, kunezindlela ezintathu eziyinhloko zokwengeza amakholomu ku-Excel: usebenzisa isamba semoto, ifomula kanye nomsebenzi SUM. Ukukhetha okulula futhi okusheshayo ukusebenzisa i-auto sum. Kodwa kuyinto elula kakhulu futhi ngeke isebenze kuzo zonke izimo. Okukhethwa kukho okuguquguqukayo kakhulu ukusetshenziswa kwamafomu ezembalo, kepha akusizenzekelayo futhi kwezinye izimo, ngenani elikhulu lemininingwane, ukuqaliswa kwalo ekusebenzeni kungathatha isikhathi esiningi. Sebenzisa umsebenzi SUM kungabizwa ngokuthi "igolide" phakathi kwalezi zindlela ezimbili. Lolu khetho luyashintshashintsha futhi luyashesha.