Izindlela zokuqhathanisa amatafula ku-Microsoft Excel

Ngokuvamile, abasebenzisi be-Excel babhekene nomsebenzi wokuqhathanisa amathebula amabili noma izinhlu zokukhomba umehluko noma izinto ezilahlekile kuzo. Umsebenzisi ngamunye uhlangabezana nalo msebenzi ngendlela yakhe, kodwa kaningi isikhathi esiningi kakhulu sisetshenziselwa ukuxazulula le nkinga, ngoba akuzona zonke izindlela zokwenza le nkinga. Ngesikhathi esifanayo, kunezinhlelo eziningana zokusebenza ezizofakazela ukuthi kuzokuvumela ukuba uqhathanise uhlu noma amatafula etafuleni ngesikhathi esifushane ngokusebenza okuncane. Ake sihlolisise lezi zinketho.

Bheka futhi: Ukuqhathaniswa kwamadokhumenti amabili ku-MS Word

Izindlela zokuqhathanisa

Kunezindlela ezimbalwa zokuqhathanisa izikhala ze-Excel, kodwa zonke zingahlukaniswa ngamaqembu amakhulu amathathu:

  • Ukuqhathaniswa kwezinhlu eziseshidi elifanayo;
  • Ukuqhathaniswa kwamatafula asetsheni ezahlukene;
  • Ukuqhathaniswa kwamatafula etafuleni kumafayela ahlukene.

    • Kungenxa yesigaba sokuthi, okokuqala, izindlela zokuqhathaniswa zikhethiwe, futhi izinyathelo ezithile kanye nezinhlelo zokusebenza zenziwa. Isibonelo, uma uqhathanisa ezincwadini ezahlukene, udinga ukuvula amafayela amabili e-Excel kanyekanye.

    Ngaphezu kwalokho, kufanele kuthiwa ukuqhathanisa izigcawu ezigciniwe kuyincazelo kuphela lapho kunesakhiwo esifanayo.

    Indlela 1: ifomula elula

    Indlela elula yokuqhathanisa idatha kumatafula amabili ukusebenzisa indlela elula yokulingana. Uma idatha ihambisana, bese inikeza inani le-TRUE, futhi uma kungenjalo, ke -FALSE. Kungenzeka ukuqhathanisa, kokubili idatha yamanani, nokubhala. Ukungahambi kwalendlela ukuthi kungasetshenziswa kuphela uma idatha etafuleni iyalwe noma ihlelwa ngendlela efanayo, ivumelanisiwe futhi inenani elilinganayo lemigqa. Ake sibone ukuthi singayisebenzisa kanjani le ndlela ngokusebenza esibonelweni samatafula amabili afakwe ekhasini elilodwa.

    Ngakho-ke, sinamatafula amabili alula nezinhlu zabasebenzi kanye namaholo abo. Kubalulekile ukuqhathanisa uhlu lwabasebenzi bese ubona ukungahambisani phakathi kwamakholomu lapho amagama abekwe khona.

    1. Kulokhu sidinga ikholomu eyengeziwe kushidi. Faka uphawu lapho "=". Bese uchofoza into yokuqala okumele ifaniswe ohlwini lokuqala. Futhi sibeka uphawu "=" kusuka ikhibhodi. Bese uchofoza esitokisini sokuqala sekholomu, esikuqhathanisa nayo, etafuleni lesibili. Le nkulumo ingehlobo olulandelayo:

      = A2 = D2

      Yize kunjalo, kuzo zonke izikhathi izixhumanisi zizohluka, kodwa okusemqoka kuzohlala okufanayo.

    2. Chofoza inkinobho Ngenaukuthola imiphumela yokuqhathanisa. Njengoba ungabona, uma uqhathanisa amaseli okuqala kokubili izinhlu, lolu hlelo lubonise inkomba "TRUE"okusho ukufana kwedatha.

    3. Manje kudingeka senze ukufana okufanayo namaseli asele kokubili amatafula emakholomu esiwaqhathanisa nawo. Kodwa ungakwazi ukukopisha ifomula, okuzogcina isikhathi esiningi. Lesi sici sibaluleke kakhulu uma siqhathanisa uhlu nenamba enkulu yemigqa.

      Inqubo yokukopisha ilula kakhulu ukusebenzisa isibambo sokugcwalisa. Sifaka isikhombisi ekhoneni elingaphansi lesokudla leseli, lapho sithole khona inkomba "TRUE". Ngesikhathi esifanayo, kufanele iguqulwe ku-cross cross. Lona uphawu lokugcwalisa. Chofoza inkinobho yegundane lesokunxele bese uhudulela isikhombisi phansi ngenani lemigqa emaqhathaneni etafula afaniswa.

    4. Njengoba sibona, manje kukholomu eyengeziwe yonke imiphumela yokuqhathaniswa kwedatha kumakholomu amabili we-array amathebula ayaboniswa. Esimweni sethu, idatha ayifani kuphela emgqeni owodwa. Uma kuqhathaniswa, ifomula yanikeza umphumela "FALSE". Kuzo zonke ezinye imigqa, njengoba ubona, ifomula lokufanisa linikeze inkomba "TRUE".

    5. Ngaphezu kwalokho, kungenzeka ukubala inani lokungafani ngokusebenzisa ifomula ekhethekile. Ukuze wenze lokhu, khetha isici seshidi, lapho sizoboniswa khona. Bese uchofoza isithonjana "Faka umsebenzi".

    6. Ewindini Amakhosi omsebenzi eqenjini labaqhubi "Isibalo" khetha igama SUMPRODUCT. Chofoza inkinobho "Kulungile".

    7. Iwindi lempikiswano yokusebenza ivuliwe. SUMPRODUCTumsebenzi wakhe oyinhloko ukubala inani lemikhiqizo yebanga elikhethiwe. Kodwa lo msebenzi ungasetshenziselwa izinhloso zethu. I-syntax yayo ilula kakhulu:

      = I-SUMPRODUCT (i-array1; i-array2; ...)

      Ngokuphelele, ungasebenzisa amakheli angafika ku-255 arrays njengama-arguments. Kodwa kithi sizosebenzisa izigaba ezimbili kuphela, ngaphandle kwalokho, njengengxabano eyodwa.

      Faka i-cursor ensimini "Massive1" bese ukhetha uhla lwemininingwane oluqhathaniswa endaweni yokuqala kushidi. Ngemva kwalokho sibeka uphawu emkhakheni. "akulingani" () bese ukhetha uhla oluqhathaniswa nesifunda sesibili. Okulandelayo, ukugoqa inkulumo ephumela kubakaki, ngaphambi kwalokho sibeka izinhlamvu ezimbili "-". Esimweni sethu, sithola inkulumo elandelayo:

      - (A2: A7D2: D7)

      Chofoza inkinobho "Kulungile".

    8. Umsebenzisi ubala futhi ubonisa umphumela. Njengoba sibona, umphumela wethu ulingana nenombolo "1", okungukuthi, kusho ukuthi ohlwini oluqhathaniswayo olulodwa olufakiwe olungatholakali. Uma uhlu lufana ngokuphelele, umphumela uzolingana nenombolo "0".

    Ngendlela efanayo, ungakwazi ukuqhathanisa idatha kumatafula atholakala kumashidi ahlukene. Kodwa kulokhu kuyinto efiselekayo ukuthi imigqa kuwo ibalwa. Yonke inqubo yokuqhathanisa cishe iyafana nechazwe ngenhla, ngaphandle kokuthi uma wenza ifomula, kufanele ushintshe phakathi kwamashidi. Esikhathini sethu, le nkulumo izoba nefomu elilandelayo:

    = B2 = Ishidi2! B2

    Lokhu kungukuthi, njengoba sibona, ngaphambi kokuthi izixhumanisi zedatha, ezitholakala kwamanye amashidi, ezahluke lapho umphumela wokuqhathaniswa uboniswa khona, inani leshidi kanye namagama okumemeza kuboniswa.

    Indlela 2: Khetha Amaqembu Amaseli

    Ukuqhathaniswa kungenziwa ngokusebenzisa ithuluzi lokukhetha iqembu leseli. Ngalo, ungaqhathanisa izinhlu ezivumelanisiwe futhi ezibekiwe. Ngaphezu kwalokho, kulokhu, uhlu kufanele lubekwe eduze komunye nomunye eshadini elifanayo.

    1. Khetha amathrekhi afaniswa. Iya kuthebhu "Ikhaya". Okulandelayo, chofoza isithonjana "Thola futhi uqokomise"okuyinto itholakala ku-tape ebhodini lamathuluzi Ukuhlela. Uhlu luvuleka lapho kufanele ukhethe isikhundla. "Ukukhetha iqembu lamaseli ...".

      Ngaphezu kwalokho, efasiteleni elithandayo lokukhethwa kweqembu lamaseli angatholakala ngenye indlela. Lolu khetho luzoba usizo ikakhulu kulabo abasebenzisi abafakile uhlelo lwehlelo ngaphambi kwe-Excel 2007, ngoba indlela ngokusebenzisa inkinobho "Thola futhi uqokomise" Lezi zicelo azisekeli. Khetha imidwebo esifuna ukuyilinganisa, bese ucindezela ukhiye F5.

    2. Iwindwangu elincane lokushintsha livuliwe. Chofoza inkinobho "Qinisekisa ..." ekhoneni layo elingakwesokunxele.

    3. Emva kwalokho, noma yikuphi kokubili okukhethwa kukho ngenhla oyikhethayo, iwindi lokukhetha amaqembu wamaseli liqalisiwe. Setha inkinobho ukuma "Khetha ngomugqa". Chofoza inkinobho "Kulungile".

    4. Njengoba ubona, ngemuva kwalokhu, izindinganiso ezingalinganisani zemigqa zizogqanyiswa nge-hue ehlukile. Ngaphezu kwalokho, njengoba kungasolwa ngokuqukethwe komugqa wefomula, lolu hlelo luzokwenza elinye lamaseli asebenze emigqeni engachaziwe.

    Indlela 3: Ukufometha okunemibandela

    Ungenza ukuqhathanisa usebenzisa indlela yokufometha enemibandela. Njengendlela yangaphambilini, izindawo eziqhathaniswayo kufanele zibe sekhasi elifanayo le-Excel futhi zivumelaniswe nomunye nomunye.

    1. Okokuqala, sikhetha ukuthi yiyiphi indawo yokubeka ucingo esizoyibheka ngayo eyinhloko futhi okufanele sibheke umehluko. Okokugcina sizokwenza etafuleni lesibili. Ngakho-ke, khetha uhlu lwabasebenzi abakhona kulo. Ukuhambisa kuthebhu "Ikhaya", chofoza inkinobho "Ukufometha okunemibandela"okuyinto itholakala ku-tape ku-block "Izitayela". Kusuka kuhlu lokudonsa phansi, qhubeka "Ukuphathwa Kwemithetho".

    2. Iwindi yenkampani yokulawula ivuliwe. Sifaka kuso kukho inkinobho "Dala umthetho".

    3. Ewindini lokuqaliswa, yenza ukukhetha kwesimo "Sebenzisa ifomula". Ensimini "Fometha amaseli" bhala ifomu eliqukethe amakheli amangqamuzana okuqala emigqeni yamakholomu aqhathaniswayo, ahlukaniswe uphawu "olungalingani" (). Kuphela le nkulumo izoba nesibonakaliso manje. "=". Ngaphezu kwalokho, ukubhekana ngokuphelele kufanele kusetshenziswe kuzo zonke izixhumanisi zekholomu kule fomula. Ukuze wenze lokhu, khetha ifomula ngesikhombisi bese uchofoza izikhathi ezintathu kusihluthulelo F4. Njengoba ungabona, isibonakaliso se-dollar sivele eduze nawo wonke amakheli ekholomu, okusho ukuguqula izixhumanisi zibe yizingqayizivele. Ngokwesimo sethu esithile, ifomula izothatha leli fomu elilandelayo:

      = $ A2 $ D2

      Sibhala le nkulumo kule nsimu engenhla. Emva kwalokho chofoza inkinobho "Fometha ...".

    4. Iwindi elisebenzayo "Fometha amaseli". Iya kuthebhu "Gcwalisa". Lapha kuhlu lwemilayezo simisa ukukhetha embala lapho sifuna ukubala khona lezo zakhi lapho idatha ingahambisani khona. Sicindezela inkinobho "Kulungile".

    5. Ukubuyela efasiteleni ngokudala umthetho wokufometha, chofoza inkinobho. "Kulungile".

    6. Ngemva kokuhamba ngokuzenzakalelayo ewindini Umphathi weMithetho chofoza inkinobho "Kulungile" futhi kulo.

    7. Manje etafuleni lesibili, izakhi ezinesidingo ezingahambisani namanani ahambelana nendawo yokuqala yetafula zizogqanyiswa kumbala okhethiwe.

    Kukhona enye indlela yokusebenzisa ukufometha okunemibandela ukuze ufeze umsebenzi. Njengezinketho zangaphambilini, kudinga indawo kokubili izindawo eziqhathaniswa eshidi elifanayo, kodwa ngokungafani nezindlela ezichazwe ngaphambili, isimo sokuvumelanisa noma ukuhlunga idatha ngeke kudingekile, okuhlukanisa le nketho kusuka kulabo abachazwe ngaphambilini.

    1. Yenza izindawo ezikhethiwe okufanele ziqhathaniswe.

    2. Yenza ushintsho kuthebhu ebizwa ngokuthi "Ikhaya". Chofoza inkinobho. "Ukufometha okunemibandela". Kuluhlu olusebenziwe, khetha isikhundla "Imithetho yokukhethwa kweseli". Emenyu elandelayo senza ukukhetha kwesimo. "Amanani aphindaphinda".

    3. Iwindi lokubeka ukukhethwa kwamanani aphindaphindiwe liqalisiwe. Uma wenza konke ngokufanele, ke kule window iwushiya kuphela ukuchofoza inkinobho. "Kulungile". Noma, uma ufisa, ungakhetha umbala ohlukile wokukhetha ensimini ehambelana nale festile.

    4. Ngemuva kokuthi senze isenzo esicacisiwe, zonke izakhi eziphindaphindiwe zizogqanyiswa kumbala okhethiwe. Lezo zakhi ezingavumelani zizohlala zinemibala embala wazo wangempela (ezimhlophe ngokuzenzakalelayo). Ngakho-ke, ungakwazi ukubona ngokushesha ukuthi yikuphi umehluko phakathi kwama-arrays.

    Uma ufisa, ungakwazi, ngokuphambene nalokho, upende izakhi ezingafani, futhi lezo zinkomba ezifanelanayo zingashiywa ngombala ofanayo. Kulesi simo, i-algorithm yezenzo cishe iyafana, kepha efasiteleni lesethingi lokugqamisa amanani okuphindaphindiwe ensimini yokuqala esikhundleni sepharamitha "Phinda" khetha ukhetho "Okuhlukile". Emva kwalokho, chofoza inkinobho "Kulungile".

    Ngakho-ke, kuzoqokonyiswa lezo zinkomba ezingafani.

    Isifundo: Ukufometha okunemibandela ku-Excel

    Indlela 4: ifomula eyinkimbinkimbi

    Ungaphinda uqhathanise idatha usebenzisa ifomula eyinkimbinkimbi, esekelwe emsebenzini COUNTES. Ukusebenzisa leli thuluzi, ungabala ukuthi yingxenye ngayinye ekholomu ekhethiwe ephinda lesibili iphinda iphinda kuqala.

    I-Operator COUNTES ibhekisela eqenjini lezibalo lemisebenzi. Umsebenzi wakhe ukubala inani lamaseli anamagugu anelisa isimo esinikeziwe. I-syntax yalolu opharetha kanje:

    = COUNTERS (ibanga; umgogodla)

    Ukuphikisana "Range" ikheli le-array lapho kubalwa khona amanani afanayo.

    Ukuphikisana "Criterion" ubeka isimo somdlalo. Esikhathini sethu, kuyoba izixhumanisi zamaseli athile e-tablespace yokuqala.

    1. Khetha isici sokuqala sekholomu eyengeziwe lapho inani lemidlalo lizobalwa khona. Okulandelayo, chofoza isithonjana "Faka umsebenzi".

    2. Qalisa kwenzeka Amakhosi omsebenzi. Iya kusigaba "Isitatimende". Thola ohlwini igama "COUNTES". Ngemva kokukhetha, chofoza inkinobho. "Kulungile".

    3. Ifasitelana lokuphikisana lomqhubi liqalisiwe. COUNTES. Njengoba ungabona, amagama emasimu kuleli festile afana namagama ezimpikiswano.

      Setha isikhombisi emkhakheni "Range". Ngemuva kwalokho, ubambe inkinobho yegundane lesokunxele, khetha wonke amanani ekholomu ngamagama wetafula lesibili. Njengoba ubona, izixhumanisi ngokushesha ziwela ensimini ecacisiwe. Kodwa ngezinhloso zethu, leli kheli kufanele lenziwe ngokuphelele. Ukuze wenze lokhu, khetha izixhumanisi endle bese uchofoza ukhiye F4.

      Njengoba ubona, isixhumanisi sithathile ifomu eliphelele, elibhekwa ngokuba khona kwezimpawu ze dollar.

      Bese uye ensimini "Criterion"ngokubeka isikhombisi lapho. Sichofoza esithombeni sokuqala ngamagama wokugcina ebangeni lokuqala lamathebulethi. Kulesi simo, shiya isixhumanisi esihlobene. Ngemva kokuba iboniswe ensimini, ungachofoza inkinobho "Kulungile".

    4. Umphumela uboniswa kusiqephu seshidi. Ilingana nenombolo "1". Lokhu kusho ukuthi ohlwini lwamagama etafuleni lesibili igama lokugcina "Grinev V.P."okuyinto yokuqala ohlwini lwetafula lokuqala, kwenzeka kanyekanye.

    5. Manje sidinga ukwakha inkulumo efanayo kuzo zonke ezinye izakhi zetafula lokuqala. Ukwenza lokhu, ukukopisha ngokusebenzisa uphawu lokugcwalisa, njengoba senze ngaphambili. Beka isikhombisi engxenyeni engezansi kwesici seshidi eliqukethe umsebenzi COUNTES, futhi ngemva kokuyiguqula kumaka wokugcwalisa, ubambe inkinobho yegundane lesokunxele bese uhudulela isikhombisi phansi.

    6. Njengoba ubona, uhlelo lwenze isibalo semifino ngokuqhathanisa iseli ngalinye letafula lokuqala nedatha ekhoneni lesithebula lesibili. Ezimweni ezine, umphumela waphuma "1", futhi ezimweni ezimbili - "0". Okusho ukuthi, uhlelo alukwazanga ukuthola etafuleni lesibili izindinganiso ezimbili ezisezingeni lokuqala letafula.

    Yiqiniso, le nkulumo ukuze uqhathanise izinkomba zetafula, ingasetshenziswa efomini ekhona, kodwa kunethuba lokuyithuthukisa.

    Masenze ukuze lezo zindinganiso ezitholakala etafuleni lesibili, kodwa zingekho eyokuqala, ziboniswa ohlwini oluhlukile.

    1. Okokuqala, ake sivuselele kabusha indlela yethu COUNTES, okungukuthi kube yinye yezingxabano zomqhubi IF. Ukuze wenze lokhu, khetha iseli lokuqala lapho opharetha atholakala khona COUNTES. Ku-bar yefomula ngaphambi kokuthi sengeze inkulumo "UMA" ngaphandle izingcaphuno bese uvula ibhakha. Okulandelayo, ukwenza kube lula ngathi ukuthi sisebenze, sikhetha inani kubha yefomula. "UMA" bese uchofoza isithonjana "Faka umsebenzi".

    2. Iwindi lempikiswano yokusebenza ivula. IF. Njengoba ubona, insimu yokuqala yewindi isivele igcwele inani lomqhubi. COUNTES. Kodwa sidinga ukwengeza okunye kulokhu. Sabeka isikhombisi lapho futhi sengeze esenzakalweni esivele sikhona "=0" ngaphandle izingcaphuno.

      Emva kwalokho iya ensimini "Vumela uma kuyiqiniso". Lapha sizosebenzisa omunye umsebenzi osikiwe - LINE. Faka igama "LINE" ngaphandle kwamacaphuno, bese uvula ama-parentheses bese ucacisa izixhumanisi zeseli lokuqala negama lokugcina etafuleni lesibili, bese uvala abazali. Ngokuqondile, esimweni sethu ensimini "Vumela uma kuyiqiniso" uthole inkulumo elandelayo:

      LINE (D2)

      Manje opharetha LINE uzobika imisebenzi IF inombolo yocingo lapho igama eliseceleni elitholakala khona, futhi uma kwenzeka isimo esichazwe ensimini yokuqala sigcwaliseka, umsebenzi IF izokhipha le nombolo esitokisini. Sicindezela inkinobho "Kulungile".

    3. Njengoba ungabona, umphumela wokuqala uboniswa njenge "FALSE". Lokhu kusho ukuthi inani alikwanelisi izimo zomqhubi. IF. Okusho ukuthi, isibongo sokuqala sikhona kokubili izinhlu.

    4. Ukusebenzisa uphawu lokugcwalisa, ngendlela evamile yokukopisha inkulumo yomqhubi IF kukholomu lonke. Njengoba ungabona, izikhundla ezimbili ezikhona etafuleni lesibili, kodwa hhayi kokuqala, ifomula inikeza izinamba zomugqa.

    5. Phinda uphume kusuka ku-tablespace kuya kwesokudla bese ugcwalisa ikholomu enezinombolo ngokulandelana, uqala kusuka 1. Inombolo yezinombolo kumele ihambisane nenombolo yemigqa etafuleni elaliqhathaniswa yesibili. Ukusheshisa inqubo yokubala, ungasebenzisa futhi uphawu lokugcwalisa.

    6. Ngemva kwalokho, khetha iseli lokuqala ngakwesokudla kwekholomu ngezinombolo bese uchofoze kwisithonjana "Faka umsebenzi".

    7. Ivula Umsebenzi weWebhu. Iya kusigaba "Isitatimende" bese ukhetha amagama "IGAMA". Chofoza inkinobho "Kulungile".

    8. Umsebenzi I-LEAST, iwindi lezingxoxo ezivuliwe, lenzelwe ukubonisa inani eliphansi elichazwe i-akhawunti.

      Ensimini "Uhlu" ucacise izixhumanisi zobubanzi bekholomu eyengeziwe "Inani lomdlalo"okuyinto esasiphendulela ngaphambili esebenzisa lo msebenzi IF. Senza zonke izixhumanisi ngokuphelele.

      Ensimini "K" bonisa ukuthi inani eliphansi kakhulu kufanele liboniswe kanjani. Lapha sibonisa izixhumanisi zeselula yokuqala yekholomu ngokufaka izinombolo, esizifake kamuva. Ikheli lishiye isihlobo. Chofoza inkinobho "Kulungile".

    9. Opharetha ubonisa umphumela - inombolo 3. Lokhu kubalwa okuncane kakhulu kwemigqa engafani kahle yamathebula wethebula. Ukusebenzisa uphawu lokugcwalisa, kopisha ifomula phansi.

    10. Manje, uma sazi izinamba zomugqa wezinto ezingalingani, singafaka esitokisini namagugu abo besebenzisa umsebenzi INDEX. Khetha isici sokuqala seshidi eliqukethe ifomula I-LEAST. Ngemuva kwalokho iya emgqeni wefomula futhi ngaphambi kwegama "IGAMA" faka igama INDEX ngaphandle izingcaphuno, vula ngokushesha isikhwama bese ufaka i-semicolon (;). Bese ukhetha igama kubha yefomula. INDEX bese uchofoza isithonjana "Faka umsebenzi".

    11. Emva kwalokho, ifasitela elincane livuleka lapho kudingeka khona ukuthi unqume ukuthi ngabe ireferensi kufanele ibe nomsebenzi INDEX noma eklanyelwe ukusebenza nge-arrays. Sidinga ukhetho lwesibili. Isethelwe ngokuzenzakalelayo, ngakho kule window ulanda nje inkinobho. "Kulungile".

    12. Iwindi lempikiswano yokusebenza iqala. INDEX. Lesi sitatimende senzelwe ukubonisa inani elitholakala ohlwini oluthile kumugqa ocacisiwe.

      Njengoba ungabona, insimu "Inombolo yomugqa" kakade igcwele amanani omsebenzi I-LEAST. Kusukela kubaluleka kakade ekhona, khipha umehluko phakathi kokubalwa kwekhasi le-Excel nokubalwa kwangaphakathi kwendawo yetafula. Njengoba ungabona, ngaphezu kwamanani wetafula sine-cap kuphela. Lokhu kusho ukuthi umehluko uyodwa umugqa. Ngakho-ke siyengeza ensimini "Inombolo yomugqa" kusho "-1" ngaphandle izingcaphuno.

      Ensimini "Uhlu" ucacise ikheli lezinhlobo zamagugu etafuleni lesibili. Ngesikhathi esifanayo, senza zonke izixhumanisi ngokuphelele, okungukuthi, sibeka isibonakaliso se-dollar phambi kwazo ngendlela esichazwe ngaphambilini.

      Sicindezela inkinobho "Kulungile".

    13. Ngemva kokukhipha umphumela esibukweni, sithumela umsebenzi usebenzisa uphawu lokugcwalisa ekugcineni kwekholomu phansi. Njengoba ubona, amagama womabili akhona etafuleni lesibili, kodwa hhayi kokuqala, aboniswa ebangeni elihlukile.

    Indlela yesi-5: Ukuqhathanisa izigaba ezincwadini ezahlukene

    Uma uqhathanisa ububanzi bezincwadi ezihlukene, ungasebenzisa izindlela ezibalwe ngenhla, ngaphandle kwalezo zindlela ezidinga ukubekwa kokubili kokupaka kwelinye ishidi. Isimo esikhulu sokwenza inqubo yokuqhathanisa kulokhu kuvulwa amafasitela womabili amafayela ngesikhathi esifanayo. Azikho izinkinga zezinguqulo ze-Excel 2013 nakamuva, kanye nezinguqulo ngaphambi kwe-Excel 2007. Kodwa ku-Excel 2007 naku-Excel 2010, ukuze uvule kokubili amawindi ngesikhathi esifanayo, kudingeka ukuthi kwenziwe amanye ama-manipulations engeziwe. Indlela yokwenza lokhu ichazwe kusifundo esihlukile.

    Isifundo: Indlela yokuvula i-Excel kumawindi ahlukene

    Njengoba ubona, kunamathuba amaningi okuqhathanisa amatafula omunye nomunye. Yikuphi ukhetho okumele ulisebenzise kuncike ngqo lapho idatha ye-tabular itholakala komunye nomunye (kwelinye ishidi, ezincwadini ezahlukene, kumashidi ahlukene), nokuthi nokuthi umsebenzisi ufuna ukuthi lokhu kuqhathaniswa kuboniswe kanjani esibukweni.

    Okuthunyelwe Popular

    https://termotools.com zu.termotools.com © I-Excel 2024