Yin amfani da ma'amala a cikin Microsoft Excel

Akwai halin da ake ciki lokacin da yawan abubuwan da aka sani kuna buƙatar neman sakamako na tsaka-tsaki. A cikin ilimin lissafi, wannan ana kiransa ma'anar tsaka-tsaki. A cikin Excel, ana iya amfani da wannan hanyar duka don bayanan ƙirar kuma don zane. Zamu bincika kowane ɗayan waɗannan hanyoyin.

Yin amfani da ma'amala

Babban yanayin da za'a sanya amfani dashi shine cewa ƙimar da ake so dole ne ya kasance a cikin bayanan bayanan, kuma kada ku ƙetare iyakarta. Misali, idan muna da tsarin sawa na 15, 21, da 29, to idan muka sami aiki don hujja 25, zamu iya amfani da ma'amala. Kuma bincika ƙimar da ta dace don hujja 30, ba ya nan. Wannan shine babban bambanci tsakanin wannan hanyar da karin magana.

Hanyar 1: tsinkaye don bayanan yanki

Da farko dai, yi la'akari da aikace-aikacen ma'amala don bayanan da ke cikin tebur. Misali, mun dauki matakai da hujjoji masu dacewa da kuma daidaitawa, alakar da za'a iya bayyana ta ta hanyar daidaituwa. Ana sanya waɗannan bayanan a cikin tebur da ke ƙasa. Muna buƙatar samun aikin da ya dace don gardamar 28. Hanya mafi sauki don yin wannan shine tare da mai aiki. KYAUTA.

1. Zaɓi kowane ɓoyayyen tantanin halitta akan takardar inda mai amfani ya shirya don nuna sakamakon ayyukan da aka ɗauka. Bayan haka, danna maballin. "Saka aikin", wanda yake gefen hagu na masarar dabara.



2. Ana kunna taga Wizards na Aiki. A cikin rukuni "Ilmin lissafi" ko "Cikakken jerin haruffa" neman suna "KYAUTA". Bayan an samo ƙimar daidai, zaɓi shi kuma danna maɓallin "Ok".



3. Farashin muhawara na aiki yana farawa KYAUTA. Yana da filaye uku:
   • X;
   • Sanannan dabi'u;
   • Sanin x uesimar.

   A farkon fagen, muna buƙatar kawai da hannu shigar da ƙimar muhawara daga maballin, abin da ya kamata a samo. A cikin lamarinmu, wannan 28.

   A fagen Sanannan dabi'u kuna buƙatar ƙididdige abubuwan daidaitawa na teburin wanda ya ƙunshi dabi'u na aikin. Ana iya yin wannan da hannu, amma yafi sauƙi kuma mafi dacewa don saita siginar kwamfuta a cikin filin kuma zaɓi yankin da ya dace akan takardar.

   Hakanan an saita su a filin Sanin x uesimar kewayon tsara tare da muhawara.

   Bayan an shigar da dukkan mahimman bayanan, danna kan maɓallin "Ok".



4. Za'a nuna ƙimar aikin da ake so a cikin tantanin da muka zaba a farkon matakin wannan hanyar. Sakamakon shine lamba 176. Zai zama sakamakon hanyar shiga tsakani.

Darasi: Mayan Maɗaukaki

Hanyar 2: haɗa baki da zane ta amfani da saitunan sa

Hakanan za'a iya amfani da hanyar tsaka-tsakin lokacin amfani da ayyukan. Yana dacewa idan tebur akan abin da aka gina jadawalin baya nuna ƙimar aikin da ya dace da ɗayan gardandami, kamar yadda yake a hoton da ke ƙasa.

1. Mun shirya amfani da hanyar da aka saba. Wannan shine, kasancewa a cikin shafin Saka bayanai, zaɓi kewayon tebur akan abin da za a yi aikin ginin. Danna alamar Chartsanya a cikin toshe kayan aiki Charts. Daga jerin jadawalai waɗanda suka bayyana, za mu zaɓi ɗaya wanda muke la'akari da dacewa a wannan yanayin.



2. Kamar yadda kake gani, an tsara jadawalin, amma ba daidai bane a irin tsarin da muke buƙata. Da fari dai, an karye, saboda magana ɗaya ba a sami aikin da ya dace ba. Abu na biyu, akwai ƙarin layin akan sa X, wanda a wannan yanayin ba a buƙata, kuma a kan tsinkaye na kwance shine kawai maki don tsari, ba ƙimar gardamar ba. Bari muyi kokarin gyara wannan.

   Da farko, zaɓi madaukin layin blue ɗin da kake son sharewa danna maballin Share a kan keyboard.



3. Zaɓi duka jirgin saman da aka sanya jerar. A cikin menu na mahallin da ke bayyana, danna maballin "Zaɓi bayanai ...".



4. Ana fara buɗe zaɓin tushen data. A hannun toshe Sa hannu a kan tsinkayen kwance danna maballin "Canza".



5. Wani karamin taga yana buɗewa inda ake buƙatar bayyanar da daidaito na kewayon, ƙimar abin da za'a nuna shi akan sikelin madaidaiciya. Sanya siginan kwamfuta a cikin filin Rukunin Lissafi na Axis kuma kawai zaɓi yankin da ya dace akan takardar, wanda ya ƙunshi hujjojin aikin. Latsa maballin "Ok".



6. Yanzu dole ne mu kammala babban aikin: don kawar da rata ta amfani da shiga tsakani. Komawa taga zaɓi na bayanai, danna maballin Cellsoye da ɓoyayyun sellocated a cikin ƙananan kusurwar hagu.



7. Fuskar saiti don ƙwayoyin ɓoye da wofi suna buɗe. A cikin siga Nuna fanko sel sanya canjin a wuri "Layi". Latsa maballin "Ok".



8. Bayan dawowa taga mabudin tushe, tabbatar da duk canje-canjen da aka yi ta danna maballin "Ok".

Kamar yadda kake gani, an daidaita jadawalin, kuma an cire rata ta amfani da ma'amala.

Darasi: Yadda ake yin dabara a cikin Excel

Hanyar 3: hade da jadawali ta amfani da aikin

Hakanan zaka iya haɗa ma'amala tare da amfani da ND na musamman aiki. Yana dawo da ƙididdigar ƙididdiga ga sel ɗin da aka ƙayyade.

1. Bayan an gina ginshiƙi kuma a daidaita shi, kamar yadda kuke buƙata, gami da daidaitaccen wurin sanya hannu na sikelin, zaku iya rufe rata kawai. Zaɓi sel mara komai a cikin tebur wanda aka jawo bayanai. Danna alamar da muka riga muka sani "Saka aikin".



2. Yana buɗewa Mayan fasalin. A cikin rukuni "Tabbatar da kaddarorin da dabi'u" ko "Cikakken jerin haruffa" nemo kuma haskaka shigarwa "ND". Latsa maballin "Ok".



3. Wannan aikin ba shi da hujja, kamar yadda taga bayanai suka bayyana. Don rufe shi, danna danna maɓallin "Ok".



4. Bayan wannan aikin, ƙimar kuskure ta bayyana a cikin tantanin da aka zaɓa "# N / A", amma daga baya, kamar yadda kake gani, an kawar da hutun da ke cikin tsarin ta atomatik.

Za a iya sanya mafi sauƙi ba tare da farawa ba Mayan fasalin, amma kawai yi amfani da keyboard don fitar da ƙimar cikin sel mara komai "# N / A" ba tare da ambato ba. Amma ya riga ya dogara da wane mai amfani ya fi dacewa.

Kamar yadda kake gani, a cikin shirin Excel, zaku iya haɗa baki azaman bayanan ƙirar ta amfani da aikin KYAUTA, da zane. A cikin ƙarshen maganar, wannan yana yiwuwa ta amfani da tsarin jadawalin ko amfani da aikin Ndhaifar da kuskure "# N / A". Zaɓin wacce hanya don amfani da ita ya dogara da bayanin matsalar, kazalika akan fifikon aikin mai amfani.