Ungayenza Kanjani Incwadi Yokuqala Ye-Capital Excel

Ezimweni eziningi, kuyadingeka ukuthi incwadi yokuqala etafuleni lethebula layisihloko (Capital). Uma umsebenzisi ekuqaleni wangena ngephutha ezinhlamvu ezincane noma wakopisha imininingwane evela komunye umthombo ku-Excel, lapho wonke amagama aqala ngenhlamvu encane, ungachitha isikhathi esikhulu kakhulu nesikhathi nesikhathi sokuletha ukubonakala kwetafula ku isimo esifunekayo. Kepha, mhlawumbe, i-Excel inamathuluzi akhethekile ongasebenzisa ngalo le nqubo? Ngempela, uhlelo lunomsebenzi wokushintsha izinhlamvu ezincane eziya enhlokodolobha. Ake sibheke ukuthi isebenza kanjani.

Inqubo yokuguqulwa kwencwadi yokuqala esihlokweni

Akufanele ulindele ukuthi ku-Excel kunenkinobho ehlukile ngokuchofoza okuthi, ungaguqula ngokuzenzakalelayo incwadi yentambo ibe yisihloko. Ukuze wenze lokhu, kuzodingeka usebenzise imisebenzi, futhi eziningana ngasikhathi sinye. Kodwa-ke, kunoma yikuphi, le ndlela ngenzalo izokhokhela izindleko zesikhashana ezizodingeka ukuze iguqulwe ngesandla.

Indlela 1: Ukubuyisela incwadi yokuqala esitokisini esihlokweni

Ukuxazulula umsebenzi, umsebenzi oyinhloko usetshenziselwa ukubuyisela esikhundleni, kanye nemisebenzi etshaliwe ye-oda lokuqala nelesibili ibhalisiwe ne-levsimv.

• Umsebenzi owubuyiseli uthatha indawo eyodwa noma ingxenye yomugqa kwabanye, ngokuya ngezimpikiswano ezibekiwe;
• Bhalisiwe - Wenza Izincwadi Ezinkulumo-dolobha, okungukuthi, inhloko-dolobha, esikudingayo;
• I-LevSimv - Ibuyisa inani elicacisiwe lezinhlamvu zombhalo othile esitokisini.

Okungukuthi, ngokusekelwe kule sethi yemisebenzi, ngosizo lwe-levsimv, sizobuyisela incwadi yokuqala esitokisini esibekiwe, sisebenzisa i-opharetha, bese sikwenza kube yi-accercase, bese siyibuyisela esikhundleni somsebenzi ukuze ungene esikhundleni sencwadi engezansi i-topsel.

Isifanekiso esijwayelekile salo msebenzi sizobukeka kanjena:

= Faka esikhundleni (i-Old_Text; I-Nach_Post; Inombolo_ Sign; I-LevSimv (Umbhalo; Inombolo yenombolo)))))))

Kepha kungcono ukubheka konke esibonelweni esithile. Ngakho-ke, sinethebula eligcwalisiwe lapho wonke amagama abhalwe ngencwadi encane. Sinophawu lokuqala esitokisini ngasinye ngamagama ukwenza isihloko. Iseli lokuqala elinesibongo linokuxhumanisa kwe-B4.

1. Kunoma iyiphi indawo yamahhala yaleli phepha noma kwelinye ishidi, bhala ifomula elilandelayo:

   = Faka esikhundleni (b4; 1; 1; kufanelekile (levsimv (b4; 1)))



2. Ukucubungula idatha bese ubona umphumela, chofoza inkinobho ethi Faka kwikhibhodi. Njengoba ukwazi ukubona, manje esitokisini, igama lokuqala liqala ngohlamvu olukhulu.



3. Siba isikhombisi ekhoneni elingezansi kwesobunxele selili ngefomula futhi sisebenzisa umaki wokugcwalisa Kopisha ifomula emangqamuzaneni aphansi. Kumele sikopishe kahle izikhundla zehle kakhulu ukuthi amaseli amangaki anezibongo anetafula lawo lomthombo wokwakhiwa.



4. Njengoba ubona, unikezwe lezo zethenjwa esihlotsheni sefomula, hhayi ngokuphelele, ukukopishwa kwenzeka ngokushintshana. Ngakho-ke, okuqukethwe isikhundla okulandelayo ngokulandelana kwezikhundla kuboniswa kumaseli aphansi, kodwa futhi nohlamvu olukhulu. Manje sidinga ukufaka umphumela etafuleni lomthombo. Khetha ububanzi ngamafomula. Ngichofoza inkinobho yegundane kwesokudla bese ngikhetha "Kopisha" kumenyu yokuqukethwe.



5. Ngemuva kwalokho, sigqamisa amaseli okuqala anamagama asetafuleni. Shayela imenyu yokuqukethwe ngokuchofoza inkinobho yegundane kwesokudla. Evikini le- "Insert Parameters", khetha into "amanani", amelelwa njengezimpawu ezinezinombolo.



6. Njengoba ubona, emva kwalokho, imininingwane esiyidingayo ifakwe ezikhundleni zomthombo wetafula. Ngasikhathi sinye, izinhlamvu ezincane emazwini okuqala zamaseli zathathelwa indawo ngenhla. Manje, hhayi ukonakalisa ukubukeka kweshidi, udinga ukususa amaseli ngamafomula. Kubaluleke kakhulu ukususa noma ngabe wenza ukuguqulwa eshidini elilodwa. Sigqamisa ububanzi obucacisiwe, chofoza kwesokudla-chofoza nakumenyu yokuqukethwe, yeka ukukhetha ku- "Delete ..." into.



7. Ebhokisini lengxoxo eliphansi elivelayo, usetha ukushintshwa kwesikhundla "somucu". Chofoza inkinobho ethi "KULUNGILE".

Emva kwalokho, imininingwane eyengeziwe izohlanzwa, futhi sizothola umphumela owuzuze: etafuleni ngalinye leseli, igama lokuqala liqala ngohlamvu olukhulu.

Indlela 2: Igama ngalinye ngohlamvu olukhulu

Kepha kunezimo lapho kunesidingo sokungenzi igama lokuqala kuphela esitokisini, kusukela ngohlamvu olukhulu, kodwa ngokuvamile, wonke amagama. Kulokhu, kunomsebenzi ohlukile, futhi kulula kakhulu kunangaphambili. Lesi sici sibizwa ngePropunt. I-syntax yayo ilula kakhulu:

= Lungiselela (ikheli)

Esibonelweni sethu, ukusetshenziswa kwayo kuzobukeka kanjena.

1. Khetha indawo yamahhala yeshidi. Chofoza isithonjana se- "Insert Function".



2. Ku-wizadi esebenzayo yemisebenzi, sifuna "Raknach". Njengoba sesithole leli gama, sivusa bese sichofoza inkinobho "KULUNGILE".



3. Iwindi lokuphikisana livuleka. Sibeka ikhesa enkambini "yombhalo". Khetha iseli lokuqala ngesibongo etafuleni lomthombo. Ngemuva kwekheli lakhe hit iwindi lokuphikisana, chofoza inkinobho ethi OK.

   

   Kukhona enye inketho yesenzo ngaphandle kokwethula imisebenzi wizard. Ukuze sikwenze lokhu, kufanele, njengasendleleni edlule, faka umsebenzi ngesandla esitokisini ngokuqoshwa kwemithombo yemithombo yokuxhumanisa. Kulokhu, lokhu kufakwa kuzoba nefomu elilandelayo:

   = Lungiselela (B4)

   Ngemuva kwalokho uzodinga ukucindezela inkinobho ethi Enter.

   Ukukhetha kwenketho ethile kuncike kumsebenzisi ngokuphelele. Kulabo basebenzisi abangasetshenziswanga ukugcina amafomula amaningi ahlukene ekhanda, ngokwemvelo, kulula ukwenza ngosizo lwe-wizard yemisebenzi. Ngasikhathi sinye, abanye bakholelwa ukuthi ngokushesha okukhulu kunokungena kwezandla opharetha.

4. Noma ngabe iyiphi inketho ekhethiwe, esitokisini sathola umphumela esiwudinga. Manje wonke amagama amasha esitokisini aqala ngohlamvu olukhulu. Njengoba okokugcina, kopisha ifomula kumaseli angezansi.



5. Ngemuva kwalelo kholisha umphumela usebenzisa imenyu yokuqukethwe.



6. Faka idatha ngokusebenzisa "amanani" entweni Faka amapharamitha etafuleni lomthombo.



7. Susa amanani aphakathi nendawo ngemenyu yokuqukethwe.



8. Ewindini elisha, qinisekisa ukususwa kwemigqa ngokusetha ukushintshwa kwesikhundla esifanele. Chofoza inkinobho ethi "Kulungile".

Ngemuva kwalokho, sizothola itafula lomthombo elingashintshiwe, kepha wonke amagama asemaseli aphathwe manje azopelwa ngohlamvu olukhulu.

Njengoba ubona, naphezu kweqiniso lokuthi ukuguqulwa kwesisindo kwezinhlamvu ezincane enhloko-dolobha kungenakwenzeka ukubizwa ngokuthi inqubo yokuqala, noma kunjalo, kulula kakhulu kunokushintsha okuningi kubo. Ama-algorithms angenhla avikele hhayi kuphela amandla omsebenzisi, kepha isikhathi esibaluleke kakhulu yisikhathi. Ngakho-ke, kuyinto efiselekayo ukuthi umsebenzisi waphakade we-Excel angasebenzisa la mathuluzi emsebenzini wawo.