Izindlela Zokuqhathanisa Kwethebula ku-Microsoft Excel

Kaningi, abasebenzisi be-Excel babhekene nomsebenzi wokuqhathanisa amatafula noma uhlu lwamabili ukukhomba umehluko noma izinto ezingekho kuzo. Umsebenzisi ngamunye ubhekana nalomsebenzi ngendlela yakhe, kepha isikhathi esiningi sichithwa ukuxazulula lolu daba, ngoba akuyona yonke indlela enale nkinga enengqondo. Ngaso leso sikhathi, kunama-algorithms afakazelwe wesenzo azokuvumela ukuthi uqhathanise uhlu noma ukuhlelwa kwetafula ngesikhathi esifushane ngokuzikhandla. Ake sihlolisise lezi zinketho.

Bheka futhi: Ukuqhathanisa amadokhumenti amabili ku-MS iZwi

Izindlela zokuqhathanisa

Kunezindlela ezimbalwa impela zokuqhathanisa izikhala zamatafula ku-Excel, kepha zonke zingahlukaniswa ngamaqembu amakhulu amathathu:

Ngokusekelwe kulolu hlaka, okokuqala, izindlela zokuqhathanisa zikhethiwe, kanye nezenzo ezithile nama-algorithms enzelwe lowo msebenzi. Isibonelo, uma uqhathanisa ezincwadini ezahlukahlukene, udinga ukuvula amafayela amabili e-Excel ngasikhathi sinye.

Ngaphezu kwalokho, kufanele kuthiwe ukuqhathanisa izindawo zetafula kunengqondo kuphela uma kunesakhiwo esifanayo.

Indlela yoku-1: ifomula elula

Indlela elula yokuqhathanisa idatha kumatafula amabili ukusebenzisa ifomula elula yokulingana. Uma idatha ifana, khona-ke inikeza inkomba ye-TRUE, futhi uma kungenjalo, FALSE. Ungaqhathanisa idatha yezinombolo nemibhalo. Okubi ngale ndlela ukuthi ingasetshenziswa kuphela uma idatha esetafuleni i-oda noma ihlelwe ngendlela efanayo, ivumelanisiwe futhi inenombolo efanayo yemigqa. Ake sibheke ukuthi iyisebenzisa kanjani le ndlela ukwenza umkhuba nesibonelo samatafula amabili abekwe ephepheni elilodwa.

Ngakho-ke, sinamatafula amabili alula anezinhlu zabasebenzi nemholo yabo. Kuyadingeka ukuqhathanisa uhlu lwabasebenzi futhi ukhombe ukungahambelani phakathi kwamakholomu amagama abekwe kuwo.

1. Ukwenza lokhu, sidinga ikholamu eyengeziwe eshidini. Sifaka isibonakaliso lapho "=". Ngemuva kwalokho sichofoza entweni yokuqala ofuna ukukuqhathanisa ohlwini lokuqala. Sibeka uphawu futhi "=" kusuka kukhibhodi. Okulandelayo, chofoza kuseli lokuqala lekholamu esilifanisa ethebuleni lesibili. Umphumela uba isichasiselo sohlobo olulandelayo:

   = A2 = D2

   

   Yize kunjalo, esimweni ngasinye, izixhumanisi zizohluka, kepha umnyombo uzohlala unjalo.

2. Chofoza inkinobho Ngenaukuthola imiphumela yokuqhathanisa. Njengoba ukwazi ukubona, lapho uqhathanisa amaseli okuqala alolu hlu zombili, uhlelo luveze inkomba "IQINISO", okusho ukufana kwedatha.



3. Manje sidinga ukwenza umsebenzi ofanayo namanye amaseli womatafula womabili amakholomu esiwaqhathanisa. Kepha ungamane ukopishe ifomula, ezonga isikhathi kakhulu. Le nto ibaluleke kakhulu uma uqhathanisa uhlu ngenani elikhulu lemigqa.

   Inqubo yekhophi yenziwa kalula kusetshenziswa umaki wokugcwalisa. Siphambuka ekhoneni elingezansi kweseli, lapho sithole khona inkomba "IQINISO". Ngasikhathi sinye, kufanele iguqulwe isiphambano esimnyama. Lesi umaki lokugcwalisa. Sicindezela inkinobho yegundane kwesobunxele bese sihudula isikhombisi phansi kunombolo yemigqa kumugqa wethebula eliqhathaniswe.



4. Njengoba ukwazi ukubona, manje kwikholamu eyengeziwe yonke imiphumela yokuqhathaniswa kwedatha kumakholomu amabili wokuhleleka kwetafula ayaboniswa. Esimweni sethu, idatha emugqeni owodwa kuphela ayihambelani. Lapho uziqhathanisa, ifomula iveze umphumela FALSE. Kuyo yonke eminye imigqa, njengoba sibona, ifomula lokuqhathanisa likhiqize inkomba "IQINISO".



5. Ngaphezu kwalokho, kungenzeka ukubala inani lokungafani usebenzisa ifomula ekhethekile. Ukuze wenze lokhu, khetha into eshidi lapho izokhonjiswa khona. Bese uchofoza isithonjana "Faka umsebenzi".



6. Ewindini Umsebenzi Wizards eqenjini labasebenzayo "Izibalo" khetha igama SUMPRuction. Chofoza inkinobho "Kulungile".



7. Iwindi lokuphikisana ngomsebenzi lisebenza. SUMPRuctionUmsebenzi wawo oyinhloko ukubala isamba semikhiqizo yohla olukhethiwe. Kepha lo msebenzi ungasetshenziselwa izinhloso zethu. I-syntax ilula:

   = SUMPRODUCT (uhlu1; uhlu2; ...)

   Sekukonke, amakheli afinyelela ku-255 arrays angasetshenziswa njengezimpikiswano. Kepha esimeni sethu, sizosebenzisa uhlu lwamagama amabili kuphela, ngaphezu kwalokho, njengengxabano eyodwa.

   Faka ikhesa endle "I-Array1" bese ukhetha ephepheni uhla ledatha eliqhathaniswe endaweni yokuqala. Ngemuva kwalokho, faka uphawu enkundleni alilingani () bese ukhetha ibanga eliqhathaniswe lesifunda sesibili. Okulandelayo, bopha inkulumo evelayo kubakaki ngaphambi kokufaka izinhlamvu ezimbili "-". Kithina, le nkulumo yavela:

   - (A2: A7D2: D7)

   Chofoza inkinobho "Kulungile".



8. U-opharetha abale futhi akhombise umphumela. Njengoba ukwazi ukubona, kithi, imiphumela ilingana nenombolo "1", okungukuthi, kusho ukuthi ukutholakala kokunye okungalungile kutholakale kuhlu oluqhathanisiwe. Uma uhlu belucishe lufane, umphumela wazo ubuyobe ulingana nenani "0".

Ngendlela efanayo, ungaqhathanisa idatha ematafuleni akhiwe kumashidi ahlukene. Kepha kulokhu, kufiseleka ukuthi imigqa ekuyo ibalwe. Ngaphandle kwalokho, inqubo yokuqhathanisa icishe ifane njengoba kuchaziwe ngenhla, ngaphandle kokuthi uma ufaka ifomula kufanele ushintshe phakathi kwamashidi. Kithi, le nkulumo izobukeka kanjena:

= B2 = Ishidi2! B2

Lokho, njengoba sibona, ngaphambi kokuhlanganiswa kwemininingwane, etholakala kwamanye amashidi, ngaphandle kwalapho kukhonjiswa khona umphumela wokuqhathanisa, kuboniswa inombolo yephepha kanye nophawu lwesibabazo.

Indlela 2: khetha amaqembu weseli

Ukuqhathanisa kungenziwa kusetshenziswa ithuluzi lokukhethwa kweqembu leselula. Ingasetshenziswa futhi ukuqhathanisa izinhlu ezivumelanisiwe kuphela nezi-odwawe. Ngaphezu kwalokho, kulokhu, izinhlu kufanele zibekwe eceleni komunye nomunye ephepheni elilodwa.

1. Sikhetha ukufana okuqhathanisiwe. Iya kuthebhu "Ikhaya". Okulandelayo, chofoza isithonjana Thola nokugqamisaetholakala kubambo kubhokisi lamathuluzi "Ukuhlela". Uhlu luvula lapho ukhetha isikhundla "Ukukhetha iqembu lamaseli ...".

   

   Ngaphezu kwalokho, singafika efasiteleni elifunayo lokukhetha iqembu lamaseli ngenye indlela. Le nketho izoba wusizo ikakhulukazi kulabo basebenzisi abafake inguqulo yohlelo ngaphambili kwe-Excel 2007, kusukela indlela ngokusebenzisa inkinobho Thola nokugqamisa lezi zicelo azixhasi. Sikhetha ama-arrows esifuna ukuwaqhathanisa, bese sicindezela ukhiye F5.

2. Iwindi lokuguqula okuncane liyasebenza. Chofoza inkinobho "Khetha ..." ekhoneni layo elingaphansi kwesobunxele.



3. Ngemuva kwalokho, kunoma ikuphi kulezi zinketho ezimbili ezingenhla ozikhethayo, kuvulwa iwindi lokukhetha amaqembu amaseli. Setha ukushintshela esikhundleni "Khetha umugqa ngomugqa". Chofoza inkinobho "Kulungile".



4. Njengoba ukwazi ukubona, ngemuva kwalokhu amanani wokungalingani emigqeni azoqokonyiswa nge-hue ehlukile. Ngaphezu kwalokho, njengoba kungahlulelwa ngokuqukethwe kokuqukethwe kwebha yfomula, uhlelo luzokwenza elinye lamaseli atholakale kwimigqa ebekiwe engakhonjwanga.

Indlela 3: ukufometha okunemibandela

Ungaqhathanisa usebenzisa indlela yokufometha enemibandela. Njengaseyindlela eyedlule, izindawo eziqhathaniswayo kufanele zibe ekhasini lokusebenzela elilodwa le-Excel futhi zivumelaniswe.

1. Okokuqala, sikhetha ukuthi iyiphi indawo yetafula esizoyicabangela eyinhloko, nokuthi sizofuna umohluko kuyo. Asente loku kwekugcina etafuleni lesibili. Ngakho-ke, sikhetha uhlu lwezisebenzi ezikulo. Ngokuhambisa kuthebhu "Ikhaya"chofoza inkinobho Ukufomatha okunemibandelaelibekwe etheyipu ebhlokini Izitayela. Ukusuka ohlwini olwehliswayo, iya ku Ukuphathwa Kwemithetho.



2. Iwindi lemenenja yomthetho liyasebenza. Chofoza inkinobho ekuyo Dala Ukubusa.



3. Ewindini eliqala, khetha isikhundla Sebenzisa ifomula. Ensimini "Amaseli Efomethi" bhala ifomula equkethe amakheli amaseli okuqala kwamakholamu aqhathaniswe, ahlukaniswe isibonakaliso "esingalingani" () Le nkulumo kuphela ezobhekana nalesi sikhathi. "=". Ngaphezu kwalokho, ikheli eliphelele kufanele lisetshenziswe kubo bonke abaxhumanisi bekholomu kule fomula. Ukuze wenze lokhu, khetha ifomula enesikhombi bese ucindezela ukhiye amahlandla amathathu F4. Njengoba ubona, uphawu lwedola luvele eduze nawo wonke amakheli ekholamu, okusho ukuguqula izixhumanisi zibe ezona. Ngokwesimo sethu esithile, ifomula izothatha ifomu elilandelayo:

   = $ A2 $ D2

   Sibhala le nkulumo enkambu engenhla. Ngemuva kwalokho chofoza inkinobho "Ifomathi ...".



4. Iwindows liyasebenza Uhlobo Lweseli. Iya kuthebhu "Gcwalisa". Lapha kuhlu lwemibala simisa ukukhetha kumbala esifuna ukufaka umbala kuwo kulezo zinto lapho idatha ingekho khona. Chofoza inkinobho "Kulungile".



5. Ukubuyela ewindini lokwenza umthetho wokufometha, chofoza inkinobho "Kulungile".



6. Ngemuva kokuya ngokuzenzakalelayo ewindini Imenenja Yemithetho chofoza inkinobho "Kulungile" futhi kuyo.



7. Manje kwithebula lesibili, izinto ezinemininingwane engahambelani namanani ahambelana nendawo yethebula lokuqala zizogqanyiswa ngombala okhethiwe.

Kunenye indlela yokusebenzisa ukufomatha okunemibandela emsebenzini. Njengokukhetha kwangaphambilini, kudinga indawo yazo zombili izindawo eziqhathaniswe kwiphepha elilodwa, kepha ngokungafani nezindlela ezichazwe ngaphambilini, isimo sokuvumelanisa noma sokuhlunga idatha ngeke sibe sesiphoqelekile, esihlukanisa le nketho kokuchazwe ngaphambili.

1. Sikhetha izindawo okufanele ziqhathaniswe.



2. Iya kuthebhu ebizwa ngokuthi "Ikhaya". Chofoza inkinobho Ukufomatha okunemibandela. Uhlu olusetshenzisiwe, khetha isikhundla Imithetho Yokukhetha Iseli. Kumenyu elandelayo senza ukukhetha kwesikhundla Amanani okuphindwayo.



3. Iwindi lokulungiselela ukukhethwa kwamanani aphindaphindwayo liqala. Uma wenze konke kahle, khona-ke kulewindi kuhlala kuphela uchofoza inkinobho "Kulungile". Noma, uma kufiswa, emkhakheni ohambelana naleli windi, ungakhetha umbala ohlukile ogqamile.



4. Ngemuva kokuthi senze isenzo esibekiwe, zonke izinto eziphindaphindwayo zizogqanyiswa ngombala okhethiwe. Lezo zinto ezingahambelani zizosala zipendwe ngombala wazo wokuqala (omhlophe ngokwakhona). Ngakho-ke, ngokushesha ungabona ngamehlo umehluko phakathi kokuhlelwa.

Uma ufisa, ungakwazi, kunalokho, faka imibala izinto ezingahanjisiwe, nalezo zinkomba ezihambelana, shiya ugcwalise ngombala ofanayo. Kulesi simo, i-algorithm yezenzo icishe ifane, kepha kuwindi lezilungiselelo lokuqokomisa amanani aphindayo enkampini yokuqala esikhundleni sepharamitha Impinda kufanele ukhethe "Uhlukile". Ngemuva kwalokho chofoza inkinobho "Kulungile".

Ngakho-ke, kuzocaciswa ngqo lezo zinkomba ezingahambelani.

Isifundo: Ukufometha okunemibandela ku-Excel

Indlela 4: ifomula eyinkimbinkimbi

Ungase futhi uqhathanise idatha usebenzisa ifomula eyinkimbinkimbi esekwe emsebenzini I-COUNTING. Usebenzisa leli thuluzi, ungbala ukuthi ingakanani into ngayinye evela kukholamu ekhethiwe yetafula lesibili ephindaphindwa kokuqala.

Umsebenzi I-COUNTING kubhekiswa eqenjini lezibalo zemisebenzi. Umsebenzi wawo ukubala inani lamaseli amanani awo anelise isimo esithile. I-syntax yalokhu ku-opharetha imi kanje:

= COUNTIF (ibanga; inqubomgomo)

Ukuxabana "Ububanzi" imele ikheli lezinhlelo eziningi lapho amanani afanayo abalwa khona.

Ukuxabana "Indawo yokuhlala" isetha isimo sokufana. Esimweni sethu, kuzoba izixhumanisi zamaseli athile endaweni yetafula lokuqala.

1. Sikhetha into yokuqala yekholamu eyengeziwe lapho kuzobalwa inani lemeshi. Okulandelayo, chofoza isithonjana "Faka umsebenzi".



2. Ukuqala Umsebenzi Wizards. Iya esigabeni "Izibalo". Thola igama ohlwini "COUNTIF". Ngemuva kokuyikhetha, chofoza inkinobho "Kulungile".



3. Ukuqaliswa Kwe-Window Ye-Operator Argument I-COUNTING. Njengoba ukwazi ukubona, amagama ezinkambu kuleli windi ahambelana namagama aphikisayo.

   Setha isikhombisi esigangeni "Ububanzi". Ngemuva kwalokho, ubambe inkinobho yegundane kwesobunxele, khetha wonke amanani ekholamu enamagama etafula lesibili. Njengoba ubona, izixhumanisi ziwela ngokushesha enkombeni echaziwe. Kepha ngezinhloso zethu, leli kheli kufanele lenziwe liphelele. Ukuze wenze lokhu, khetha lezi zixhumanisi ensimini bese ucindezela ukhiye F4.

   Njengoba ukwazi ukubona, isixhumanisi sithathe ifomu eliphelele, elibonakaliswa ukuba khona kwezimpawu zamadola.

   Ngemuva kwalokho uye ensimini "Indawo yokuhlala"ngokubeka isikhombisi lapho. Sichofoza entweni yokuqala enamagama okugcina ohlwini lwethebula lokuqala. Kulokhu, shiya isihlobo sesixhumanisi. Ngemuva kokuthi iboniswe enkundleni, ungachofoza inkinobho "Kulungile".



4. Umphumela uboniswa entweni eshidi. Ilingana nenombolo "1". Lokhu kusho ukuthi ohlwini lwamagama etafuleni lesibili, igama lokugcina "I-Grinev V.P.", okungowokuqala ohlwini lohlu lwethebula lokuqala, kwenzeka kanye.



5. Manje sidinga ukudala inkomba efanayo kuzo zonke ezinye izinto zethebula lokuqala. Ukwenza lokhu, sizokopisha kusetshenziswa umaki wokugcwalisa, njengoba sasiwenzile ngaphambili. Faka ikhesa engxenyeni engezansi kwesokudla yento eshidi eliqukethe umsebenzi I-COUNTING, futhi ngemuva kokuyiguqula isimaki sokugcwalisa, bamba phansi inkinobho yegundane kwesobunxele bese uhudula isikhombisi phansi.



6. Njengoba ukwazi ukubona, uhlelo lwahlanganisa okwenzeka ngokuthelekisa iseli ngalinye lethebula lokuqala nedatha etholakala ebangeni lesibili lethebula. Ezimweni ezine, umphumela uphume "1", futhi ezimweni ezimbili - "0". Okusho ukuthi, uhlelo alukwazanga ukuthola etafuleni lesibili amanani amabili okukuhlu lokuqala lwethebula.

Impela, le nkulumo, ukuze uqhathanise izinkomba ze-tabular, ingasetjenziswa ngendlela yayo ekhona, kepha kukhona ithuba lokuyithuthukisa.

Siyaqiniseka ukuthi lawo manani asetafuleni lesibili, kepha angawokuqala, aboniswa ohlwini olwehlukile.

1. Okokuqala, sizoyilungisa kancane ifomula yethu I-COUNTING, okungukuthi, sikwenza kube ngenye yezimpikiswano zika-opharetha UMA. Ukuze wenze lokhu, khetha iseli lokuqala lapho opharetha etholakala khona I-COUNTING. Emugqeni wezindlela ezingaphambi kwaso, engeza isisho UMA ngaphandle kwezingcaphuno bese uvula ubakaki. Okulandelayo, ukwenza kube lula ngathi ukusebenza, khetha inani kubha yefomula UMA bese uchofoza isithonjana "Faka umsebenzi".



2. Iwindi lokuphikisana ngomsebenzi liyavula UMA. Njengoba ukwazi ukubona, inkambu yokuqala yewindows isivele igcwaliswe ngenani le-opharetha I-COUNTING. Kepha kudingeka sengeze enye into kulo mkhakha. Sisetha ikhesa lapho bese sengeza enkulumeni ekhona "=0" ngaphandle kwezingcaphuno.

   Ngemuva kwalokho, iya ensimini "Okusho ukuthi uma kuyiqiniso". Lapha sizosebenzisa omunye umsebenzi odaliwe - IZENZO. Faka igama IZENZO ngaphandle kwezingcaphuno, bese uvula amabakaki bese ucacisa izixhumanisi zeseli lokuqala elinegama lokugcina etafuleni lesibili, bese uvala amabakaki. Ngokukhethekile, kithi, enkundleni "Okusho ukuthi uma kuyiqiniso" Kwavela le nkulumo elandelayo:

   I-LINE (D2)

   Manje opharetha IZENZO izobika imisebenzi UMA inombolo yomugqa lapho kutholakala khona igama elithile lokugcina, futhi esimeni lapho isimo esishiwo endle kuqala sanelisekile, umsebenzi UMA izoveza le nombolo esitokisini. Chofoza inkinobho "Kulungile".



3. Njengoba ukwazi ukubona, umphumela wokuqala uyakhonjiswa njengoba FALSE. Lokhu kusho ukuthi inani alizanelisi imibandela opharetha. UMA. Okusho ukuthi, isibongo sokuqala sikhona kuloluhlu zombili.



4. Sisebenzisa umaki wokugcwalisa, sikopisha isibonakaliso sopharetha ngendlela ejwayelekile UMA kwikholamu yonke. Njengoba ubona, ezikhundleni ezimbili ezikhona etafuleni lesibili, kepha hhayi ezokuqala, ifomula inika izinombolo zemigqa.



5. Sisuka endaweni yetafula siye kwesokudla futhi sigcwalisa ikholomu ngezinombolo ngokulandelana, kusukela 1. Inani lezinombolo kufanele lifane nenani lemigqa esetafuleni lesibili okufanele liqhathaniswe. Ukusheshisa inqubo yokubala, ungasebenzisa futhi umaki wokugcwalisa.



6. Ngemuva kwalokho, khetha iseli lokuqala ngakwesokudla kwikholamu ngezinombolo bese uchofoza isithonjana "Faka umsebenzi".



7. Iyavula Isici Wizard. Iya esigabeni "Izibalo" bese ukhetha igama "OKUPHELELE". Chofoza inkinobho "Kulungile".



8. Umsebenzi OKUPHELELEokuvulwe iwindi lokuxabanisa, kuhloswe ngalo ukubonisa inani elincane kakhulu elishiwo ku-akhawunti.

   Ensimini Array chaza izixhumanisi zobubanzi bekholomu eyengeziwe "Inani Lokufana"esake sakuguqula sisebenzisa umsebenzi UMA. Senza zonke izixhumanisi ziphelele.

   Ensimini "K" kubonisa ukuthi iyiphi i-akhawunti yenani eliphansi kakhulu elidingiswayo ukubonisa Lapha sibonisa izixhumanisi zeseli lokuqala lekholamu elinenombolo, esisanda kungeza. Sishiya isihlobo sekheli. Chofoza inkinobho "Kulungile".



9. U-opharetha ukhombisa umphumela - inombolo 3. Kuyinto encane kunazo zonke ezinombolo ezingekho emugqeni wokuphamba okungafanele. Usebenzisa umaki wokugcwalisa, kopisha ifomula phansi kakhulu.



10. Manje, ngokwazi izinombolo zemigqa yezinto ezingahanjiswanga kahle, singafaka amaseli amanani abo sisebenzisa umsebenzi INDEX. Khetha into yokuqala eshidi eliqukethe ifomula OKUPHELELE. Ngemuva kwalokho, iya emugqeni wamafomula naphambi kwegama "OKUPHELELE" engeza igama INDEX ngaphandle kwezingcaphuno, vula ngokushesha ubakaki bese ubeka i-semicolon (;) Bese ukhetha igama emugqeni wamafomula INDEX bese uchofoza isithonjana "Faka umsebenzi".



11. Ngemuva kwalokho, kuvuleka iwindi elincane lapho udinga ukunquma khona ukubukwa kwesethenjwa okufanele kube nomsebenzi INDEX noma yakhelwe ukusebenza ngama-arrays. Sidinga inketho yesibili. Ifakwe ngokuzenzakalela, ngakho-ke kule windi chofoza inkinobho "Kulungile".



12. Iwindi lokuphikisana ngomsebenzi liyaqala INDEX. Lo opharetha kuhloswe ukukhipha inani elitholakala kuluhlu oluthile entanjeni ebekiwe.

    Njengoba ubona, insimu Inombolo yomugqa isivele igcwaliswe ngamanani wokusebenza OKUPHELELE. Ukusuka kunani elivele likhona lapho, umehluko phakathi kokufakwa kwenombolo kweshidi le-Excel nenombolo yangaphakathi yendawo yetafula kufanele kukhishwe. Njengoba ukwazi ukubona, sinesihloko kuphela ngaphezulu kwamanani etafula. Lokhu kusho ukuthi umehluko umugqa owodwa. Ngakho-ke, singeza ensimini Inombolo yomugqa inani "-1" ngaphandle kwezingcaphuno.

    Ensimini Array chaza ikheli lobubanzi bamanani ethebula lesibili. Ngasikhathi sinye, senza konke ukuhlangana kube ngokuphelele, okungukuthi, sibeka phambi kwabo uphawu lwedola ngendlela esichaze ngayo ngaphambili.

    Chofoza inkinobho "Kulungile".



13. Ngemuva kokubonisa umphumela esikrinini, sinwebisa umsebenzi usebenzisa umaki wokugcwalisa ezansi kwekholomu. Njengoba ukwazi ukubona, zombili izibongo ezikhona etafuleni lesibili, kepha ezingekho kolokuqala, zikhonjiswa ebangeni elihlukile.

Indlela yesi-5: qhathanisa ukuhlelwa kwezincwadi ezincwadini ezihlukile

Lapho uqhathanisa amabanga ezincwadini ezahlukahlukene, ungasebenzisa izindlela ezingenhla, ngaphandle kwalezo ongakhetha kuzo lapho ufuna ukubeka khona zombili lezo zindawo zetafula ekhasini elilodwa. Isimo esikhulu senqubo yokuqhathanisa kuleli cala ukuvula amafasitela womabili amafayela ngasikhathi sinye. Ngezinhlobo ze-Excel 2013 nangemva kwalokho, kanye nezinguqulo ngaphambi kwe-Excel 2007, azikho izinkinga ngalesi simo. Kepha ku-Excel 2007 naku-Excel 2010, ukuze uvuleke zombili amawindi ngasikhathi sinye, imishini ezengeziwe iyadingeka. Ukwenza kanjani lokhu kuchazwa esifundweni esihlukile.

Isifundo: Ungayivula kanjani i-Excel kumawindi ahlukene

Njengoba ukwazi ukubona, maningi amathuba okuqhathanisa amatafula phakathi kwabo. Yikuphi ongakhetha ukuyisebenzisa kuncike ekutheni idatha yedatha yetabheli itholakala kuphi ihlangene (ekhasini elilodwa, ezincwadini ezahlukene, kumashidi ahlukene), futhi nokuthi umsebenzisi ufuna lokhu kukhanya kuboniswe kangakanani esikrinini.