Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel

Ukuze wenze izenzo ezithile kusipredishithi, ukuhlonza okuhlukile kwamaseli noma ububanzi bawo kuyadingeka. Ngamunye wabo anganikezwa igama, isabelo sisiza iphrosesa yesipredishithi ukuthi iqonde ukuthi lokhu noma leyo nto itholakala kuphi ekhasini lokusebenzela. I-athikili izofaka zonke izindlela zokunikeza igama kuseli kuthebula.

Ukuqamba igama

Unganikeza igama emkhakheni noma ububanzi kusipredishithi usebenzisa izindlela ezimbalwa, esizoxoxa ngazo ngezansi.

Indlela 1: umucu wegama

Ukufaka igama emugqeni wamagama kuyindlela elula futhi elula kakhulu. Umugqa wamagama utholakala kwesokunxele senkambu yokufaka amafomula. Umyalelo wesinyathelo ngesinyathelo ubukeka kanje:

  1. Sikhetha ububanzi noma ingxenye eyodwa yethebula.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
1
  1. Emgqeni wamagama sishayela egameni elidingekayo lendawo ekhethiwe. Lapho ufaka, kufanele ucabangele imithetho yokunikeza igama. Ngemuva kokwenza konke ukukhohlisa, cindezela inkinobho ethi "Enter" kukhibhodi.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
2
  1. Ilungile! Sesiqedile ukuqamba iseli noma uhla lwamaseli. Uma uwakhetha, igama esilifakile lizovela kulayini wamagama. Igama lendawo ekhethiwe lihlala liboniswa emugqeni wamagama, kungakhathaliseki ukuthi igama labelwe kanjani.

Indlela 2: imenyu yokuqukethwe

Imenyu yokuqukethwe iyingxenye eyisizayo yokusebenzisa ukuqamba amaseli. I-Walkthrough ibonakala kanje:

  1. Sikhetha indawo esihlela ukuyiqamba igama. Sichofoza i-RMB. Imenyu yokuqukethwe encane ivela esibukweni. Sithola into ethi “Nikeza igama…” bese uchofoza kuyo.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
3
  1. Kuvele iwindi elincane elisha esikrinini elibizwa ngokuthi “Ukudala Igama”. Emgqeni othi "Igama" kufanele ufake igama ofuna ukulisetha indawo ekhethiwe.
  2. Emgqeni othi "Isifunda" sibonisa indawo lapho, lapho sikhuluma negama elinikeziwe, uhla olukhethiwe lwemikhakha luzonqunywa. Indawo ingaba idokhumenti yonke noma amanye amaphepha okusebenza kudokhumenti. Ngokuvamile le parameter ishiywa ingashintshiwe.
  3. Umugqa othi "Qaphela" uqukethe amanothi ahluke ngokuphelele achaza indawo yedatha ekhethiwe. Inkambu ingashiywa ingenalutho njengoba lesi sakhiwo singabhekwa njengesidingo.
  4. Emgqeni othi "Ububanzi", faka izixhumanisi zendawo yedatha esiwabela yona igama. Izixhumanisi zobubanzi obukhethiwe ekuqaleni zibekwe kulo mugqa ngokuzenzakalelayo.
  5. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
4
  1. Ilungile! Sinikeze igama ohlwini lwedatha sisebenzisa imenyu yokuqukethwe kwespredishithi se-Excel.

Indlela yesi-3: Nikeza isihloko usebenzisa inkinobho kuribhoni

Ngosizo lwamathuluzi akhethekile atholakala kubhebhoni, ungacacisa igama lendawo yedatha. I-Walkthrough ibonakala kanje:

  1. Sikhetha indawo esihlela ukuyiqamba igama. Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Yabela igama" kuleli phaneli.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
5
  1. Isikrini sibonise iwindi elincane elibizwa ngokuthi "Dala igama", esilazi endleleni yangaphambilini. Senza konke ukukhohlisa okufanayo njengasesibonelweni esicatshangelwe ngaphambili. Chofoza "KULUNGILE".
  2. Ilungile! Sinikeze igama lendawo yedatha sisebenzisa izinto ezitholakala kuribhoni yamathuluzi.

Indlela yesi-4: Umphathi Wegama

Ngento ebizwa ngokuthi “Isiphathi Segama”, ungasetha igama lendawo yedatha ekhethiwe. I-Walkthrough ibonakala kanje:

  1. Sithuthela esigabeni "Amafomula". Thola ibhulokhi yomyalo ethi “Amagama Achaziwe” bese uchofoza into ethi “Isiphathi Segama” kuleli phaneli.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
6
  1. Iwindi elincane elithi “Isiphathi Segama…” liboniswe esibukweni. Ukuze wengeze igama elisha lendawo yedatha, chofoza into ethi "Dala ...".
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
7
  1. Isibonisi sibonise iwindi elijwayelekile elibizwa ngokuthi “Nika igama.” Njengezindlela ezichazwe ngenhla, sigcwalisa zonke izinkambu ezingenalutho ngolwazi oludingekayo. Emgqeni othi “Ububanzi” faka izixhumanisi zendawo ukuze unikeze igama. Ukuze wenze lokhu, kufanele uqale uchofoze inkambu engenalutho eduze nombhalo othi "Range", bese ukhetha indawo oyifunayo eshidini ngokwalo. Ngemuva kokwenza konke ukukhohlisa, chofoza into ethi "OK".
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
8
  1. Ilungile! Sabela igama endaweni yedatha sisebenzisa "Isiphathi Segama".

Nakani! Ukusebenza "koMphathi Wegama" akugcini lapho. Umphathi akenzi nje kuphela ukudala amagama, kodwa futhi ikuvumela ukuthi uwaphathe, futhi uwasuse.

Inkinobho ethi “Shintsha…” ikuvumela ukuthi uhlele igama. Ukuze wenze lokhu, kufanele uqale ukhethe okufakile ohlwini, uchofoze kukho, bese uchofoza "Hlela ...". Ngemuva kokwenza zonke izenzo, umsebenzisi uzoyiswa efasiteleni elijwayelekile elithi "Nika igama", lapho uzokwazi ukuhlela amapharamitha akhona.

Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
9

Inkinobho ethi "Susa" ikuvumela ukuthi ususe okufakiwe. Ukuze wenze lokhu, khetha into oyifunayo, bese uchofoza into ethi "Susa".

Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
10

Ngemva kokuqeda lezi zinyathelo, kuzovela iwindi elincane lokuqinisekisa. Sichofoza "OK".

Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
11

Kubo bonke abanye, kukhona isihlungi esikhethekile Kumphathi Wegama. Isiza abasebenzisi ukuthi bahlele futhi bakhethe okufakiwe ohlwini lwezihloko. Ukusetshenziswa kwesihlungi kuyadingeka uma usebenza nenani elikhulu lezihloko.

Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
12

Ukuqamba i-Constant

Ukunikeza igama ngokungaguquki kuyadingeka uma linesipelingi esiyinkimbinkimbi noma ukusetshenziswa okuvamile. I-Walkthrough ibonakala kanje:

  1. Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi “Amagama achaziwe” bese sikhetha into ethi “Yabela igama” kuleli phaneli.
  2. Emgqeni othi "Igama" sifaka i-constant ngokwayo, isibonelo, I-LnPie;
  3. Emgqeni othi “Ububanzi” faka ifomula elandelayo: =3*LN(2*ROOT(PI()))*PI()^EXP(1)
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
13
  1. Ilungile! Sinike igama njalo.

Ukuqamba iseli nefomula

Ungakwazi futhi ukuqamba ifomula. I-Walkthrough ibonakala kanje:

  1. Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Yabela igama" kuleli phaneli.
  2. Emgqeni othi "Igama" sifaka, isibonelo, "Usuku_lweviki".
  3. Emgqeni othi "Isifunda" sishiya zonke izilungiselelo zingashintshiwe.
  4. Emgqeni othi “Range” faka ={1;2;3;4;5;6;7}.
  5. Chofoza into ethi "KULUNGILE".
  6. Ilungile! Manje, uma sikhetha amaseli ayisikhombisa ngokuvundlile, siyathayipha =Usuku lweviki emgqeni wamafomula bese ucindezela u-“CTRL + SHIFT + ENTER”, khona-ke indawo ekhethiwe izogcwaliswa ngezinombolo ukusuka kweyodwa kuye kweyisikhombisa.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
14

Ukuqamba Ibanga

Ukunikeza igama ububanzi bamaseli akunzima. I-Walkthrough ibonakala kanje:

  1. Sikhetha uhla olufunayo lwemikhakha.
  2. Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Dala kusukela ekukhetheni" kuleli phaneli.
  3. Sihlola ukuthi umaki wokuhlola uphambene yini nokuthi “Emugqeni ongenhla.”
  4. Sichofoza "OK".
  5. Ngosizo "lweMenenja Yegama" esele ijwayele, ungabheka ukulunga kwegama.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
15

Amathebula Okuqamba

Ungaphinda unikeze amagama kudatha yethebula. Lawa amathebula athuthukiswe ngosizo lokukhohlisa okwenziwa ngale ndlela elandelayo: Faka/Amathebula/Ithebula. Iphrosesa yesipredishithi ibanikeza amagama ajwayelekile (Ithebula1, Ithebula2, njalonjalo). Ungahlela isihloko usebenzisa I-Table Builder. Igama lethebula alikwazi ukususwa nganoma iyiphi indlela ngisho “Ngomphathi Wegama”. Igama likhona kuze kube ithebula ngokwalo liyawa. Ake sibheke isibonelo esincane senqubo yokusebenzisa igama lethebula:

  1. Isibonelo, sinepuleti elinamakholomu amabili: Umkhiqizo kanye Nezindleko. Ngaphandle kwetafula, qala ukufaka ifomula: =IMALI(Ithebula1[izindleko]).
  2. Ngesinye isikhathi kokufakwayo, isipredishithi sizokutshela ukuthi ukhethe igama lethebula.
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
16
  1. Ngemva kokungena =IMALI(Ithebula1[, Uhlelo luzokwazisa ukuthi ukhethe inkambu. Chofoza "Izindleko".
Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
17
  1. Ekugcineni, sithole inani kukholamu ethi “Izindleko”.

Imithetho ye-syntax yamagama

Igama kufanele lihambisane nemithetho ye-syntactic elandelayo:

  • Isiqalo singaba uhlamvu kuphela, i-slash, noma i-underscore. Izinombolo nezinye izinhlamvu ezikhethekile azivunyelwe.
  • Izikhala azikwazi ukusetshenziswa egameni. Zingashintshwa ngohlobo lwe-underscore.
  • Igama alikwazi ukuchazwa njengekheli leseli. Ngamanye amazwi, akwamukelekile ukusebenzisa u-“B3: C4” egameni.
  • Ubude besihloko esiphezulu yizinhlamvu ezingu-255.
  • Igama kufanele lihluke efayelini. Kubalulekile ukuqonda ukuthi izinhlamvu ezifanayo ezibhalwe ngosonhlamvukazi nabancane zichazwa njengezifanayo ngephrosesa yesipredishithi. Isibonelo, elithi “sawubona” nelithi “sawubona” yigama elifanayo.

Ukuthola nokuhlola amagama achazwe encwadini

Kunezindlela ezimbalwa zokuthola nokuhlola izihloko kudokhumenti ethile. Indlela yokuqala ihlanganisa ukusebenzisa "Isiphathi Segama" esitholakala esigabeni esithi "Amagama Achaziwe" sesigaba "Amafomula". Lapha ungakwazi ukubuka amanani, ukuphawula, nokuhlunga. Indlela yesibili ihlanganisa ukuqaliswa kwe-algorithm yezenzo ezilandelayo:

  1. Sithuthela esigabeni "Amafomula".
  2. Yiya kubhulokhi ethi "Amagama Achaziwe".
  3. Chofoza okuthi “Sebenzisa amafomula”.
  4. Chofoza okuthi “Faka Amagama”.
  5. Iwindi elinesihloko esithi "Faka Igama" livela esikrinini. Chofoza "Wonke Amagama". Isikrini sizobonisa zonke izihloko ezitholakalayo kudokhumenti kanye nobubanzi.

Indlela yesithathu ihilela ukusebenzisa ukhiye "F5". Ukucindezela lo khiye kwenza ithuluzi le-Jump lisebenze, elikuvumela ukuthi uzulele kumaseli aqanjwe amagama noma ububanzi bamaseli.

Igama Lobubanzi

Igama ngalinye linobubanzi balo. Indawo ingaba ishidi lokusebenza noma idokhumenti yonke iyonke. Le parameter isethwe efasiteleni elibizwa ngokuthi “Dala igama”, elitholakala kubhulokhi elithi “Amagama achaziwe” lesigaba “Amafomula”.

Indlela yokuqamba iseli kusipredishithi se-excel. Ungaliqamba kanjani ibanga ku-excel
18

Isiphetho

I-Excel inikeza abasebenzisi inani elikhulu lezinketho zokuqamba iseli noma uhla lwamaseli, ukuze wonke umuntu akwazi ukukhetha indlela elula kakhulu yokunikeza igama lapho esebenza kusipredishithi.

shiya impendulo