Indlela yokushaja ngokushesha ifoni ku-Android

Kuhlelo lwe-Microsoft Office, umsebenzisi ngezinye izikhathi udinga ukufaka uphawu lokuhlola noma, njengoba le nto ishiwo ngenye indlela, ibhokisi lokuhlola (˅). Lokhu kungenziwa ngezinhloso ezehlukene: ukuphawula into, ukufaka izimo ezehlukene, njll. Ake sibone ukuthi singabhala kanjani i-Excel.

Ibhokisi lokuhlola

Kunezindlela eziningana zokuphawula i-Excel. Ukuze unqume ngesinqumo esikhethekile, udinga ukubeka masinyane lokho okudingayo ukuhlola ibhokisi lokhu: ukumaka nje noma ukuhlelwa kwezinqubo ezithile kanye nezikripthi?

Isifundo: Indlela yokufaka umkhawulo ku-Microsoft Word

Indlela 1: Faka ngokusebenzisa imenyu "I-Symbol"

Uma udinga ukusetha umklomelo wezinhloso ezibukwayo kuphela, ukuphawula into, ungamane usebenzise inkinobho ethi "Symbol" ekhonini.

1. Setha isikhombisi esitokisini lapho kufanele khona uphawu lokuhlola. Iya kuthebhu "Faka". Chofoza inkinobho "Uphawu"esitholakala ematheni amathuluzi "Izimpawu".



2. Iwindi livula ngohlu olukhulu lwezinto ezihlukile. Ungahambi noma yikuphi, kodwa hlala kuthebhu "Izimpawu". Ensimini "Ifonti" Noma yimaphi amafonti ajwayelekile angacaciswa: Arial, Verdana, Times roman entsha njll. Ukuze uthole ngokushesha umlingiswa oyifunayo ensimini "Setha" setha ipharamitha "Izincwadi zishintsha izikhala". Sifuna uphawu "˅". Khetha bese uchofoza inkinobho. Namathisela.

Emva kwalokho, into ekhethiwe izovela esitokisini esicacisiwe ngaphambili.

Ngendlela efanayo, ungabeka uphawu lokuhlola olujwayelekile ngokwamahlangothi angenakuphikisana noma uphawu lokuhlola ebhokisini lokuhlola (ibhokisi elincane elenzelwe ukuhlola ibhokisi lokuhlola). Kodwa ngenxa yalokhu, udinga ensimini "Ifonti" khombisa esikhundleni se-standard standard isitayela sezinhlamvu ezikhethekile I-Wingdings. Khona-ke kufanele uhambe phansi ohlwini lwabalingisi bese ukhetha uhlamvu olufunayo. Emva kwalokho, chofoza inkinobho Namathisela.

Uhlamvu olukhethiwe lufakwe esitokisini.

Indlela yesi-2: Izimpawu ezingezansi

Kukhona nabasebenzisi abangafani nezinhlamvu ezifanisiwe. Ngakho-ke, esikhundleni sokubeka uphawu lokuhlola olujwayelekile, mane uthayiphe uhlamvu oluvela kwikhibhodi "v" esakhiweni seNgisi. Ngezinye izikhathi lokhu kulungile, ngoba le nqubo ithatha isikhathi esincane kakhulu. Futhi ngaphandle, lokhu kufaka cishe kungabonakali.

Indlela 3: ukubeka uphawu lokuhlola ebhokisini lokuhlola

Kodwa ukuze ufake noma ungahloli isimo sokusebenzisa iskripthi, udinga ukwenza umsebenzi obanzi kakhulu. Okokuqala, kufanele ubeke ibhokisi lokuhlola. Leli bhokisi elincane, lapho ibhokisi lihlolwe khona. Ukuze ufake le nto, udinga ukuvula imenyu yonjiniyela, ekhutshaziwe ngokuzenzakalelayo ku-Excel.

1. Ukuba ngaphakathi kuthebhu "Ifayela", chofoza entweni "Izinketho"elisehlangothini lwesobunxele lwewindi langoku.



2. Iwindi yemingcele iqalisiwe. Yiya esigabeni Ukusethwa kweRibhoni. Ngesokudla ngakwesokudla kwewindi, setha uphawu lokuhlola (yilokho okudingayo ukufaka eshadini) ngokuphambene nepharamitha "Unjiniyela". Ngaphansi kwefasitela chofoza inkinobho. "Kulungile". Ngemva kwalokho ithebhu izovela ku-ribbon. "Unjiniyela".



3. Iya kuthebhu esanda kusebenzwa. "Unjiniyela". Ebhokisini lamathuluzi "Ukulawula" kwi-tape chofoza inkinobho Namathisela. Kulolu hlu oluvula eqenjini Ama-Form Controls khetha Ibhokisi lokuhlola.



4. Emva kwalokho, isikhombisi siphenduka sibe isiphambano. Chofoza kubo endaweni esetsheni lapho ufuna ukufaka ifomu.

   

   Ibhokisi lokuhlola elingenalutho livela.



5. Ukusetha ifulege kuyo, mane uchofoze kule nto futhi ibhokisi lokuhlola lizokhethwa.



6. Ukuze ususe ukubhaliswa okujwayelekile, okuyinto ezimweni eziningi akudingeki, chofoza inkinobho yesinxele segundane ku-element, ukhethe ukubhaliswa bese uchofoza inkinobho Susa. Esikhundleni selebuli esusiwe, ungafaka enye, noma ungafaka lutho, ushiye ibhokisi lokuhlola elingabizwanga igama. Lokhu kukubona komsebenzisi.



7. Uma kunesidingo sokwakha amabhokisi amaningi okuhlola, awukwazi ukudala eyodwa ehlukile kumugqa ngamunye, kodwa kopisha okuvele uqedile, okugcina isikhathi. Ukuze wenze lokhu, ngokushesha ukhethe ifomu ngokuchofoza igundane, bese ubamba inkinobho yesokunxele bese uhudula ifomu kuseli elifunayo. Ngaphandle kokuphonsa inkinobho yegundane, sibamba isihluthulelo Ctrlbese ukhulula inkinobho yegundane. Senza ukufana okufanayo namanye amaseli okudingayo ukufaka uphawu lokuhlola.

Indlela 4: Yakha ibhokisi lokuhlola ukwenza iskripthi

Ngenhla, safunda ukuphawula iseli ngezindlela ezihlukahlukene. Kodwa lesi sici singasetshenziselwa ukuboniswa okubukwayo kuphela, kodwa futhi nokuxazulula izinkinga ezithile. Ungabeka izimo ezehlukene uma ushintsha ibhokisi lokuhlola. Sizohlaziya ukuthi lokhu kusebenza kanjani kusibonelo sokushintsha umbala weseli.

1. Dala ibhokisi lokuhlola ngokuvumelana ne-algorithm echazwe ngendlela eyedlule, usebenzisa ithebhu yonjiniyela.
2. Chofoza entweni ngenkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Fometha into ...".



3. Iwindi yokufometha ivula. Iya kuthebhu "Lawula"uma bevulekile kwenye indawo. Ku-block parameter "Amanani" isimo samanje kufanele siboniswe. Okusho ukuthi, uma umkhaza okwamanje usethelwe, lo mshini kufanele ube sesikhundleni "Faka"uma kungenjalo - endaweni "Phuma". Isikhundla "Mixed" ayinconywa. Emva kwalokho chofoza kusithonjana eduze kwensimu "I-Cell Link".



4. Ifasitela lokufometha liyanciphisa, futhi kudingeka sikhethe iseli eshidi lapho ibhokisi lokuhlola lizohlotshaniswa khona nesheke. Emva kokukhethwa kwenziwa, chofoza kabusha inkinobho efanayo ngesimo sesithonjana, okukhulunywe ngakho ngenhla, ukubuyela efasiteleni lokufometha.



5. Ewindini lokufometha chofoza inkinobho. "Kulungile" ukuze ulondoloze izinguquko.

   

   Njengoba ubona, ngemuva kokwenza lezi zenzo esitokisini elihlobene, lapho ibhokisi lokuhlola lihloliwe, inani "IQINISO ". Uma ungawuqedi leli bhokisi, inani lizoboniswa. "FALSE". Ukuze sifeze umsebenzi wethu, okungukuthi, ukushintsha imibala egcwalayo, kuzodingeka uhlobanise lezi zimiso esitokisini ngesenzo esithile.



6. Khetha iseli exhunyiwe bese uchofoze kukho inkinobho yegundane kwesokudla, kwimenyu evuliwe khetha into "Fometha amaseli ...".



7. Iwindi yokufometha yeseli ivuleka. Kuthebhu "Inombolo" khetha into "Zonke amafomethi" ku-parameter block "Amafomu Amanani". Inkambu "Thayipha"okuyinto ephakathi nendawo yefasitela, sibhala inkulumo elandelayo ngaphandle kwamaphuzu: ";;;". Sicindezela inkinobho "Kulungile" phansi kwefasitela. Emva kwalezi zenzo, ukubhaliswa okubonakalayo "TRUE" kusukela kuseli selinyamalale, kodwa inani lihlala.



8. Khetha iseli elihambisanayo futhi uye kuthebhu. "Ikhaya". Sicindezela inkinobho "Ukufometha okunemibandela"esitholakala kwibhulogi yamathuluzi "Izitayela". Ohlu olubonakala luchofoza entweni "Dala umthetho ...".



9. Iwindi lokudala umthetho wokufometha uvula. Endaweni yayo engenhla udinga ukukhetha uhlobo lokubusa. Khetha into yokugcina kuhlu: "Sebenzisa ifomula ukunquma amaseli afomethiwe". Ensimini "Fometha amanani okuthi ifomula elilandelayo liyiqiniso" cacisa ikheli leseli elihambisanayo (lokhu kungenziwa ngesandla noma kumane ukhethe), futhi ngemuva kokuthi izixhumanisi zivele emgqeni, sengeza inkulumo kuso "= TRUE". Ukusetha umbala wokukhetha, chofoza inkinobho. "Fometha ...".



10. Iwindi yokufometha yeseli ivuleka. Khetha umbala ongathanda ukugcwalisa iseli uma uphawula. Sicindezela inkinobho "Kulungile".



11. Ukubuyela ewindini lokudala indalo, chofoza inkinobho. "Kulungile".

Manje, uma umkhawulo usuvuliwe, iseli elixhunyiwe lizodwetshwa kumbala okhethiwe.

Uma uphawu lwesheke lususiwe, iseli lizophenduka futhi limhlophe.

Isifundo: Ukufometha okunemibandela ku-Excel

Indlela 5: Beka uphawu ngokusebenzisa amathuluzi we-ActiveX

Umaki ungabuye usethe ngokusebenzisa amathuluzi we-ActiveX. Lesi sici sitholakala kuphela kumenyu yonjiniyela. Ngakho-ke, uma lethebhu ingavunyelwe, kufanele isebenze, njengoba kuchazwe ngenhla.

1. Iya kuthebhu "Unjiniyela". Chofoza inkinobho Namathiselaokufakwa eqenjini lamathuluzi "Ukulawula". Ewindini evuliwe ku-block "ActiveX Elements" khetha into Ibhokisi lokuhlola.



2. Njengesikhathi sangaphambilini, isikhombisi sithatha ifomu elikhethekile. Sichofoza endaweni lapho ifomu kufanele lifakwe khona.



3. Ukusetha uphawu kumabhokisi okuhlola odinga ukufaka izakhiwo zalento. Sichofoza kuso ngenkinobho yegundane efanele futhi kwimenyu evuliwe ukhethe into "Izakhiwo".



4. Kuwindi window evulekile evulekile, bheka i-parameter. "Value". Itholakala ngezansi. Ngokumelene naye sishintsha inani nge "Amanga" kuqhubeke "Yiqiniso". Senza lokhu ngokumane uthayiphe izinhlamvu kusuka kubhibhodi. Ngemuva kokuthi umsebenzi usuqedile, vala iwindi lempahla ngokuchofoza inkinobho yokuvala evamile ngesimo somgwaqo omhlophe esigcawini esifomvu ekhoneni eliphezulu elingakwesokudla kwewindi.

Ngemva kokwenza lezi zinyathelo, ibhokisi lokuhlola lizohlolwa.

Ukubhala ngokusebenzisa izilawuli ze-ActiveX kungenzeka ukusebenzisa amathuluzi we-VBA, okungukuthi, ngokubhala ama-macros. Yiqiniso, lokhu kuyinkimbinkimbi kakhulu kunokusebenzisa amathuluzi wokufometha okunemibandela. Ukutadisha lolu daba kuyisihloko esikhulu esihlukile. Ama-Macros angabhalwa imisebenzi ethile kuphela abasebenzisi abanolwazi lwezinhlelo futhi babe namakhono okusebenza ku-Excel kakhulu kakhulu kunezinga elivamile.

Ukuya kumhleli we-VBA, ongayibhalela i-macro, udinga ukuchofoza ku-element, esimweni sethu, ibhokisi lokuhlola elinenkinobho yegundane lesokunxele. Ngemuva kwalokho, i-window yomhleli izothunyelwa lapho ungabhala khona ikhodi yomsebenzi ozokwenziwa.

Isifundo: Indlela yokudala i-macro ku-Excel

Njengoba ungabona, kunezindlela eziningana zokuphawula i-Excel. Iyiphi indlela yokukhetha ixhomeke ngokuyinhloko ngenhloso yokufakwa. Uma nje ufuna ukumaka into, khona-ke akukho nhlobo ekufezeni umsebenzi kumenyu yonjiniyela, njengoba kuzothatha isikhathi esiningi. Kulula kakhulu ukusebenzisa uhlamvu lomlingisi noma nje uthayiphe incwadi yesiNgisi "v" ekhibhodi esikhundleni sokumaka isheke. Uma ufuna ukusebenzisa umklomelo ukuhlela ukwenziwa kwezimo ezithile eshadini, khona-ke kulokhu leli mgomo lingatholakala kuphela ngosizo lwamathuluzi wonjiniyela.