Okuqukethwe
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:
- Sikhetha ububanzi noma ingxenye eyodwa yethebula.
- Emgqeni wamagama sishayela egameni elidingekayo lendawo ekhethiwe. Lapho ufaka, kufanele ucabangele imithetho yokunikeza igama. Ngemuva kokwenza konke ukukhohlisa, cindezela inkinobho ethi "Enter" kukhibhodi.
- 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.
Imenyu yokuqukethwe iyingxenye eyisizayo yokusebenzisa ukuqamba amaseli. I-Walkthrough ibonakala kanje:
- Sikhetha indawo esihlela ukuyiqamba igama. Sichofoza i-RMB. Imenyu yokuqukethwe encane ivela esibukweni. Sithola into ethi “Nikeza igama…” bese uchofoza kuyo.
- Kuvele iwindi elincane elisha esikrinini elibizwa ngokuthi “Ukudala Igama”. Emgqeni othi "Igama" kufanele ufake igama ofuna ukulisetha indawo ekhethiwe.
- 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.
- Umugqa othi "Qaphela" uqukethe amanothi ahluke ngokuphelele achaza indawo yedatha ekhethiwe. Inkambu ingashiywa ingenalutho njengoba lesi sakhiwo singabhekwa njengesidingo.
- Emgqeni othi "Ububanzi", faka izixhumanisi zendawo yedatha esiwabela yona igama. Izixhumanisi zobubanzi obukhethiwe ekuqaleni zibekwe kulo mugqa ngokuzenzakalelayo.
- Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".
- Ilungile! Sinikeze igama ohlwini lwedatha sisebenzisa imenyu yokuqukethwe kwespredishithi se-Excel.
Ngosizo lwamathuluzi akhethekile atholakala kubhebhoni, ungacacisa igama lendawo yedatha. I-Walkthrough ibonakala kanje:
- Sikhetha indawo esihlela ukuyiqamba igama. Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Yabela igama" kuleli phaneli.
- Isikrini sibonise iwindi elincane elibizwa ngokuthi "Dala igama", esilazi endleleni yangaphambilini. Senza konke ukukhohlisa okufanayo njengasesibonelweni esicatshangelwe ngaphambili. Chofoza "KULUNGILE".
- 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:
- Sithuthela esigabeni "Amafomula". Thola ibhulokhi yomyalo ethi “Amagama Achaziwe” bese uchofoza into ethi “Isiphathi Segama” kuleli phaneli.
- Iwindi elincane elithi “Isiphathi Segama…” liboniswe esibukweni. Ukuze wengeze igama elisha lendawo yedatha, chofoza into ethi "Dala ...".
- 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".
- 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.
Inkinobho ethi "Susa" ikuvumela ukuthi ususe okufakiwe. Ukuze wenze lokhu, khetha into oyifunayo, bese uchofoza into ethi "Susa".
Ngemva kokuqeda lezi zinyathelo, kuzovela iwindi elincane lokuqinisekisa. Sichofoza "OK".
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.
Ukuqamba i-Constant
Ukunikeza igama ngokungaguquki kuyadingeka uma linesipelingi esiyinkimbinkimbi noma ukusetshenziswa okuvamile. I-Walkthrough ibonakala kanje:
- Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi “Amagama achaziwe” bese sikhetha into ethi “Yabela igama” kuleli phaneli.
- Emgqeni othi "Igama" sifaka i-constant ngokwayo, isibonelo, I-LnPie;
- Emgqeni othi “Ububanzi” faka ifomula elandelayo: =3*LN(2*ROOT(PI()))*PI()^EXP(1)
- Ilungile! Sinike igama njalo.
Ukuqamba iseli nefomula
Ungakwazi futhi ukuqamba ifomula. I-Walkthrough ibonakala kanje:
- Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Yabela igama" kuleli phaneli.
- Emgqeni othi "Igama" sifaka, isibonelo, "Usuku_lweviki".
- Emgqeni othi "Isifunda" sishiya zonke izilungiselelo zingashintshiwe.
- Emgqeni othi “Range” faka ={1;2;3;4;5;6;7}.
- Chofoza into ethi "KULUNGILE".
- 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.
Ukuqamba Ibanga
Ukunikeza igama ububanzi bamaseli akunzima. I-Walkthrough ibonakala kanje:
- Sikhetha uhla olufunayo lwemikhakha.
- Sithuthela esigabeni "Amafomula". Sithola ibhulokhi yemiyalo ethi "Amagama achaziwe" bese uchofoza into ethi "Dala kusukela ekukhetheni" kuleli phaneli.
- Sihlola ukuthi umaki wokuhlola uphambene yini nokuthi “Emugqeni ongenhla.”
- Sichofoza "OK".
- Ngosizo "lweMenenja Yegama" esele ijwayele, ungabheka ukulunga kwegama.
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:
- Isibonelo, sinepuleti elinamakholomu amabili: Umkhiqizo kanye Nezindleko. Ngaphandle kwetafula, qala ukufaka ifomula: =IMALI(Ithebula1[izindleko]).
- Ngesinye isikhathi kokufakwayo, isipredishithi sizokutshela ukuthi ukhethe igama lethebula.
- Ngemva kokungena =IMALI(Ithebula1[, Uhlelo luzokwazisa ukuthi ukhethe inkambu. Chofoza "Izindleko".
- 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:
- Sithuthela esigabeni "Amafomula".
- Yiya kubhulokhi ethi "Amagama Achaziwe".
- Chofoza okuthi “Sebenzisa amafomula”.
- Chofoza okuthi “Faka Amagama”.
- 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”.
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.