Daga cikin ayyuka daban-daban a cikin Excel da aka tsara don aiki tare da rubutu, mai sarrafawa ya yi fice don kayan aikinsa Dama. Aikinsa shine fitar da ƙayyadaddun lambobi daga tantanin halitta, ƙidaya daga ƙarshen. Bari muyi bayani dalla-dalla game da damar wannan ma'aikaci da kuma yadda ake amfani da shi don dalilai masu amfani da takamaiman misalai.
Operator PRIVSIMV
Aiki Dama cirewa daga takamaiman matakin akan takardar akan yawan haruffa akan dama wanda mai amfani da shi ya nuna. Nuna sakamakon karshe a cikin tantanin inda yake. Wannan aikin mallakar ɓangare ne na rubutun kalamai na Excel. Syntax kamar haka:
= SAURARA (rubutu; yawan haruffa)
Kamar yadda kake gani, aikin yana da hujjoji biyu ne kawai. Na farko "Rubutu" na iya ɗaukar hanyar magana ko dai hanyar rubutu ko kuma hanyar haɗi zuwa wani ɓangaren takardar a inda take. A farkon lamari, mai aiki zai fitar da takamammen adadin haruffa daga rubutun da aka ayyana azaman hujja. A magana ta biyu, aikin zai “datse” haruffan daga rubutun da ke cikin tantanin da aka ƙayyade.
Hujja ta biyu ita ce "Yawan haruffa" - yana da ƙimar lambobi wanda ke nuna daidai haruffa a cikin bayanin magana, suna ƙidaya ga dama, dole ne a nuna su a cikin tantanin halitta. Wannan magana ba na tilas bane. Idan kun ƙetare, ana ganin cewa daidai yake da ɗaya, ma'ana, madaidaicin alama ɗaya ta madaidaicin abubuwan da aka ƙayyade yana nunawa cikin tantanin halitta.
Misalin aikace-aikace
Yanzu bari mu kalli aikace-aikacen aikin Dama a kan wani kankare misali.
Misali zamu dauki jerin ma’aikatan kamfanin. A cikin farko shafi na wannan tebur sunayen mutane tare da lambobin waya. Muna buƙatar waɗannan lambobin ta amfani da aikin Dama saka a cikin wani shafi daban, wanda ake kira Lambar waya.
- Zaɓi wayar farko da aka ɓoye a cikin shafi. Lambar waya. Danna alamar. "Saka aikin", wanda yake gefen hagu na masarar dabara.
- Ana kunna Window Wizards na Aiki. Je zuwa rukuni "Rubutu". Daga jerin abubuwanda aka sanya masu suna PRAVSIMV. Latsa maballin. "Ok".
- Wurin Shaida Mai aiki Yana buɗewa Dama. Ya ƙunshi filaye guda biyu waɗanda suka dace da muhawara na aikin da aka ƙayyade. A fagen "Rubutu" kana buƙatar tantance hanyar haɗi zuwa allon farko na shafi "Suna", wanda ya ƙunshi sunan ma'aikaci da lambar waya. Za'a iya tantance adreshin da hannu, amma zamuyi shi daban. Sanya siginan kwamfuta a cikin filin "Rubutu", sannan danna hagu-danna akan tantanin wanda yakamata a shigar da ayyukan saiti. Bayan wannan, adireshin yana nunawa a cikin taga muhawara.
A fagen "Yawan haruffa" shigar da lamba daga keyboard "5". Lambar lambobi biyar ta kunshi lambar wayar kowane ma'aikaci. Bugu da kari, duk lambobin waya suna nan a karshen sel. Don haka, don nuna su dabam, muna buƙatar fito da haruffa guda biyar daga waɗannan sel a dama.
Bayan an shigar da bayanan na sama, danna maballin "Ok".
- Bayan wannan aikin, ana cire lambar wayar da aka ƙayyade a cikin ƙwayoyin da aka keɓe. Tabbas, gabatar da tsarin da aka nuna daban daban ga kowane mutum a cikin jerin darasi ne mai tsawo, amma zaka iya yin saurin sauri, shine kwafa. Don yin wannan, sanya siginan kwamfuta a cikin ƙananan kusurwar dama na sel, wanda ya riga ya ƙunshi tsarin Dama. A wannan yanayin, ana canza siginan kwamfuta zuwa alamar mai cikawa a cikin ƙananan ƙananan gicciye. Riƙe maɓallin linzamin kwamfuta na hagu ka ja siginar ƙasa zuwa ƙarshen teburin.
- Yanzu gaba daya shafi Lambar waya cike da dabi'u masu dacewa daga shafi "Suna".
- Amma, idan muka yi kokarin cire lambobin waya daga shafi "Suna"sannan zasu fara bacewa daga shafi Lambar waya. Wannan saboda duka waɗannan sassan suna da alaƙa da tsari. Domin cire wannan alakar, zabi dukkan abinda ke cikin shafin Lambar waya. Saika danna alamar Kwafawanda yake a kan kintinkiri a cikin shafin "Gida" a cikin rukunin kayan aiki Clipboard. Hakanan zaka iya buga gajerar hanyar faifai Ctrl + C.
- Ci gaba, ba tare da cire zaɓi daga ɓangaren da ke sama ba, danna kan shi tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu a cikin rukuni Saka Zabi zaɓi matsayi "Dabi'u".
- Bayan haka, duk bayanan da ke cikin shafi Lambar waya za a gabatar da shi azaman haruffa masu zaman kansu, kuma ba sakamakon lissafin aikin ba. Yanzu, idan ana so, zaku iya share lambobin waya daga shafi "Suna". Wannan ba zai shafi abin da ke cikin shafi ba. Lambar waya.
Darasi: Wizard ɗin Aiki a cikin Excel
Kamar yadda kake gani, damar da aikin ke bayarwa Damada takamaiman fa'idodi na amfani. Yin amfani da wannan afareta, zaku iya nuna adadin haruffa da ake so daga ƙayyadaddun sel a yankin da aka yiwa alama, ƙidaya daga ƙarshen, wato, zuwa dama. Wannan mai aiki zai zama da amfani musamman idan kuna buƙatar cire adadin lambobi guda ɗaya daga ƙarshen a cikin kewayon sel mai yawa. Yin amfani da dabara a ƙarƙashin irin wannan yanayi zai sami adadi mai yawa na mai amfani.
