Yadda ake kirga adadin kalmomi a cikin tantanin halitta na Excel

A cikin Microsoft Office Excel, zaku iya ƙidaya adadin abubuwan da aka rubuta a cikin sel na tsararrun tebur. Don wannan, yawanci ana amfani da dabara mai sauƙi. Za a gabatar da cikakken bayani game da wannan batu a cikin wannan labarin.

Hanyoyin kirga kalmomi a cikin sel na Excel

Akwai hanyoyi gama gari da yawa don cim ma wani aiki da aka bayar, kowannensu yana buƙatar zurfafa nazari don fahimta sosai. Na gaba, za mu yi magana game da mafi sauƙi kuma mafi tasiri daga cikinsu.

Hanyar 1: lissafin hannu

Wannan hanyar ba ta dace da MS Excel ba, ba tare da la'akari da sigar sa ba, saboda. wannan shirin yana amfani da kayan aikin lissafin atomatik. Duk da haka, yana da kyau a yi la'akari da asusun hannu a cikin tsarin labarin. Don aiwatar da shi ya zama dole:

1. Shirya tsararrun tebur na asali.
2. Zaɓi ta danna maɓallin linzamin kwamfuta na hagu tantanin halitta wanda kake son kirga kalmomin a ciki.
3. Kirga abubuwan da aka tattara.
4. Don kada ku rasa lokacinku, zaku iya kwafin abubuwan da ke cikin tantanin halitta, wanda aka nuna gaba ɗaya a cikin layin don shigar da dabaru, sannan ku liƙa shi cikin filin aiki na wani rukunin yanar gizo na musamman don kirga adadin haruffa da sauri.

Kula! Ƙididdiga kalmomi a cikin ƙwayoyin Excel da hannu ba su da amfani idan tebur ya ƙunshi bayanai da yawa.

Hanyar 2: Amfani da Microsoft Office Word

A cikin editan rubutu, ana kirga duk kalmomin da aka buga ta atomatik kuma ana nuna lambar su akan allo. Don amfani da wannan hanyar, mai amfani da Excel zai buƙaci:

1. Hana LMB kalmomin da ke cikin tantanin halitta don ƙara ƙididdige adadin su.
2. Canja maɓallin madannai zuwa shimfidar Ingilishi kuma a lokaci guda ka riƙe maɓallin "Ctrl + C" a lokaci guda don kwafe haruffan da aka zaɓa zuwa allon allo.
3. Bude editan rubutu MS Word.
4. Sanya siginan linzamin kwamfuta a farkon filin aiki na shirin kuma danna maballin "Ctrl + V" daga maballin.
5. Duba sakamakon. Abubuwan da aka kwafi daga Excel yakamata a liƙa su cikin Kalma ba tare da wata matsala ba.
6. Kula da ƙananan kusurwar hagu na takardar aikin shirin. Dakin aikin zai nuna adadin kalmomin da ake bugawa a halin yanzu.

Ƙarin Bayani! Excel ba shi da kayan aiki don kirga kalmomi a cikin sel, saboda ba a tsara wannan software don yin aiki da rubutu ba.

Hanyar 3: Aiwatar da Aiki na Musamman

Wannan ita ce hanya mafi kyau kuma mafi sauri don kirga kalmomi a cikin sel, jimlolin Excel. Don gano adadin abubuwan da ake buƙata da sauri, mai amfani zai buƙaci ɗaukar matakai da yawa bisa ga algorithm:

1. Zaɓi kowane tantanin halitta mara komai akan takardar aikin shirin. Za a nuna sakamakon lissafin a cikinsa a nan gaba.
2. Sanya siginan linzamin kwamfuta a cikin layi don shigar da dabaru a saman shirin kuma rubuta magana mai zuwa daga madannai: "= TSAYIN( KYAUTA (shaida))-DLSTR(MASALLATA(shaida;» ";"))) +1".
3. Maimakon kalmar "Hujja", an nuna adireshin tantanin halitta wanda aka yi lissafin.

4. Bayan rubuta dabarar, dole ne ka danna "Enter" don tabbatar da ita.
5. Duba sakamakon. Tantanin da aka zaɓa a baya zai ƙunshi lamba daidai da adadin kalmomin abin da ake tambaya.

Yadda ake kirga adadin haruffa a cikin tantanin halitta na Excel

Wani lokaci masu amfani da Excel suna buƙatar ƙidaya adadin haruffa a cikin takamaiman tantanin halitta na tsararrun tebur. Ƙididdigar alamomi ya fi sauƙi fiye da kalmomi. Akwai hanyoyi da yawa don wannan dalili, wanda za a tattauna a kasa.

Hanyar 1: lissafin hannu

Wannan hanyar tana kama da hanyar da ta gabata da aka tattauna a sashin farko na labarin. Don aiwatar da shi, mai amfani zai buƙaci zaɓar takamaiman tantanin halitta na farantin kuma ya ƙidaya kowane hali a ciki.

Muhimmin! Ana iya samun haruffa da yawa a cikin sel na tebur na Microsoft Office Excel, wanda zai ɗauki lokaci mai yawa don ƙididdigewa da hannu. Don haka, kirgawa da hannu yana da dacewa idan yazo da ƙaramin faranti.

Hanyar 2: Amfani da Aiki don ƙidaya Tsawon igiya

Excel yana da tsari na musamman wanda ke ba ka damar ƙidaya abubuwan da ke cikin jere. Don amfani da shi, kuna buƙatar yin matakai masu sauƙi bisa ga umarnin:

1. Tare da maɓallin hagu na manipulator, zaɓi layin mara komai, tantanin halitta wanda sakamakon ƙidayar haruffa za a nuna.
2. Matsar da siginan linzamin kwamfuta zuwa layin don shigar da dabaru a saman taga shirin kuma rubuta kalmar: "= DLSTR (hujja)». Maimakon gardama, ana nuna adireshin takamaiman tantanin halitta, inda kake buƙatar gano adadin haruffa.

3. Danna "Shigar" lokacin da aka rubuta dabara don tabbatar da aiwatar da shi.
4. Duba sakamakon. Ƙimar da aka ƙayyade a baya zai nuna ƙimar lamba daidai.

Hanyar 3: Amfani da shafuka na musamman akan Intanet

Kuna iya zuwa hanya mafi rikitarwa don ƙidaya adadin haruffa a cikin sel na tsararrun tebur na Excel. Ya ƙunshi ayyuka masu zuwa bisa ga algorithm:

1. Hakazalika, zaɓi tantanin halitta da ake so na array na tebur tare da LMB kuma matsar da siginan linzamin kwamfuta zuwa layin don shigar da dabaru a saman shirin.
2. Yanzu, tare da maɓalli iri ɗaya, kuna buƙatar zaɓar abin da ke cikin tantanin halitta a cikin layin shigarwa.
3. Danna-dama akan kowane yanki na maganganun da aka zaɓa kuma a cikin nau'in mahallin mahallin danna kan zaɓin "Kwafi".
4. Shiga cikin mai bincike akan PC kuma je zuwa kowane rukunin yanar gizo don ƙidaya adadin haruffa.
5. Danna-dama akan filin aiki na rukunin yanar gizon kuma zaɓi zaɓi "Saka".
6. Ka san kanka da ƙimar da aka samu. Bayan yin gyare-gyaren da ke sama, shafin zai nuna duk bayanai game da tsawon rubutun.

Kula! A irin waɗannan rukunin yanar gizon, kuna iya ƙidaya adadin jimlolin da ke cikin ƙayyadadden rubutu.

Kammalawa

Don haka, a cikin Excel, zaku iya gano bayanai da sauri game da adadin kalmomi a cikin sel ɗin da ake so na tsararrun tebur. An yi bayanin yadda ake yin haka dalla-dalla a sama.