Kwi-Microsoft Excel, enenani elikhulu lamasimi, kuhlala kuyimfuneko ukufumana idatha ethile, igama lomgca, njl. Ingakhululekanga kakhulu xa kufuneka ujonge inani elikhulu lemigca ukuze ufumane igama elifunayo okanye intetho. Gcina ixesha kunye ne-nerves iya kunceda ukhangelo lweMicrosoft Excel. Makhe siyibone ukuba isebenza njani, nendlela yokuyisebenzisa.
Umsebenzi wokukhangela kwi-Excel
Umsebenzi weMicrosoft Excel unikezela ukukwazi ukufumana itekisi oyifunayo okanye amanani amanani nge "Fumana kwaye ubeke endaweni ye" Window. Ukongeza, isicelo sinokwazi ukuphucula ukukhangela kwedatha.Indlela yoku-1: Ukukhangela ngokulula
Ukukhetha idatha elula kwiNkqubo ye-Excel ikuvumela ukuba ufumane zonke iiseli eziqulathe i-Window kwiwindows yokukhangela (iileta, amanani, amagama, njl.njl) ngaphandle kokubhalisa irejista.
- Ukuba sekhaya "ikhaya", cofa kwi "Fumana kwaye ukhethe" iqhosha, elikwe kwikhasethi kwi-Tepebar yokuhlela. Kwimenyu ebonakalayo, khetha "Fumana ...". Endaweni yezi zenzo, unokukhetha nje i-CTRL + F izitshixo kwikhibhodi.
- Emva kokuba uqalile kwizinto ezifanelekileyo kwiteyiphu, okanye indibaniselwano yamaqhosha ashushu, "fumana kwaye uyibuyisele i" Window Vula kwithebhu. Uyasifuna. Kwintsimi ethi "Fumana" intsimi, sifaka eLizwini, iisimboli, okanye amabinzana esiya kukhangela kuwo. Cofa kwiqhosha "Fumana" iqhosha elilandelayo, okanye "Fumana yonke iqhosha".
- Xa ucofa kwi "Fumana" iqhosha elilandelayo, siye kwiseli yokuqala apho amaqela afakiweyo afakwe khona. Iseli ngokwalo isebenza.
Khangela kunye nokukhupha iziphumo zenziwe umgca. Okokuqala, zonke iiseli zomgca wokuqala zigqityiwe. Ukuba idatha ehlangabezana nemeko ayifumanekanga, inkqubo iqala ukukhangela kumgca wesibini, njalo njalo de ifumane iziphumo ezanelisayo.
Iisimboli zokukhangela azinantsingiselo. Ke, ukuba igama elithi "amalungelo" libekiwe njengesicelo, emva koko zonke iiseli eziqukethe oku kulungiselelwe oonobumba kuya kuboniswa kwindawo ekhutshiweyo nangaphakathi kwegama. Umzekelo, igama elithi "ilungelo" liza kuthathwa njengefanelekileyo kulo mzekelo. Ukuba chaza inombolo "1" kwi-injini yokukhangela, ke kukho iiseli eziqulathe, umzekelo, inani "516".
Ukuze uqhubeke kwisiphumo esilandelayo, cofa iqhosha "Fumana" kwakhona "kwakhona.
Oku kunokuqhubeka de umboniso wesiphumo awuqali kwisangqa esitsha.
- Kwimeko xa uqala inkqubo yokukhangela, ucofa kwi "Fumana zonke", zonke iziphumo ezikhuphayo ziya kuboniswa njengoluhlu ezantsi kwebhokisi yokukhangela. Olu luhlu lube nolwazi malunga nomxholo weeseli zedatha ezanelisa umbuzo wokukhangela, indawo yazo ibonisiwe, kunye nephepha kwaye le ncwadi zihambelana nazo. Ukuze uye nakweyiphi na iziphumo zokukhutshwa, kwanele ukucofa kuyo ngeqhosha lasekhohlo. Emva koko, isikhombisi siyakuya kwiseli egqwesileyo, apho umsebenzisi enze ucofe.
Indlela 2: Khangela kwixesha lezithuba ezichaziweyo
Ukuba unetafile enkulu enkulu, emva koko kule meko akusoloko kufanelekile ukukhangela lonke iphepha, kuba ekukhangeleni isiseko semiphumo engafunekiyo kwimeko ethile. Kukho indlela yokunciphisa umda wendawo yokukhangela kuphela ngoluhlu oluthile lweeseli.
- Sibalaselisa indawo yeeseli esifuna ukufuna.
- Sifumana indibaniselwano ye-CTRL Amanye amanyathelo ayafana ngqo phantsi kwendlela yangaphambili. Umahluko kuphela uya kuba kukuba ukukhangela kwenziwa kuphela kwithuba leeseli ezichaziweyo.
Indlela 3: Uphando oliphezulu
Njengoko kuchaziwe apha ngasentla, ngophando oluqhelekileyo lokukhupha iziphumo, zonke iiseli ezineseti ye-serial yeempawu zokukhangela nangayiphi na indlela azixhomekekanga kwirejista.
Ukongeza, hayi kuphela iziqulatho zeseli ethile, kodwa nedilesi yento ebhekiswe kuyo inokukhululwa. Umzekelo, kwiseli e2 iqulethe ifomula esiyi-A4 ye-A4 kunye ne-C3. Le mali yi-10, kwaye eli nani liboniswe kwiseli ye-E2. Kodwa, ukuba sicela ukukhangela inani "4", ke phakathi kweziphumo zokukhutshwa kuya kubakho i-sel ye-E2. Inokwenzeka njani le nto? Kwiseli ye-E2, ifomula iqulethe idilesi kwiseli ye-A4, ebandakanya inani elifunekayo 4.
Kodwa, njani ukuba banqumle njani iziphumo zokukhangela ezingamkelekanga? Kungenxa yezi njongo ukuba kukho i-deaclock play presel.
- Emva kokuvula "Fumana kwaye ubeke endaweni ye" Window, nayiphi na ichazwe kuyo nayiphi na ichazwe apha ngasentla, cofa kwi "Parameter".
- Inani lezixhobo ezongezelelweyo zokulawula ukukhangela kuvela efestileni. Ngokungagqibekanga, zonke ezi zixhobo zikwisimo, njengokukhangela okuqhelekileyo, kodwa ukuba kukho imfuneko, unokuhlengahlengisa.
Ngokungagqibekanga, imisebenzi "uthatha ingqalelo irejista" kunye ne "Iiseli" ze "zikhubazekile, kodwa ukuba sibeka imikhaza kufutshane nezinto ezifanelekileyo, emva koko irejista ingeniswe xa ithathelwa ingqalelo iziphumo, kunye ne ngqo ngqo. Ukuba ufaka igama elinencwadi encinci, emva koko ukufundwa kweeseli, iiseli eziqulathe ukubhalwa kweli gama kunye nonobumba omkhulu, njengoko bekuya kuba ngokusilelayo, akusayi kuphinda kubekho. Ukongeza, ukuba umsebenzi "oselula" unikwe amandla, kuphela nezixhobo ezinamagama achanekileyo ziya kongezwa kwikhrimu. Umzekelo, ukuba ubuza umbuzo wokukhangela "Nikolaev", emva koko iiseli ezinombhalo "Nikolaev Add." awuzukuphinda wongezwe kukhuphiswano.
Ngokuzenzekelayo, ukukhangela kwenziwa kuphela kwigqabi elisebenzayo le-Excel. Kodwa ukuba iparameter ethi "Khangela" uza kudlulisela kwi "kwincwadi ethi" Isikhundla, ukukhangela kuyakwenziwa kuzo zonke iifayile ezivulekileyo.
Ungalutshintsha indlela yokukhangela kwi parameter "Jonga". Ngokungagqibekanga, njengoko kuchaziwe apha ngasentla, ukukhangela kwenziwa ngoku-odolo. Ukukhusela ukutshintshela kwisikhundla "ngeekholamu", unokuseta inkqubo yokuqulunqwa kweziphumo zokukhutshwa, ukuqala kwikholamu yokuqala.
Ikholamu "Indawo yokukhangela" igqityiwe, phakathi kwezinto eziphathwayo. Ngokungagqibekanga, ezi zenziwa, oko kukuthi, ezo datha ukuba xa ucofa kwiseli uboniswa kwi-formula yomtya. Isenokuba ligama, inani okanye ikhonkco kwiseli. Kwangelo xesha, le nkqubo, ukwenza uphando, ibona kuphela ireferensi, hayi iziphumo. Esi siphumo saxoxwa ngaphezulu. Ukukhangela ngokuthe ngqo kwiziphumo, idatha ebonisiweyo kwiseli iyaboniswa, kwaye ayikho kwi-formula teks, kufuneka uphinde uphinde uphinde usebenzise i-switsula "isikhundla" sexabiso "kwimo" yexabiso "kwi" Ukongeza, kukho ithuba lokukhangela amanqaku. Kule meko, utshintsho luhlengahlengiswa kwindawo "yamanqaku".
Uphengululo oluchanekileyo ngakumbi lunokusetwa ngokunqakraza kwi "FRAFA".
Oku kuvula iwindow yefowuni yeseli. Apha ungabeka ifomathi yeseli ukuba ithathe inxaxheba kukhangelo oluphambili. Unokuseta izithintelo kwifomathi yenani, ulungelelwaniso, ifonti, umda, ugcwalise kunye nokukhusela, enye yezi paramitha, okanye ngokudibanisa kunye.
Ukuba ufuna ukusebenzisa ifomathi yeseli ethile, emva koko ezantsi kwefestile, cofa iqhosha leseli ... ".
Emva koko, isixhobo sivela ngendlela yombhobho. Ngayo, unokukhetha eso siseli oza kuyisebenzisa ifomathi.
Emva kwefomathi yokukhangela ilungiselelwe, cofa iqhosha u "Kulungile".
Kukho iimeko apho ufuna ukukhangela amabinzana athile, kodwa fumana iiseli apho amagama akhangela kuwo nawuphi na umyalelo, nokuba amanye amagama kunye neesimboli zahlulwe. Emva koko la magama abiwe kumacala omabini "" "uphawu. Ngoku kwiziphumo zokukhangela ziya kuboniswa zonke iiseli ezifumaneka kuwo nawuphi na umyalelo.
- Nje ukuba zicwangciswe iiseti zokukhangela, kuya kufuneka ucofe "Fumana zonke" okanye "Fumana" iqhosha ukuya kwiziphumo zokukhangela.
Njengoko ubona, inkqubo ye-Excel ihlala ilula, kodwa kwangaxeshanye kukhangelo oluqinisekileyo lwezixhobo zokukhangela. Ukuze kuvelise i-squeak elula, kwanele ukubiza ibhokisi yokukhangela, faka umbuzo kuyo, kwaye ucofe iqhosha. Kodwa, kwangaxeshanye, kunokwenzeka ukuba uqwalasele ukhangelo lomntu ngenani elikhulu leeparamitha ezahlukeneyo kunye noseto olongezelelweyo.