Indlela lande "Eksele" amaseli bodwa?

Namuhla, lamathuluzi ezidume kakhulu izibalo eziyinkimbinkimbi uhlelo e-Microsoft Excel. Ukusebenza Its ezibanzi ukuze lula nesixazululo imisebenzi isethi ebesingandile ukuchitha isikhathi esiningi. Namuhla sibheka indlela lande amaseli "Eksele" ndawonye ngamanani amakhulu.

Ukubuyabuyelela ku "Eksele"

Ngaphambi ukuthola indlela lande "Eksele" izinombolo, kuyafaneleka ukusebenza ezibanzi zohlelo, okuvumela ukuba basebenze bobabili isabelo ecacile izinombolo nokusebenzisa amaseli eziqukethe ngokwazo nezinombolo kanye namafomula, etintfweni yabo. Ukuze uphindaphinde amaseli eyodwa noma ngaphezulu noma inani lamaseli ukuthi kudingeka kubha ifomula ngemva setshwayo abonisa izakhi idatha ishidi noma value ebhaliwe.

Ukubuyabuyelela weseli cell

Ngaphezu kwalokho, kuyazuzisa ukuqonda isimiso, njengasezulwini "Eksele" ukwanda yeseli yeseli nalokho izinkinga ezingadaleka lapho abantu ukuhlangana nawe inqubo. Ukuze siphindaphindeka amagugu lamaseli ezimbili zilandelana kudingeka babhalise isakhiwo ifomula elandelayo: "= A * B", lapho "A" futhi "B" - izixhumanisi izakhi abafanele ishidi "EXCEL", okungukuthi amaseli.

Thola imiphumela, kungase kudingeke ukudala ikhophi, futhi abasebenzisi ngokuvamile unganqikazi, nje ukopishe ukubaluleka leli seli ngokufaka saba esinye. Nokho, le ndlela kuzokwenzeka futhi ushintshe nezixhumanisi ezihlobene ekhomba factorization. Ukuze ugweme iphutha esinjalo, kufanele bube yizinombolo kuseli lapho ufuna ukukopisha umphumela, ufake isixhumanisi iseli ukopishiwe, noma "ukulungisa" ikheli izici zayo isibonakaliso "$". Isibonakaliso dollar unawo inkomba Inani ipharamitha, ukulilandela - okungukuthi, $ isixhumanisi A4 uyohlale isho ikholomu A, A $ 4 - emgqeni wesine, futhi $ A $ 4 - kuphela iseli A4. Ngamanye amazwi, lo kokungathembeki yeseli - ukudalwa i inkombakuqheliwe ngokuphelele kukho.

Ukubuyabuyelela of kanye nemigqa

Ukusebenzisa ukulungisa algorithm cell amakheli, ungaya ngqo indlela lande "Eksele" uhlu nohlu noma umugqa kumugqa. Ukugcina isikhathi ekubhaleni ifomula omkhulu, ungavele zisebenzisa kushintsha impahla yereferensi yeseli lapho ukuthuthela ikheli pointer entsha. Okusho ukuthi, uma kudingekile ukuze wande ukubaluleka ngababili amakholomu amabili, kwanele ukuba abhale ifomula ukubuyabuyelela for umbhangqwana wokuqala amaseli, bese, ubambe uphawu "omnyama plus" ezavela ekhoneni lesidla eliphansi yokwelula yi phansi kanye wonke amanani ekholomu-Okuphindaphinda.

Ukuze kuzuzwe umphumela okufanayo imigqa, kubalulekile kuphela ukukhiqiza umphumela esisuka kanye imizila abafanele. Kuyaphawuleka ukuthi ukuze ugweme ukuguquguquka phakathi ikhophi okwalandela ngemiphumela, kubalulekile ukulungisa ifomula ikhalamu noma umugqa ecacisiwe - ke ukwazi ukugwema amaphutha ukubala.

Ukuphindwaphindwa lomugqa noma ikholomu yeseli

Ngokuqonda indlela lande "Eksele" uhlu nohlu noma umugqa kumugqa, kubalulekile ukuba zihlale operation eyodwa ethize - ukubuyabuyelela lamaseli irowu noma ikholomu. Uma ukubuyabuyelela algorithm zisebenzisa isenzo esifanayo njengoba kwaba njalo endabeni ka-ukubuyabuyelela amakholomu, umphumela uyoba kuphela iphindwe ukubaluleka irowu yokuqala yale ikholomu, kusukela ikheli iseli kuzohluka nge Uzalo ngamunye cell isikhundla esisodwa.

Ukuze ugweme lokhu, kubalulekile ukuba ulungise inombolo umugqa iyanda yi iseli noma ngokuphelele yayo - kulesi simo, uzokwazi ukusebenzisa inani layo ngoba amakholomu amaningi. Endabeni ukubuyabuyelela ngumuntu othile cell umugqa incwadi yokuvala ikholomu ngokwanele lapho uhlala, noma lokwenza kokubili ikheli iseli ipharamitha njalo.

Indlela wande zonke izinombolo zilandelana noma ikholomu

Ngezinye izikhathi "Eksele" iyadingeka ukwenza operation efana ukuthi inani, kuphela enza ukusebenza zokuphindaphinda. Nokho, inqubo ekhethekile okuzenzakalelayo kwaleli alikho, eziningi kangaka, bengazi ukuthi "Eksele" izandisele inani ikholomu eyodwa noma kumugqa nomunye, ukukwenza ngokucacile, ukuqopha isenzo yengqamuzana ngayinye. Empeleni, uhlelo kukhona ukusebenza ezingasiza ukuxazulula inkinga indlela lande "Eksele" nomunye izikhathi eziningana ngokushesha.

Ukuze uphindaphinde ibanga elithile amaseli nomunye, nje khetha imenyu "Faka Umsebenzi" ukusebenza ngokuthi "ukwenza." Njengoba i-agumenti umsebenzi by amaseli ukuthi kumele iphindwe nomunye, kungaba njengoba amakholomu, imigqa, amaseli, noma yonke afanayo. Kufanele kuqashelwe ukuthi khona eyeseli angenalutho kububanzi kusengaphambili umphumela ukubuyabuyelela akulingani zero - kulokhu uhlelo izoliziba leli seli, isb null kufanisa indlela eya ebunyeni.

isifinyezo

Thola indlela lande "Eksele" ezingase zithathwe imibhalo eyinkimbinkimbi, kuhlanganise nemibiko nezomnotho kanye nokuqagula. imisebenzi Iningi izibalo engenziwa ngendlela efanayo, kodwa kwabanye kufanele bacabangele imininingwane ekusetshenzisweni kwazo, kanye ifomethi cell. Ngakho, ngokwesibonelo, sokuhlukanisa iseli yeseli ukungabi yamanani omunye wabo, umphumela iyona division iphutha ngo-zero.