Kumadokhumenti e-Microsoft Excel, aqukethe inani elikhulu lezinkambu, kuvame ukudingeka ukuthola idatha ethile, igama lomugqa, njll. Kuyaphazamisa kakhulu lapho kufanele ubheke inombolo enkulu yemigqa ukuthola igama noma isisho esifanele. Ukusesha okwakhelwe ngaphakathi kuMicrosoft Excel kusiza ukonga isikhathi nezinzwa. Ake sibheke ukuthi isebenza kanjani nokuthi uyisebenzisa kanjani.
Umsebenzi wokucinga ku-Excel
Umsebenzi wokusesha ku-Microsoft Excel unikeza amandla okuthola umbhalo owuthandayo noma amanani ezinombolo ngewindi lokuthola nokuLayisha esikhundleni. Ngaphezu kwalokho, uhlelo lokusebenza linamandla okucinga okuthuthukile kwedatha.
Indlela yoku-1: Ukusesha Okulula
Ukusesha idatha okulula ku-Excel kukuvumela ukuthi uthole wonke amaseli aqukethe iqoqo lomlingiswa (izinhlamvu, izinombolo, amagama, njll.) Afakwe ebhokisini lokucinga, hhayi icala elibucayi.
- Ukuba kuthebhu "Ikhaya"chofoza inkinobho Thola nokugqamisaetholakala kubambo kubhokisi lamathuluzi "Ukuhlela". Kumenyu evelayo, khetha "Thola ...". Esikhundleni salezi zenzo, ungamane uthayiphe isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + F.
- Ngemuva kokuthi uchofoze izinto ezifanele kuribhoni, noma ucindezele inhlanganisela ye-hotkey, kuzovuleka iwindi Thola bese Ufaka esikhundleni kuthebhu Thola. Siyayidinga. Ensimini Thola faka igama, izinhlamvu, noma izinkulumo esizofuna ngazo. Chofoza inkinobho "Thola ngokulandelayo", noma inkinobho Thola Konke.
- Ngokucindezela inkinobho "Thola ngokulandelayo" sidlulela kwiseli yokuqala, equkethe amaqembu ezinhlamvu afakiwe. Iseli ngokwayo iyasebenza.
Ukucinga nokulethwa kwemiphumela kwenziwa umugqa ngomugqa. Okokuqala, wonke amaseli womugqa wokuqala ayacutshungulwa. Uma kungekho datha ohambelana nesimo atholakele, uhlelo luqala ukusesha kulayini wesibili, njalonjalo, kuze kube yilapho uthola umphumela ogculisayo.
Izinhlamvu zokucinga akudingeki ukuthi zibe izinto ezihlukile. Ngakho-ke, uma igama elithi "amalungelo" licacisiwe njengombuzo, khona-ke wonke amaseli aqukethe lokhu kulandelana kwezinhlamvu ngisho nangaphakathi kwegama azokhonjiswa. Isibonelo, kulokhu, igama elithi "Right" lizocatshangelwa njengombuzo ofanele. Uma ucacisa inombolo "1" enjini yokucinga, impendulo izofaka amaseli aqukethe, ngokwesibonelo, inombolo "516".
Ukuya kumphumela olandelayo, cindezela inkinobho futhi "Thola ngokulandelayo".
Lokhu kungaqhubeka kuze kuboniswe imiphumela iqala embuthanweni omusha.
- Uma kwenzeka, lapho uqala inqubo yokusesha, uchofoza inkinobho Thola Konke, yonke imiphumela izokwethulwa ngendlela yohlu olungezansi kwefasitela lokusesha. Lolu hlu luqukethe imininingwane ephathelene nokuqukethwe amaseli ngemininingwane eyenelisa umbuzo wokusesha, ikheli lendawo yabo liyakhonjiswa, kanye nephepha nebhuku abahlobana kulo. Ukuze uye kunoma yimiphi imiphumela, vele uchofoze kuyo ngenkinobho yegundane yangakwesobunxele. Ngemuva kwalokho, ikhesa izoya kuseli le-Excel umsebenzisi alichofoze kulo.
Indlela 2: sesha isikhawu sokuchazwa kweseli
Uma unetafula elikhulu ngokulingene, khona-ke kuleli cala akuhlale kulula ukusesha lonke iphepha, ngoba emiphumeleni yokucinga kungenzeka kube nenamba enkulu yemiphumela engadingeki ecaleni elithile. Kukhona indlela yokukhawulela indawo yokucinga kuphela ebangeni elithile lamaseli.
- Khetha indawo yamaseli esifuna ukusesha kuwo.
- Ukuthayipha isinqamuleli sekhibhodi I-Ctrl + F, ngemuva kwalokho iwindi elijwayelekile lizoqala Thola bese Ufaka esikhundleni. Izenzo ezengeziwe ziyafana ncamashi nendlela yangaphambilini. Umehluko kuphela ozoba ukuthi ukusesha kwenziwa kuphela ngokwesikhathi seseli esichaziwe.
Indlela 3: Ukucinga Okuthuthukile
Njengoba kushiwo ngenhla, kusesho olujwayelekile, wonke amaseli aqukethe iqoqo elilandelanayo lezinhlamvu zokucinga nganoma uluphi uhlobo, kungakhathalekile, afakiwe emiphumeleni yokucinga.
Ngaphezu kwalokho, hhayi okuqukethwe kweseli ethile kuphela, kepha futhi ikheli lezinto ekubhekiswa kulo lingena ekuphumeni. Isibonelo, iseli E2 iqukethe ifomula eyisamba samaseli u-A4 no-C3. Le mali ingu-10, futhi yile nombolo ekhonjiswa kuseli E2. Kepha, uma sicela ku-search inombolo "4", khona-ke phakathi kwemiphumela yocwaningo kuzoba yiseli E2 efanayo. Kungenzeka kanjani lokhu? Yikho nje lelo seli E2 liqukethe ikheli leseli A4 njengefomula, okufaka nje inombolo engu-4 oyifunayo.
Kepha, ungakunquma kanjani okunjalo, neminye imiphumela ecacile engamukeleki? Ngalezi zinhloso, kukhona ukusesha okuthuthukile kwe-Excel.
- Ngemuva kokuvula iwindi Thola bese Ufaka esikhundleni nganoma iyiphi indlela engenhla, chofoza inkinobho "Izinketho".
- Inani lamathuluzi wokuphenya okungeziwe angeziwe avela ewindini. Ngokuzenzakalelayo, wonke la mathuluzi asesimweni esifana nokusesha okujwayelekile, kepha ungenza ushintsho uma kunesidingo.
Ngokuzenzakalelayo, imisebenzi Icala liyazwela futhi Amaseli Ephelele zikhubazekile, kepha uma sibheka amabhokisi aseceleni kwezinto ezihambelana nawo, khona-ke kuleli cala, lapho sikhiqiza umphumela, irejista efakiwe kanye nomdlalo oqondile kuzonakwa. Uma ufaka igama ngezinhlamvu ezincane, bese kuba yimiphumela yokucingwayo, amaseli aqukethe ukupela kwaleli gama ngehlamvu elikhulukazi, njengoba kungaba njalo, ngeke esawa. Ngaphezu kwalokho, uma umsebenzi unikwe amandla Amaseli Ephelele, khona-ke kuphela izinto eziqukethe igama eliqondile ezizongezwa kulolu daba. Isibonelo, uma ucacisa umbuzo wokusesha "Nikolaev", khona-ke amaseli aqukethe umbhalo "Nikolaev A. D." ngeke anezelwe emiphumeleni yokucinga.
Ngokuzenzakalelayo, ukusesha kwenziwa kuphela ekhasini elisebenzayo le-Excel. Kepha, uma ipharamitha "Sesha" uzohumusha esikhundleni "Encwadini", khona-ke ukusesha kuzokwenziwa kuwo wonke amashidi efayela elivulekile.
Ipharamitha Buka Ungashintsha indlela eya kusesho. Ngokuzenzakalelayo, njengoba kushiwo ngenhla, usesho lwenziwa ngokulandelana ngomugqa. Ngokuhambisa switch uye esikhundleni Ikholomu ngekholamu, ungacacisa i-oda lesizukulwane semiphumela yenkinga, kusukela kukholamu yokuqala.
Igrafu Indawo yokusesha kunqunywa phakathi kokuthi izakhi ezithile zosesho zenziwa kuphi. Ngokuzenzakalelayo, lawa amafomula, okungukuthi, leyo mininingwane yokuthi uma uqhafaza kuseli kukhonjiswa kubha yefomula. Lokhu kungaba igama, inombolo, noma ireferensi yeseli. Ngasikhathi sinye, uhlelo, lusesha, lubona kuphela isixhumanisi, hhayi umphumela. Lo mphumela kuxoxwe ngawo ngenhla. Ukuze useshe ngemiphumela, ngemininingwane ekhonjiswe esitokisini, hhayi kumgqomo wefomula, udinga ukwenza kabusha ukushintshwa kwesikhundla Amafomula esikhundleni "Amanani". Ngaphezu kwalokho, kungenzeka ukusesha ngamanothi. Kulokhu, siguqula inkinobho ngesikhundla "Amanothi".
Ungacacisa ukusesha ngokunembe ngokwengeziwe ngokuchofoza inkinobho. "Ifomathi".
Lokhu kuvula iwindi lefomethi yeseli. Lapha ungabeka ifomethi yamaseli azobamba iqhaza kusesho. Ungasetha imikhawulo kufomethi yenombolo, ukuqondanisa, ifonti, umngcele, ukugcwalisa nokuvikelwa, ngokuya ngalezi zinhlaka, noma ngokuzihlanganisa ndawonye.
Uma ufuna ukusebenzisa ifomethi yeseli ethile, khona-ke ngezansi kwewindi chofoza inkinobho "Sebenzisa ifomethi yalesi seli ...".
Ngemuva kwalokho, insimbi ivela ngesimo se-pipette. Ukuyisebenzisa, ungakhetha iseli ozolisebenzisa.
Ngemuva kokuthi ifomethi yokucinga isilungiselelwe, chofoza inkinobho "Kulungile".
Kunezikhathi lapho udinga ukuthi ungafune ibinzana elithile, kepha uthole amaseli aqukethe amagama wokusesha nganoma iyiphi i-oda, noma ngabe ahlukaniswe ngamanye amagama nezimpawu. Ngemuva kwalokho la magama kufanele amakwe ezinhlangothini zombili ngo- "*". Manje emiphumeleni yokucinga wonke amaseli lapho la magama akwe khona kunoma imuphi i-oda azoboniswa.
- Lapho amasethingi okusesha esethiwe, chofoza inkinobho Thola Konke noma "Thola ngokulandelayo"ukuya emiphumeleni yosesho.
Njengoba ukwazi ukubona, i-Excel ilula impela, kepha ngasikhathi sinye sebenza kakhulu amathuluzi okusesha. Ukuze wenze i-squeak elula, vele ubize ibhokisi lokucingwayo, ufake umbuzo kulo, bese uchofoza inkinobho. Kepha, ngasikhathi sinye, kungenzeka ukwenza ngokwezifiso ukusesha ngakunye ngenombolo enkulu yamapharamitha ahlukile nezilungiselelo ezingeziwe.
