Eminye imibhalo ye-Microsoft Excel, enezinombolo eziningi, ngokuvamile kudingeka ukuba uthole idatha ethile, igama lezintambo, njalo njalo. Kuyinto engathandeki kakhulu uma kufanele ubheke inani elikhulu lemigqa ukuthola igama elifanele noma inkulumo. Londoloza isikhathi nesisindo kuzosiza usesho olwakhiwe ngaphakathi kwe-Microsoft Excel. Ake sibone ukuthi isebenza kanjani, nokuthi ungayisebenzisa kanjani.
Umsebenzi wokusesha ku-Excel
Umsebenzi wokusesha ku-Microsoft Excel unikeza ithuba lokuthola umbhalo oyifunayo noma izinombolo zezinombolo ngokusebenzisa iwindi lokuthola nokufaka esikhundleni. Ngaphezu kwalokho, isicelo sinokukhethwa kokubuyiswa kwedatha okuphambili.
Indlela 1: Ukusesha Okulula
Ukusesha okulula kwedatha ku-Excel kukuvumela ukuba uthole wonke amaseli aqukethe isethi yabalingiswa efakwe efasiteleni lokusesha (izinhlamvu, izinombolo, amagama, njll) icala elingenakuzwa.
- Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho "Thola futhi uqokomise"okuyinto itholakala ku-tape ebhodini lamathuluzi Ukuhlela. Emenyu evelayo, khetha into "Thola ...". Esikhundleni salezi zenzo, ungakwazi ukumane uthayiphe isinqamuleli sekhibhodi Ctrl + F.
- Ngemuva kokuthi udlulise izinto ezifanele kwi-tape, noma ucindezele inhlanganisela ye "okhiye abashisayo", iwindi lizovuleka. "Thola futhi ushintshe" kuthebhu "Thola". Sidinga. Ensimini "Thola" faka igama, izinhlamvu, noma izinkulumo ezizocwaninga. Sicindezela inkinobho "Thola okulandelayo"noma inkinobho "Thola konke".
- Uma ucindezela inkinobho "Thola okulandelayo" sithuthela esitokisini sokuqala lapho amaqembu angenisiwe abalingiswa abhalwe khona. Iseli ngokwayo iqala ukusebenza.
Ukusesha nokukhishwa kwemiphumela kwenziwa umugqa ngomugqa. Okokuqala, wonke amaseli emgqeni wokuqala asetshenzwa. Uma idatha ehlangabezana nesimo ayitholakalanga, uhlelo luqala ukucwaninga emgqeni wesibili, njalonjalo, ize ithole umphumela owanelisayo.
Izinhlamvu zokusesha akudingeki zibe yizinto ezihlukile. Ngakho-ke, uma inkulumo ethi "amalungelo" ichazwa njengesicelo, lokho okukhiphayo kuzobonisa wonke amaseli aqukethe isethi yokulinganisa yezinhlamvu ngisho nangaphakathi kwegama. Isibonelo, igama elithi "Kwesokudla" lizobhekwa lifanele kuleli cala. Uma ucacisa idijithi "1" enjini yokusesha, impendulo izoqukatha amaseli aqukethe, isibonelo, inombolo "516".
Ukuya kumphumela olandelayo, chofoza inkinobho futhi. "Thola okulandelayo".
Ungaqhubeka ngale ndlela kuze kube ukuboniswa kwemiphumela kuqala embuthanweni omusha.
- Uma ekuqaleni kwenqubo yokusesha uchofoza inkinobho "Thola konke", yonke imiphumela yenkinga izonikezwa ohlwini ngaphansi kwewindi lokusesha. Lolu hlu luqukethe ulwazi mayelana nokuqukethwe kwamaseli ngedatha eyanelisa umbuzo wosesho, ikheli lendawo yabo, kanye neshidi kanye nencwadi abayilandelayo. Ukuze uhambe kunoma yimiphi imiphumela yenkinga, mane uchofoze kuso ngenkinobho yegundane lesokunxele. Ngemuva kwalokho, isikhombisi sizoya esitokisini se-Excel, kumrekhodi womsebenzisi okwenzile ukuchofoza.
Indlela 2: Sesha ngebanga elithile lamaseli
Uma unetafula elikhulu kakhulu, khona-ke kulokhu akusiyo ngaso sonke isikhathi ukucinga lonke uhlu, ngoba imiphumela yosesho ingaba inani elikhulu lemiphumela engadingeki esimweni esithile. Kukhona indlela yokunciphisa isikhala sokusesha kuluhlu oluthile lwamaseli.
- Khetha indawo yamaseli lapho sifuna ukusesha khona.
- Siyiphayipha inhlanganisela yekhibhodi ekhibhodi Ctrl + F, emva kwalokho iwindi elijwayelekile liqala "Thola futhi ushintshe". Izenzo ezengeziwe zifana ncamashi nendlela eledlule. Umehluko kuphela ukuthi ukucinga kuyenziwa kuphela ebangeni elibekiwe lamaseli.
Indlela 3: Ukusesha Okuthuthukisiwe
Njengoba kushiwo ngenhla, ekusesheni okujwayelekile, wonke amaseli aqukethe isethi elandelanayo yabalingiswa bokusesha kunoma yiluphi uhlobo ayilona olubucayi.
Ngaphezu kwalokho, okukhiphayo akukwazi ukuthola kuphela okuqukethwe kweseli elithile, kodwa futhi nekheli lezinto ezisetshenziswe kulo. Isibonelo, i-cell E2 iqukethe ifomula, okungukuthi isamba samaseli A4 no-C3. Le mali ingu-10, futhi yile namba eboniswa kuseli le-E2. Kodwa, uma sibeka idijithi yokusesha "4", khona-ke phakathi kwemiphumela yenkinga kuzoba yi-cell E2 efanayo. Lokhu kungenzeka kanjani? Ngaphakathi kweseli E2, ifomula iqukethe ikheli eliselikhini le-A4, elifaka nje inombolo edingekayo 4.
Kodwa, ukuthi ungayinqamula kanjani leyo neminye imiphumela engavumelekile yemiphumela yosesho? Kule njongo, kune-Advanced Excel yokusesha.
- Ngemuva kokuvula iwindi "Thola futhi ushintshe" noma iyiphi indlela echazwe ngenhla, chofoza inkinobho "Izinketho".
- Amathuluzi amaningana wokuphatha ukusesha avela efasiteleni. Ngokuzenzakalelayo, wonke lawa mathuluzi asezingeni elifanayo njengokuseshwa okujwayelekile, kodwa ungenza izinguquko uma kunesidingo.
Ngokuzenzakalelayo, imisebenzi "Icala elibucayi" futhi "Wonke amaseli" zikhutshaziwe, kodwa uma sikhathaza amabhokisi okuhlola ahambisanayo, ngakho-ke kulokhu, irejista efakiwe kanye nomdlalo oqondile uzocatshangelwa uma kudala umphumela. Uma ufaka igama ngencwadi encane, khona-ke emiphumeleni yosesho, amaseli aqukethe isipelingi saleli gama ngenhlamvu enkulu, njengoba kungenziwa ngokuzenzakalelayo, ngeke aphinde awe. Ngaphezu kwalokho, uma isici sinikwe amandla "Wonke amaseli", khona-ke izakhi kuphela eziqukethe igama eliqondile zizofakwa kwenkinga. Isibonelo, uma ucacisa umbuzo wosesho "Nikolaev", amaseli aqukethe umbhalo othi "Nikolaev A.D." angeke afakwe kulo mkhiqizo.
Ngokuzenzakalelayo, ukusesha kwenziwa kuphela kwi-Excel sheet esebenzayo. Kodwa, uma ipharamitha "Sesha" uzodlulisela esimweni "Encwadini", ukusesha kuzokwenziwa kuwo wonke amafayili efayela evulekile.
Kupharamitha "Buka" Ungashintsha isiqondiso sosesho. Ngokuzenzakalelayo, njengoba kushiwo ngenhla, ukusesha kwenziwa eyodwa emva komunye umugqa ngomugqa. Ngokuhambisa umshini ukuma "Ngamakholomu", ungabeka umyalelo wokubunjwa kwemiphumela yokukhishwa, ngokuqala ngekholomu yokuqala.
Esigrafu "Usesho lokusesha" kunqunywe ukuthi yiziphi izakhi ezithile ezenzelwe ukusesha. Ngokuzenzakalelayo, lawa mafomula, okungukuthi, idatha ekhonjiswa uma uchofoza esitokisini kwibha yefomula. Lokhu kungaba igama, inombolo, noma ireferensi yeseli. Ngesikhathi esifanayo, uhlelo, ukwenza usesho, lubona kuphela isixhumanisi, hhayi umphumela. Lo mphumela uxoxwe ngenhla. Ukuze uphendule impela imiphumela, ngokusho kwedatha ekhonjisiwe esitokisini, hhayi kubha yefomula, udinga ukuhlela kabusha ushintsho kusuka esikhundleni "Amafomula" esimweni "Amanani". Ngaphezu kwalokho, kukhona ikhono lokufuna amanothi. Kulokhu, lo mshini uhlelwa kabusha esimweni "Amanothi".
Ukucinga okucacile nakakhulu kungasethiwe ngokuchofoza inkinobho. "Fometha".
Lokhu kuvulwa iwindi lesakhiwo leseli. Lapha ungakwazi ukusetha ifomethi yamaseli azohlanganyela ekusesheni. Ungabeka imikhawulo ekufomeni kwenombolo, ukuvumelanisa, ifonti, umngcele, ukugcwalisa nokuvikela, enye yalezi zimingcele, noma ukuhlanganisa ndawonye.
Uma ufuna ukusebenzisa ifomethi yeseli ethile, bese phansi phansi kwewindi, chofoza inkinobho "Sebenzisa ifomethi yale seli ...".
Ngemva kwalokho, ithuluzi livela ngendlela ye-pipette. Ukusebenzisa, ungakhetha iseli ozosebenzisa ifomethi.
Ngemuva kokuthi ifomethi yokusesha imisiwe, chofoza inkinobho "Kulungile".
Kunezimo lapho kubalulekile ukucinga hhayi ibinzana elithile, kodwa ukuthola amaseli aqukethe amagama okusesha kunoma iyiphi i-oda, ngisho noma ahlukaniswa ngamanye amagama kanye nezimpawu. Khona-ke lawa magama adinga ukuhlukaniswa kuzo zombili ngesibonakaliso "*". Manje imiphumela yokusesha izobonisa wonke amaseli lapho lawa magama atholakala kunoma iyiphi i-oda.
- Uma izilungiselelo zokusesha sezibekiwe, chofoza inkinobho. "Thola konke" noma "Thola okulandelayo"ukuya emiphumeleni yokusesha.
Njengoba ubona, i-Excel iyinto elula, kodwa ngesikhathi esifanayo isethi esebenzayo yamathuluzi okucinga. Ukuze ukhiqize i-squeak elula, vele ucele iwindi lokusesha, faka umbuzo kulo, bese ucindezela inkinobho. Kodwa ngesikhathi esifanayo, kungenzeka ukwenza ngokwezifiso usesho ngabanye ngenani elikhulu lemingcele ehlukene nezilungiselelo eziphambili.
