Kubalwa amanani kukholamu ku-Microsoft Excel

Kwezinye izimo, umsebenzisi akanikwa msebenzi wokubala inani lamanani akholamu, kodwa ngokubala inani lawo. Lokho wukuthi, ngokubeka nje, udinga ukubala ukuthi mangaki amaseli kule kholamu agcwaliswa ngemininingwane ethile yezinombolo noma yombhalo. Ku-Excel kunamathuluzi amaningi angaxazulula le nkinga. Ake sibheke ngamunye wabo ngokwehlukana.

Bheka futhi: Ungabalwa kanjani inani lemigqa ku-Excel
Ungasibala kanjani isibalo samaseli agcwele ku-Excel

Inqubo Yokubala Ikholomu

Ngokuya ngezinhloso zomsebenzisi, ku-Excel ungabala onke amanani kukholamu, kuphela idatha yezinombolo nalezo ezihambisana nesimo esithile esinikeziwe. Ake sibheke ukuthi ingaxazululwa kanjani imisebenzi ngezindlela ezahlukahlukene.

Indlela 1: inkomba kubha yesimo

Le ndlela iyindlela elula kunazo zonke futhi idinga inani elithile lesenzo. Ikuvumela ukubala inani lamaseli aqukethe idatha yezinombolo nemibhalo. Ungakwenza lokhu ngokumane ubheke inkomba ebhajeni yesimo.

Ukuqedela lo msebenzi, mane ubambe inkinobho yegundane kwesobunxele bese ukhetha ikholomu yonke ofuna ukubala kuyo amanani. Lapho nje ukukhethwa sekwenziwe, kubha yesimo, etholakala ezansi kwewindi, eduze kwepharamitha "Ubuningi" Inani lamanani aqukethe ikholomu lizoboniswa. Amaseli agcwele noma iyiphi idatha (amanani, umbhalo, usuku, njll.) Azobamba iqhaza ekubalweni. Izinto ezingenalutho ngeke zishaye indiva lapho kubalwa.

Kwezinye izimo, inkomba yenombolo yamanani ngeke ivezwe kubha yesimo. Lokhu kusho ukuthi kungenzeka ukuthi ikhubazeke kakhulu. Ukuze uyinike amandla, chofoza kwesokudla kubha yesimo. Imenyu iyavela. Kuyo udinga ukubheka ibhokisi eliseduze "Ubuningi". Ngemuva kwalokho, inani lamaseli agcwele imininingwane lizokhonjiswa kubha yesimo.

Okubi ngale ndlela kufaka neqiniso lokuthi umphumela awuhleliwe ndawo. Okusho ukuthi, lapho ususa ukukhetha, kuzoshabalala. Ngakho-ke, uma kunesidingo, kulungise, kuzodingeka uqophe umphumela ngesandla. Ngaphezu kwalokho, ngokusebenzisa le ndlela, kungenzeka ukubala wonke amaseli agcwele amanani futhi akunakwenzeka ukusetha izimo zokubala.

Indlela yesi-2: Isisebenzisi se-ACCOUNTS

Usebenzisa opharetha IZAKHONOnjengasesimweni esedlule, kungenzeka ukubala wonke amanani atholakala kukholamu. Kepha ngokungafani nenketho enesikhombi emugqeni wesimo, le ndlela inikeza ikhono lokuqopha umphumela entweni ehlukile yeshidi.

Injongo eyinhloko yomsebenzi IZAKHONO, okuyisigaba sezibalo sabahlinzeki, sibala inani lamaseli angenalutho. Ngakho-ke, singakwazi ukuzivumelanisa kalula nezidingo zethu, okungukuthi, ukubala izakhi zekholomu ezigcwele idatha. I-syntax yalomsebenzi imi kanje:

= COUNT (inani1; inani2; ...)

Sekukonke, opharetha bangaba nokuphikisana okungafika ku-255 kweqembu elijwayelekile "Inani". Izimpikiswano ziyizinkomba nje zamaseli noma ibanga ofuna ukubala ngalo amanani.

1. Khetha into eshidi lapho umphumela wokugcina uzokhonjiswa khona. Chofoza isithonjana "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.



2. Sabiza kanjalo Isici Wizard. Iya esigabeni "Izibalo" bese ukhetha igama I-SCHETZ. Ngemuva kwalokho chofoza inkinobho "Kulungile" phansi kwale windi.



3. Saya ewindini lokuphikisana lomsebenzi IZAKHONO. Kuqukethe izinkambu zokufaka zezimpikiswano. Njengesibalo sokuphikisana, bangafinyelela amayunithi angama-255. Kodwa ukuxazulula umsebenzi obekwe phambi kwethu, inkambu eyodwa yanele "Inani1". Sibeka isikhombisi kuyo bese kuthi ngemuva kwalokho, ngokucindezela inkinobho yegundane kwesobunxele, khetha ikholomu eshidini ofuna ukubala amanani akhe. Ngemuva kokuthi izixhumanisi zekholomu zikhonjiswe endle, chofoza inkinobho "Kulungile" ngaphansi kwewindi lokuphikisana.



4. Uhlelo lubalwa futhi luboniswe esitokisini esikukhethile esinyathelweni sokuqala salo myalo, inani lawo wonke amanani (okubalwa ngezinombolo nangombhalo) okukholamu okuqondiwe.

Njengoba ukwazi ukubona, ngokungafani nendlela yangaphambilini, le nketho inikezela ukubonisa umphumela kutho oluthile lweshidi ngokulondolozwa kwalo lapho. Kodwa ngeshwa, umsebenzi IZAKHONO noma kunjalo, akuvumeli ukucacisa izimo zokukhethwa kwamanani.

Isifundo: I-Excel Workiz Wizard

Indlela 3: opharetha we-ACCOUNT

Usebenzisa opharetha I-ACCOUNT amanani wokubala kuphela kwikholamu ekhethiwe angabalwa. Indiva izindinganiso zombhalo futhi azibandakanyi inani. Lo msebenzi futhi ungowesigaba sabasebenza ngokusebenza kwezibalo, njengaleso esedlule. Umsebenzi wakhe ukubala amaseli ebangeni elikhethiwe, kuthi thina, kukholamu equkethe amanani wokubala. I-syntax yalomsebenzi icishe ifane nesitatimende esedlule:

= COUNT (inani1; inani2; ...)

Njengoba ubona, izimpikiswano ze I-ACCOUNT futhi IZAKHONO ziyefana futhi zimelela izinkomba kumaseli noma amabanga. Umehluko ku-syntax usegameni le-opharetha uqobo.

1. Khetha into eshidini lapho umphumela uzokhonjiswa khona. Chofoza isithonjana esivele sisazi "Faka umsebenzi".



2. Ngemuva kokwethulwa Umsebenzi Wizards dlulela esigabeni futhi "Izibalo". Bese ukhetha igama "I-ACCOUNT" bese uchofoza inkinobho "OK".



3. Ngemuva kokuthi iwindi lokuphikisana no-opharetha seluqalisiwe I-ACCOUNT, kufanele ifakwe emkhakheni wakhe. Kuleli windi, njengasefasiteleni lomsebenzi owedlule, kuze kufike ezinkambeni ezingama-255, kodwa, njengokugcina, sidinga eyodwa yazo ebizwa ngokuthi "Inani1". Faka kule nkambu izixhumanisi zekholomu lapho kudingeka sisebenze khona. Lokhu sikwenza ngendlela efanayo naleso esenze le nqubo yokusebenza IZAKHONO: setha ikhesa endle bese ukhetha ikholomu yetafula. Ngemuva kokuthi ikheli lekholamu selifakiwe esigangeni, chofoza inkinobho "Kulungile".



4. Umphumela uzokhonjiswa ngokushesha esitokisini esikuchazele okuqukethwe komsebenzi. Njengoba ukwazi ukubona, uhlelo lubalwe kuphela amaseli aqukethe amanani ezinombolo. Amaseli angenalutho nezinto eziqukethe idatha yombhalo azifakwanga kubalo.

Isifundo: Bala umsebenzi ku-Excel

Indlela 4: opharetha abangu-COUNTIF

Ngokungafani nezindlela ezedlule, usebenzisa opharetha I-COUNTING ikuvumela ukuthi usethe izimo ezihambelana namanani azobamba iqhaza ekubalweni. Onke amanye amaseli ngeke anganakwa.

Umsebenzi I-COUNTING futhi kubalwa njengeqembu lezibalo lemisebenzi ye-Excel. Umsebenzi wawo kuphela ukubala izinto ezingenasici kuhlu, kuthi thina, kukholomu ehlangabezana nesimo esinikeziwe. I-syntax yalokhu ku-opharetha ihluke kakhulu kwimisebenzi emibili edlule:

= COUNTIF (ibanga; inqubomgomo)

Ukuxabana "Ububanzi" Limelwe njengesixhumanisi sokuhlotshaniswa kwamaseli athile, kuthi thina, kukholamu.

Ukuxabana "Indawo yokuhlala" iqukethe isimo esishiwo. Lokhu kungaba yinani eliqondile lezinombolo noma lombhalo, noma inani elishiwo yizimpawu ngaphezulu (>), kancane (<), alilingani (), njll.

Ase sibale mangaki amaseli anegama Inyama abekwe kukholamu lokuqala lethebula.

1. Khetha into eshidini lapho kuzokwenziwa khona umphumela wedatha eqediwe. Chofoza isithonjana "Faka umsebenzi".



2. In Umsebenzi wizadi yenza inguquko kusigaba "Izibalo", khetha igama I-COUNTING bese uchofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana ngomsebenzi lisebenza I-COUNTING. Njengoba ukwazi ukubona, iwindi linezindima ezimbili ezihambelana nokuphikisana komsebenzi.

   Ensimini "Ububanzi" ngendlela efanayo nale esesichaze ngayo kaningi, sifaka izixhumanisi zekholomu lokuqala lethebula.

   Ensimini "Indawo yokuhlala" sidinga ukusetha isimo sokubala. Faka igama lapho Inyama.

   Ngemuva kokuthi izilungiselelo ezingenhla seziqediwe, chofoza inkinobho "Kulungile".



4. U-opharetha wenza izibalo futhi abonise umphumela esikrinini. Njengoba ukwazi ukubona, kwikholamu ekhethiwe kumaseli angama-63 iqukethe igama Inyama.

Masishintshe umsebenzi kancane. Manje ake sibale inani lamaseli kukholamu efanayo engaqukethe igama Inyama.

1. Sikhetha iseli lapho sizokhipha khona umphumela, futhi ngendlela esichazwe ngayo ngaphambili sibiza iwindi lokuphikisana kosebenza I-COUNTING.

   Ensimini "Ububanzi" sifaka izixhumanisi zekholomu lokuqala letafula esalicubungula ngaphambili.

   Ensimini "Indawo yokuhlala" faka le nkulumo elandelayo:

   Inyama

   Lokho wukuthi, le nqubo ibeka umbandela wokuthi sibala zonke izinto ezigcwaliswe ngemininingwane engaqukethe igama Inyama. Sayina "" kusho ku-Excel alilingani.

   Ngemuva kokufaka lezi zilungiselelo ewindini lokuphikisana, chofoza inkinobho "Kulungile".



2. Umphumela uboniswa ngokushesha esitokisini esichaziwe. Ubika ukuthi kukholamu ekhethiwe kunezakhi ezingama-190 ezinemininingwane engaqukethe igama Inyama.

Manje ake senze kukholamu yesithathu yaleli thebula ukubalwa kwawo wonke amanani amakhulu kunenani le-150.

1. Khetha iseli ukubonisa umphumela bese uya ewindini lokuphikisana lomsebenzi I-COUNTING.

   Ensimini "Ububanzi" faka izixhumanisi zekholomu yesithathu yetafula lethu.

   Ensimini "Indawo yokuhlala" bhala le mibandela elandelayo:

   >150

   Lokhu kusho ukuthi uhlelo luzobala kuphela lezo zakhi zekholomu ezinamanani angaphezu kuka-150.

   Okulandelayo, njengokujwayelekile, chofoza inkinobho "Kulungile".



2. Ngemuva kokubala, i-Excel ikhombisa umphumela kuseli elichaziwe. Njengoba ukwazi ukubona, ikholomu ekhethiwe iqukethe amanani angama-82 adlula inani le-150.

Ngakho-ke, siyabona ukuthi e-Excel kunezindlela eziningi zokubala inani lamanani kukholamu. Ukukhethwa kwenketho ethile kuya ngemigomo ethile yomsebenzisi. Ngakho-ke, izinkomba kubha yesimo ikuvumela ukuthi ubone kuphela inani lawo wonke amanani asekholamu ngaphandle kokulungisa umphumela; umsebenzi IZAKHONO inikeza ithuba lokulungisa inani labo esitokisini esihlukile; opharetha I-ACCOUNT ibala kuphela izinto ezinedatha yezinombolo; nangomsebenzi I-COUNTING Ungasetha izimo ezinzima kakhulu zokubala izinto.