Mhlawumbe, abasebenzisi abaningi abangenalwazi bazama ukukopisha idatha ku-Excel, kodwa ngenxa yezenzo zabo, okwakhiqizwa kukhiqize ukuthi kunenani elihlukile ngokuphelele noma iphutha. Lokhu kungenxa yokuthi ifomula yayisekhompyutheni eyinhloko yekhophi, futhi kwakuyifomula efakiwe, hhayi inani. Izinkinga ezinjalo ngabe zigweme uma laba basebenzi bezijwayele umqondo onjengokuthi "Namathisela Okukhethekile". Ngalo, ungenza neminye imisebenzi eminingi, kuhlanganise ne-arithmetic. Ake sibone ukuthi leli thuluzi liyini nokuthi lizosebenza kanjani nayo.
Sebenza ngokufaka okukhethekile
Namathisela Okukhethekile ngokuyinhloko kuhloswe ukufaka inkulumo ethize kwi-Excel sheet njengoba idinga ngumsebenzisi. Ukusebenzisa leli thuluzi, awufaki yonke idatha ekopishiwe esitokisini, kodwa kuphela impahla (amanani, amafomula, ifomethi, njll). Ngaphezu kwalokho, usebenzisa amathuluzi, ungenza imisebenzi yezibalo (ukuhlanganisa, ukubuyabuyelela, ukususa nokuhlukanisa), kanye nokufaka ithala, okungukuthi, ukuguqula imigqa namakholomu kuwo.
Ukuya kufaka ekhethekile, okokuqala, udinga ukwenza isenzo sokukopisha.
- Khetha iseli noma ububanzi ofuna ukukopisha. Khetha ngesikhombisi ngenkathi ubambe inkinobho yesinxele segundane. Chofoza ekukhethweni ngenkinobho yegundane efanele. Imenyu yenkathi icushiwe, lapho okudingeka ukhethe khona into "Kopisha".
Futhi, esikhundleni senqubo engenhla, ungaba, ekubeni kuthebhu "Ikhaya", chofoza kusithonjana "Kopisha"okuyinto efakwe kwi-tape eqenjini "Ibhodi lokunamathisela".
Ungakopisha inkulumo ngokuyikhetha nokuthayipha inhlanganisela yamakhi ashisayo Ctrl + C.
- Ukuya ngokuqondile enkambisweni, khetha indawo eshadini lapho sihlela ukunamathisela izakhi zangaphambili ezikopishiwe. Chofoza ekukhethweni ngenkinobho yegundane efanele. Kumenyu yomongo oqalisiwe, khetha isikhundla "Faka okukhethekile ...". Emva kwalokho, uhlu olungeziwe luvuleka lapho ungakhetha khona izinhlobo ezahlukene zezenzo, uhlukaniswe ngamaqembu amathathu:
- Faka (Namathisela, UkuDlulisa, Amafomula, Amafomula namafomathi wezinombolo, Ukungahambisani nemingcele, Londoloza ama-Columns Obanzi ububanzi, futhi Gcina ukufometha kokuqala);
- Faka amanani ("Inani nokufometha kwangempela", "Amanani" kanye "Nemigomo namafomethi ezinombolo");
- Ezinye izinketho zokufaka ("Ukufometha", "Isithombe", "Faka isixhumanisi" nesithombe esithintekayo).
Njengoba ubona, amathuluzi weqembu lokuqala abhalela le nkulumo equkethwe kuseli noma ububanzi. Iqembu lesibili lihloselwe, okokuqala, ukukopisha amanani, hhayi amafomula. Iqembu lesithathu lenza ukufometha nokubukeka kokudlulisa.
- Ngaphezu kwalokho, kwimenyu efanayo eyengeziwe kukhona enye into enegama elifanayo - "Faka okukhethekile ...".
- Uma uhamba ngayo, ifasitela lokufaka elihlukile livula ngamathuluzi ahlukaniswe ngamaqembu amabili amakhulu: Namathisela futhi "Ukusebenza". Ngokufanayo, ngenxa yamathuluzi eqembu lokugcina, kungenzeka ukwenza imisebenzi yezibalo, okuxoxwa ngenhla. Ngaphezu kwalokho, kule window kukhona izinto ezimbili ezingabandakanywa kumaqembu ahlukene: "Yeqa amaseli angenalutho" futhi "Ukuthutha".
- Ukufaka okukhethekile kungatholakali kuphela kwimenyu yenkomfa, kodwa futhi ngokusebenzisa amathuluzi ebhebhoni. Ukuze wenze lokhu, ukuthi ube kuthebhu "Ikhaya", chofoza isithonjana ngesimo soxantathu obheke phansi, esitholakala ngaphansi kwenkinobho Namathisela eqenjini "Ibhodi lokunamathisela". Khona-ke uhlu lwezinyathelo ezingenzeka luvulwa, kufaka phakathi ukuguqulwa kwindiza ehlukile.
Indlela yoku-1: Sebenza ngama-Values
Uma udinga ukudlulisela amanani amangqamuzana, umphumela wawo uthola ngokusebenzisa amafomula ama-computational, bese kufakwa okukhethekile okuhloswe kweso simo esinjalo. Uma usebenzisa ukukopisha okujwayelekile, ifomula izokopishwa, futhi inani eliboniswe kuyo lingase lingabi yilokho okudingayo.
- Ukuze ukopishe amanani, khetha uhla oluqukethe umphumela wokubala. Kopisha nganoma yiziphi izindlela esizikhulume ngazo ngenhla: imenyu yenkondlo, inkinobho ebhethini, inhlanganisela yamakhi ashisayo.
- Khetha indawo eshadini lapho sihlela ukufaka khona idatha. Iya kwimenyu kwenye yezo zindlela, okukhulunywe ngakho ngenhla. Ku-block "Faka amanani" khetha isikhundla "Amanani namafomethi wezinombolo". Le nto ifaneleke kakhulu kule simo.
Inqubo efanayo ingenziwa ngefasitela esiye sachaza ngaphambili. Kulesi simo, ku-block Namathisela shintsha endaweni "Amanani namafomethi wezinombolo" bese ucindezela inkinobho "Kulungile".
- Noma ngabe iyiphi inketho oyikhethayo, idatha izodluliselwa ebangeni elikhethiwe. Izoboniswa impela imiphumela ngaphandle kokudluliselwa kwamafomula.
Isifundo: Indlela yokususa ifomula ku-Excel
Indlela 2: Amafomula Okukopisha
Kodwa kunesimo esihlukile uma kudingeka ukukopisha amafomula.
- Kulesi simo, senza inqubo yokukopisha kunoma iyiphi indlela ekhona.
- Ngemva kwalokho, khetha indawo eshadini lapho ufuna ukufaka itafula noma enye idatha. Yenza kusebenze imenyu yesimo bese ukhetha into "Amafomula". Kulesi simo, amafomula namanani kuphela azofakwa (kulawo maseli lapho kungekho khona amafomula), kodwa ukufometha nokulungiswa kwamafomethi ezinombolo kuzolahleka. Ngakho-ke, isibonelo, uma ifomethi yosuku ikhona endaweni yomthombo, ngemuva kokuyikopisha kuyoboniswa ngokungalungile. Amaseli ahambelana nawo azodinga ukufomatha futhi.
Ewindini, lesi senzo sifana nokuhambisa umshini endaweni "Amafomula".
Kodwa kungenzeka ukudlulisa amafomula ngokulondoloza ifomethi yezinombolo noma ngisho nokulondolozwa okugcwele kokufometha kwangempela.
- Esimweni sokuqala, kwimenyu, khetha isikhundla Amafomula namafomethi wezinombolo.
Uma ukusebenza kwenziwa ngefasitela, khona-ke kuleli cala udinga ukuhambisa ushintsho Amafomula namafomethi wezinombolo bese ucindezela inkinobho "Kulungile".
- Esikhathini sesibili, uma udinga ukusindisa amafomula kuphela namafomethi wezinombolo, kodwa futhi nokufometha okugcwele, ukhethe into kwimenyu "Londoloza ukufometha kwangempela".
Uma umsebenzisi enquma ukwenza lo msebenzi ngokuthuthela efasiteleni, khona-ke kuleli cala udinga ukuhambisa ushintsho endaweni "Ngesihloko esithi" bese ucindezela inkinobho "Kulungile".
Indlela 3: ukudluliswa kwefomethi
Uma umsebenzisi engadingi ukudlulisa idatha, futhi ufuna kuphela ukukopisha ithebula ukuze aligcwalise ngolwazi oluhluke ngokuphelele, khona-ke kuleli cala ungasebenzisa into ethize yokufaka okukhethekile.
- Kopisha ithebula lomthombo.
- Esikhatsini, khetha isikhala lapho sifuna ukufaka khona isakhiwo setafula. Shayela imenyu yesimo. Kuyo kusigaba "Ezinye Izinketho Zokufaka" khetha into "Ukufometha".
Uma inqubo yenziwa ngefasitela, ke kulokhu, hambisa ukushintshela endaweni "Amafomethi" bese uchofoza inkinobho "Kulungile".
- Njengoba ubona, emva kwalezi zenzo kukhona ukudluliswa kwesakhiwo setafula lomthombo ngokufometha okulondoloziwe, kodwa akugcini neze ukugcwala idatha.
Indlela 4: Kopisha ithebula ngenkathi ugcina ubukhulu bekholomu
Akuyona imfihlo ukuthi uma senza ukukopisha okulula kwetafula, akusiwo iqiniso ukuthi wonke amaseli etafula elisha azokwazi ukuqukatha lonke ulwazi kumakhodi omthombo. Ukulungisa lesi simo uma ukopisha, ungasebenzisa nokufaka okukhethekile.
- Okokuqala, nganoma yiziphi izindlela ezingenhla, kopisha ithebula lomthombo.
- Ngemva kokusungula imenyu esivele iyajwayele, sikhetha inani "Londoloza ububanzi bekholomu yokuqala".
Inqubo efanayo ingenziwa ngokusebenzisa iwindi ekhethekile yokufaka. Ukuze wenze lokhu, lungisa kabusha ushintsho endaweni "Ububanzi bekholomu". Emva kwalokho, njengoba njalo, chofoza inkinobho. "Kulungile".
- Itafula ifakwa ngobubanzi bekholomu yangempela.
Indlela 5: Faka isithombe
Ngenxa yokufaka okukhethekile, ungakwazi ukukopisha noma iyiphi idatha evezwe kushidi, kufaka phakathi itafula, njengesithombe.
- Kopisha into usebenzisa amakhophi ekhophi evamile.
- Khetha indawo kushidi lapho umdwebo kufanele ubeke khona. Shayela imenyu. Khetha into kuwo "Ukudweba" noma "Umdwebo ohlobene". Esimweni sokuqala, isithombe esifakiwe ngeke sihlotshaniswe netafula lomthombo. Esimweni sesibili, uma ushintsha amanani etafuleni, umdwebo uzophinde uvuselelwe ngokuzenzakalelayo.
Esikhathini efakwe iwindi ekhethekile, ukuhlinzwa okunjalo akunakwenziwa.
Indlela 6: Amanothi Kopisha
Nge-insert ekhethekile, ungakwazi ukukopisha ngokushesha amanothi.
- Khetha amaseli aqukethe amanothi. Senza ukukopisha kwabo ngokusebenzisa imenyu yenkondlo, besebenzisa inkinobho ebhokisini noma ngokucindezela inhlanganisela eyinhloko Ctrl + C.
- Khetha amaseli lapho amanothi kufanele afakwe khona. Yiya efasiteleni lokufaka elikhethekile.
- Ewindini evula, lungisa kabusha ushintsho endaweni "Amanothi". Sicindezela inkinobho "Kulungile".
- Ngemva kwalokho, amanothi azokopishwa kumaseli akhethiwe, futhi yonke idatha izohlala ingashintshi.
Indlela yesi-7: faka ithebula
Ukusebenzisa ukufaka okukhethekile, ungathumela amatafula, amamatiriyithi, nezinye izinto ofuna ukushintsha ngazo amakholomu nemigqa.
- Khetha ithebula ofuna ukuyifaka, bese ulikopisha usebenzisa enye yezindlela esaziyo kakade.
- Khetha eshadini ububanzi lapho uhlela khona ukubeka inguqulo eguquliwe yetafula. Yenza kusebenze imenyu yesimo bese ukhetha into kuyo. "Ukuthutha".
Lokhu kusebenza kungenziwa futhi ngokusebenzisa iwindi elijwayelekile. Kulokhu, uzodinga ukuphawula ibhokisi "Ukuthutha" bese ucindezela inkinobho "Kulungile".
- Futhi eqinisweni, futhi kwelinye icala, okukhiphayo kuyoba yithebula eliguquguqukayo, okungukuthi, itafula elinamakholomu nemigqa.
Isifundo: Ungafake kanjani itafula ku-Excel
Indlela 8: Sebenzisa i-Arithmetic
Ukusebenzisa ithuluzi elichazwe yi-Excel, ungenza futhi imisebenzi ejwayelekile ye-arithmetic:
- Ukwengeza;
- Ukuphindaphinda;
- Ukususa;
- Isigaba
Ake sibone ukuthi leli thuluzi lisetshenziswa kanjani esibonelweni sokuphindaphinda.
- Okokuqala, singena esitokisini esilutho esingenalutho inombolo esilungiselela ngayo ukwandisa uhla lwemininingwane ngokufaka okukhethekile. Okulandelayo, siyikopishe. Lokhu kungenziwa ngokucindezela inhlanganisela yokhiye Ctrl + C, ngokubiza imenyu yomongo noma ukusebenzisa amandla amathekisthi okukopisha kwi-tape.
- Khetha ububanzi eshadini, okumele sande. Chofoza ekukhethweni ngenkinobho yegundane efanele. Emenyu yemenyu evulwe, chofoza kabili ezintweni. "Faka okukhethekile ...".
- Ifasitela ivuliwe. Eqenjini lemingcele "Ukusebenza" setha inkinobho ukuma "Yandisa". Okulandelayo, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalesi senzo wonke amanani webanga elikhethiwe athulwe ngenombolo ekopishiwe. Esimweni sethu, le nombolo 10.
Isimiso esifanayo singasetshenziselwa ukwahlukana, ukuhlanganisa nokukhipha. Kuphela lokhu, ifasitela kuzodinga ukuhlela kabusha ushintsho, ngokulandelana, endaweni Hlukana, "Fold" noma "Susa". Ngaphandle kwalokho, zonke izenzo zifana nezindlela ezichazwe ngenhla.
Njengoba ubona, ukufakwa okukhethekile kuyithuluzi eliwusizo lomsebenzisi. Ngalo, awukwazi ukukopisha kuphela yonke ibhulogi yedatha esitokisini noma ebangeni, kodwa ngokuwahlukanisa ngezigaba ezahlukene (amanani, amafomula, ukufometha, njll). Ngaphezu kwalokho, kungenzeka ukuhlanganisa lezi zigaba nomunye. Ngaphezu kwalokho, imisebenzi ye-arithmetic ingenziwa ngokusebenzisa ithuluzi elifanayo. Yiqiniso, ukutholakala kwamakhono okusebenza nalolu buchwepheshe kuzosiza kakhulu abasebenzisi endleleni yokuqonda i-Excel yonke.
