Duba wuri a Microsoft Excel

A cikin shirin Microsoft Office, mai amfani wani lokaci yana buƙatar saka alamar ko, kamar yadda ake kira sashin daban, alamar alama (˅). Ana iya yin wannan don dalilai daban-daban: kawai don yiwa alama alama, don haɗa abubuwa dabam-dabam, da sauransu. Bari mu gano yadda za a duba akwatin a cikin Excel.

Akwatin

Akwai hanyoyi da yawa don bincika akwatin a cikin Excel. Don yanke shawara game da takamaiman zaɓi, kuna buƙatar tsayar da abin da kuke buƙatar duba akwatin don: kawai don alama ko don shirya wasu matakai da rubutun?

Darasi: Yadda za'a bincika Microsoft Kalmar

Hanyar 1: Saka ta menu na Alamar

Idan kuna buƙatar duba akwatin kawai don dalilai na gani, don yiwa alama alama, to, zaku iya amfani da maɓallin "Symbol" da ke kan kintinkiri.

1. Mun sanya siginan kwamfuta a cikin tantanin inda yakamata yakamata a sami alamar mai siye. Je zuwa shafin Saka bayanai. Latsa maballin "Alamar"located a cikin toshe kayan aiki "Alamu".



2. Ana buɗe wata taga tare da manyan jerin abubuwan abubuwa daban-daban. Ba za mu je ko'ina ba, amma mu kasance a cikin shafin "Alamu". A fagen Harafi kowane daidaitaccen rubutu na iya tantancewa: Arial, Verdana, Lokaci sabon roman da sauransu Don sauri sami ɗan da ake so a cikin filin "Kafa" saita siga "Haruffa suna canza sarari". Muna neman alama "˅". Zaɓi shi kuma danna maballin. Manna.

Bayan haka, abin da aka zaɓa zai bayyana a cikin tantanin da aka ƙayyade.

Haka kuma, zaku iya saka abubuwanda aka fi sani dasu tare da bangarorin da basu dace ba ko alamar a akwati (karamin akwatin da aka shirya musamman domin saita akwatin). Amma don wannan, kuna buƙatar filin Harafi saka takamaiman rubutu na rubutu maimakon daidaitaccen sigar Abubuwa. Sannan yakamata ku shiga ƙasan jerin haruffa ku zaɓi halin da ake so. Bayan haka, danna maɓallin Manna.

An saka harafin da aka zaɓa a cikin tantanin halitta.

Hanyar 2: Canji na Halittu

Hakanan akwai masu amfani waɗanda ba a saita su daidai da haruffa daidai. Sabili da haka, maimakon saita daidaitaccen alamar, suna rubuta harafi kawai daga maballin "v" a cikin Turanci layout. Wani lokaci yana da hujja, tunda wannan tsari yana ɗaukar lokaci kaɗan. A waje kuma wannan canji kusan ba zai yiwu ba.

Hanyar 3: alamar akwati

Amma domin shigarwa ko matsayin sanya ido don gudanar da wasu rubutun, kuna buƙatar yin ƙarin aiki mai rikitarwa. Da farko, ya kamata ka shigar da akwati. Wannan itace karamar akwatin inda aka sanya akwatin. Don saka wannan abun, kuna buƙatar kunna menu na haɓakawa, wanda aka kashe ta tsohuwa a cikin Excel.

1. Kasancewa a cikin shafin Fayilolidanna kan kayan "Zaɓuɓɓuka", wanda yake gefen hagu na taga na yanzu.



2. Zaɓuɓɓukan taga yana farawa. Je zuwa sashin Saitin Ribbon. A hannun dama na taga, duba akwatin (wannan shine ainihin abin da muke buƙatar kafawa akan takarda) akasi "Mai Haɓakawa". A cikin ƙananan ɓangaren taga, danna maballin "Ok". Bayan haka, shafin zai bayyana a kan kintinkiri "Mai Haɓakawa".



3. Je zuwa shafin da aka kunna "Mai Haɓakawa". A cikin akwatin kayan aiki "Gudanarwa" a kan tef danna kan maɓallin Manna. A lissafin da yake buɗe a cikin rukunin "Tsarin sarrafawa" zabi Akwatin.



4. Bayan wannan, siginan kwamfuta ya juya ya zama gicciye. Danna kan yankin akan takardar inda kake son liƙa fam ɗin.

   

   Akwatin akwati mai wofi ya bayyana.



5. Don saita tuta a ciki, kawai kuna buƙatar danna wannan abu kuma za'a saita tutar.



6. Don cire daidaitaccen rubutun, wanda a mafi yawan lokuta ba a buƙatar, danna-hagu a kan kashi, zaɓi rubutun kuma danna maɓallin. Share. Madadin share taken, zaka iya saka wani, ko kuma ba za ka iya saka komai ba, barin akwati ba tare da suna ba. Wannan shi ne a tunanin mai amfani.



7. Idan akwai buƙatar ƙirƙirar akwati masu yawa, to, ba za ku iya ƙirƙirar raba layi don kowane layi ba, amma kwafa wanda aka gama, wanda zai adana lokaci mai yawa. Don yin wannan, nan da nan zaɓi hanyar tare da danna maɓallin linzamin kwamfuta, sannan ka riƙe maɓallin hagu ka kuma ja fom ɗin a ɗakin da ake so. Ba tare da sauke maɓallin linzamin kwamfuta ba, riƙe maɓallin riƙe ƙasa Ctrlsannan kuma ka saki maballin linzamin kwamfuta. Mun gudanar da irin wannan aiki tare da wasu ƙwayoyin jikin da kuke buƙatar saka alamar.

Hanyar 4: ƙirƙiri akwati domin aiwatar da rubutun

A sama, mun koyi yadda ake duba akwatin ta hanyoyi daban-daban. Amma wannan damar ana iya amfani dashi ba kawai don nunin gani ba, har ma don magance takamaiman matsaloli. Kuna iya saita shimfidar yanayi daban-daban lokacin sauya akwatin a cikin akwati. Zamuyi nazarin yadda wannan ke aiki tare da misalin canza launin sel.

1. Muna ƙirƙirar akwati bisa algorithm da aka bayyana a cikin hanyar da ta gabata ta amfani da shafin haɓaka.
2. Mun danna kan kashi tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu, zaɓi "Tsarin Object ...".



3. Tsarin tsarawa yana buɗe. Je zuwa shafin "Gudanarwa"idan aka bude shi wani wuri. A cikin toshe na sigogi "Dabi'u" Matsayi na yanzu ya kamata a nuna. Wato, idan an sanya alamar rajistar a halin yanzu, to, canjin ya kamata ya kasance cikin matsayi "An sanya"in ba haka ba - a matsayi "Shot". Matsayi Cakuda ba da shawarar bayyanar ba. Bayan haka, danna kan gunkin kusa da filin Hanyar Sadarwa.



4. Windowaramin window ɗin yana raguwa, kuma muna buƙatar zaɓar sel akan takardar wanda akwatin zai kasance tare da alamomin alamar. Bayan an yi zaɓi, danna maɓallin ɗaya ɗin kuma a cikin hanyar gunki, wanda aka tattauna a sama, don komawa zuwa taga tsarawa.



5. A cikin taga tsara, danna kan maɓallin "Ok" domin adana canje-canje.

   

   Kamar yadda kake gani, bayan aiwatar da waɗannan ayyuka a cikin haɗin da aka haɗa, lokacin da aka duba akwatin, to darajar "GASKIYA ". Idan kun lura da ƙimar za a nuna shi KARYA. Don aiwatar da aikinmu, shine don canza launuka masu cike, muna buƙatar haɗa waɗannan ƙimar a cikin tantanin halitta tare da takamaiman aiki.



6. Zaɓi tantanin da aka haɗa kuma danna shi tare da maɓallin linzamin kwamfuta na dama, a menu wanda yake buɗe, zaɓi abu "Tsarin kwayar halitta ...".



7. Tsarin tantanin halitta yana buɗewa. A cikin shafin "Lambar" zaɓi abu "Duk fayiloli" a cikin toshe siga "Lambobin adadi". Filin "Nau'in", wanda yana tsakiyar ɓangaren taga, muna rubuta wannan magana ba tare da ambato ba: ";;;". Latsa maballin "Ok" a kasan taga. Bayan waɗannan ayyukan, taken da ake iya gani "GASKIYA" ya ɓace daga cikin tantanin halitta, amma darajar ta rage.



8. Zaɓi sake haɗin da aka haɗa kuma je zuwa shafin. "Gida". Latsa maballin Tsarin Yanayiwanda yake a cikin shinge na kayan aiki Salo. A lissafin da ya bayyana, danna abu "Airƙiri doka ...".



9. Tagan don ƙirƙirar tsarin tsarawa yana buɗe. A cikin sashi na sama, kuna buƙatar zaɓar nau'in mulkin. Zaɓi abu na ƙarshe a cikin jerin: "Yi amfani da dabara don ayyana sel da aka tsara". A fagen "Tsarin dabi'u wanda tsari mai zuwa na gaskiya ne" saka adireshin tantanin halitta da aka haɗa (ana iya yin wannan ta hannu ko a sauƙaƙe ta zaɓin shi), kuma bayan daidaitawar sun bayyana a layin, muna ƙara magana "= GASKIYA". Don saita launi mai haske, danna maballin "Tsarin ...".



10. Tsarin tantanin halitta yana buɗewa. Zaɓi launin da zaku so cika shi a cikin wayar lokacin da aka kunna tambarin. Latsa maballin "Ok".



11. Komawa taga taga halitta, danna maballin "Ok".

Yanzu, idan an kunna alamar, za a fentin tantanin da ke hade a cikin launi da aka zaɓa.

Idan an cire alamar, alƙalin zai sake zama fari kuma.

Darasi: Tsarin yanayi a cikin Excel

Hanyar 5: alamar tambaya ta amfani da kayan aikin ActiveX

Hakanan za'a iya saita alamar amfani ta amfani da kayan aikin ActiveX. Wannan fasalin yana samuwa ne kawai ta menu na masu haɓaka. Saboda haka, idan ba a kunna wannan shafin ba, to ya kamata ku kunna shi, kamar yadda aka bayyana a sama.

1. Je zuwa shafin "Mai Haɓakawa". Latsa maballin Mannawanda ke cikin rukunin kayan aiki "Gudanarwa". A cikin taga yana buɗewa, a cikin toshe Gudanar da ActiveX zaɓi abu Duba akwatin.



2. Kamar yadda a cikin lokacin da ya gabata, siginan kwamfuta yana ɗaukar hoto na musamman. Mun danna kan wurin takardar inda ya kamata a sanya fom ɗin.



3. Don saita alamar a cikin akwati, kuna buƙatar shigar da kaddarorin wannan abun. Mun danna shi tare da maɓallin linzamin kwamfuta na dama kuma a cikin menu wanda ya buɗe, zaɓi abu "Bayanai".



4. A cikin taga abubuwan da ke buɗewa, bincika siga "Darajar". Tana can kasan. M da shi, za mu canza darajar da "Karya" a kunne "Gaskiya". Muna yin wannan ta hanyar tuki haruffa kawai daga keyboard. Bayan an gama aikin, rufe taga kaddarorin ta danna maɓallin madaidaiciyar maballin a cikin hanyar farin gicciye a cikin wani murabbaren jan a cikin kusurwar dama na sama na taga.

Bayan kammala waɗannan matakan, za a saita alama a cikin akwati.

Yin rubutun ta amfani da sarrafawar ActiveX zai yiwu ta amfani da kayan aikin VBA, wato, ta hanyar rubuta macros. Tabbas, wannan yafi rikitarwa fiye da amfani da kayan aikin tsara yanayin. Nazarin wannan batun wani babban al'amari ne daban. Macros don takamaiman ayyuka za a iya rubuta shi ta hanyar masu amfani da ilimin shirye-shirye da ƙwarewa a cikin Excel waɗanda suka fi ƙarfin matsakaici.

Don zuwa edita na VBA, wanda zaku iya yin rikodin macro, kuna buƙatar danna kan ɓangaren, a cikin yanayin akwatin mu, tare da maɓallin linzamin kwamfuta na hagu. Bayan wannan, za a ƙaddamar da taga edita wanda zaku iya rubuta lamba don aikin da za a yi.

Darasi: Yadda ake ƙirƙirar macro a cikin Excel

Kamar yadda kake gani, akwai hanyoyi da yawa don bincika akwatin a Excel. Wanne hanyar da za a zaɓa ya dogara da fifikon burin shigarwa. Idan kawai kuna son alamar abu, to ba ma'ana don kammala aikin ta hanyar menu na mai haɓaka, saboda wannan zai ɗauki lokaci mai yawa. Yana da sauƙin amfani da shigar da haruffa ko kawai rubuta harafin Turanci “v” a kan allo maimakon alamar alamar. Idan kuna son yin amfani da alamar ƙira don tsara aiwatar da takamaiman rubutun a kan takardar aiki, to a wannan yanayin ana iya cimma wannan burin kawai tare da taimakon kayan aikin haɓaka.