Shafin dogara da ginin a Microsoft Excel

Ofaya daga cikin matsalolin lissafi na yau da kullun shine ƙirƙirar dogara. Yana nuna dogarowar aikin akan canza magana. A kan takarda, wannan hanya ba koyaushe ba ce. Amma kayan aikin Excel, idan an kware sosai, zasu baka damar aiwatar da wannan aiki daidai kuma da sauri. Bari mu gano yadda za a yi wannan ta amfani da bayanan shigar da bayanai daban-daban.

Tsarin Tsari

Dogaro da aiki kan magana shine mahimmin abin dogaro na aljebra. Mafi yawan lokuta, al'ada ce don nuna hujja da ƙimar aiki tare da haruffa: "x" da "y", bi da bi. Sau da yawa kuna buƙatar nuna hoto ta hanyar zane dogara da hujja da aikin, wanda aka rubuta a cikin tebur, ko gabatar dashi azaman ɓangaren dabarun. Bari mu kalli takamaiman misalai na kirkirar irin wannan jadawali (ginshiƙi) a ƙarƙashin halaye daban-daban.

Hanyar 1: ƙirƙira jadawali mai dogaro da bayanan tebur

Da farko dai, zamuyi nazari kan yadda za'a kirkiro jadawali mai dogaro da bayanan da aka riga aka shigar cikin tsarin tebur. Muna amfani da tebur na nesa tayi tafiya (y) a kan lokacin (x).

1. Zaɓi teburin kuma je zuwa shafin Saka bayanai. Latsa maballin Charthakan yana da isasshen bayani a cikin rukunin Charts a kan tef. Zaɓin nau'ikan zane-zane daban-daban yana buɗewa. Don dalilanmu, mun zaɓi mafi sauƙi. Shine farkon a cikin jeri. Danna shi.



2. Shirin ya samar da ginshiƙi. Amma, kamar yadda muke gani, ana nuna layuka biyu akan yankin gini, yayin da muke buƙatar guda ɗaya kawai: nuna dogarowar hanyar akan lokaci. Sabili da haka, zaɓi layin shuɗi tare da maɓallin linzamin kwamfuta na hagu ("Lokaci"), tunda bai dace da aikin ba, danna maballin Share.



3. Za'a share layin da aka haskaka.

A gaskiya akan wannan, ana yin la'akari da aikin ginin mafi sauƙin dogaro mai ɗorewa. Idan kanaso, zaku iya shirya sunan jadawalin, alamun ta, share almara kuma kuyi wasu canje-canje. An bayyana wannan dalla-dalla a cikin darasi dabam.

Darasi: Yadda ake tsara jadawalin a Excel

Hanyar 2: ƙirƙira jadawalin dogaro da layi mai yawa

Sigar mafi rikitarwa game da gina jren dogaro shine yanayin lokacin ayyuka biyu sun dace da gardama ɗaya lokaci guda. A wannan yanayin, kuna buƙatar gina layi biyu. Misali, ɗauki tebur wanda za'a ƙididdige yawan kuɗin shiga na kamfanin da ribar da yake samu na tsawon shekaru.

1. Zaɓi duka teburin tare da take.



2. Kamar yadda ya gabata, danna maɓallin Chart a sashin zane. Hakanan, zaɓi zaɓi na farko da aka gabatar a cikin jerin wanda zai buɗe.



3. Shirin yana samar da makircin zane bisa ga bayanan da aka karba. Amma, kamar yadda muke gani, a wannan yanayin ba kawai muna da ƙarin layin uku ba kawai, har ma da zane-zane akan ƙirar daidaitawa ba su dace da waɗanda ake buƙata ba, wato, tsari na shekaru.

   Nan da nan cire layin wuce haddi. Hanya ce ta madaidaiciya a wannan hoton - "Shekara". Kamar yadda yake a hanyar da ta gabata, zaɓi layin ta danna kan shi tare da linzamin kwamfuta kuma danna maɓallin Share.



4. An share layi kuma tare da shi, kamar yadda kake gani, an canza dabi'u a cikin kwamitin daidaitawa na tsaye. Sun zama mafi daidaito. Amma matsalar rashin daidaituwa ta hanyar daidaiton madaidaiciyar kwance tana ci gaba da kasancewa. Don magance wannan matsalar, danna kan yankin gini tare da maɓallin linzamin kwamfuta na dama. A cikin menu ya kamata ka dakatar da zaɓi a wurin "Zaɓi bayanai ...".



5. Window ɗin zaɓi na asalin yana buɗewa. A toshe Sa hannu a kan tsinkayen kwance danna maballin "Canza".



6. Wani taga yana buɗe har ƙasa da wanda ya gabata. A ciki, kuna buƙatar ƙididdige ayyukan daidaitawa a cikin teburin waɗancan ɗabi'un waɗanda ya kamata a nuna su akan akasi. Don wannan dalili, saita siginar kwamfuta a cikin kawai filin wannan taga. Sannan riƙe maɓallin linzamin kwamfuta na hagu ka zaɓi duk abubuwan da ke cikin shafi "Shekara"sai dai da sunanta. Adireshin za a nuna shi nan da nan a filin, danna "Ok".



7. Komawa taga zaɓi na bayanai, kuma danna "Ok".



8. Bayan haka, dukkanin zane-zanen da aka sanya akan takardar ana nuna su daidai.

Hanyar 3: makirci ta amfani da raka'a daban

A cikin hanyar da ta gabata, munyi tunanin gina zane tare da layuka da yawa akan jirgin guda, amma duk ayyukan suna da raka'a ɗaya na ma'auni (dubu rubles). Me za ku yi idan kuna buƙatar ƙirƙirar zane-zanen dogaro kan tebur ɗaya, don abin da ɓangarorin ma'aunin aikin suka bambanta? A Excel akwai wata hanyar fita daga wannan halin.

Muna da tebur wanda ke gabatar da bayanai akan ƙarar tallace-tallace na wani samfurin a cikin tan kuma a kan kudaden shiga daga siyarwarsa a cikin dubban rubles.

1. Kamar yadda ya gabata, muna zabar duk bayanan da ke cikin tebur tare da kanun.



2. Latsa maballin Chart. Hakanan, zaɓi zaɓi na farko na gini daga jerin.



3. Ana kafa abubuwa masu sifofi akan yankin gini. Ta wannan hanyar da aka bayyana a cikin sigogin da suka gabata, cire layin wuce haddi "Shekara".



4. Kamar yadda yake a cikin hanyar da ta gabata, ya kamata mu nuna shekarun a kan kwamitin daidaitawa na kwance. Mun danna kan yankin gini kuma zaɓi zaɓi a cikin jerin ayyukan "Zaɓi bayanai ...".



5. A cikin sabon taga, danna maballin "Canza" a toshe "Sa hannu" a kwance.



6. A cikin taga na gaba, aiwatar da ayyuka guda ɗaya waɗanda aka bayyana dalla-dalla a cikin hanyar da ta gabata, muna shigar da daidaitawar shafi "Shekara" zuwa yankin Rukunin Lissafi na Axis. Danna kan "Ok".



7. Lokacin da muka dawo zuwa taga ta baya, mukan danna maballin "Ok".



8. Yanzu ya kamata mu warware matsalar da ba mu ci karo da ita ba dangane da abin da ya gabata na ginamu, watau matsalar matsalar raka'a raka'a. Tabbas, dole ne a yarda cewa baza su iya kasancewa a kan ɗaya daga cikin kwamitin daidaitawa ba, wanda a lokaci guda yana nuna adadin kuɗi (dubu rubles) da taro (tan). Don magance wannan matsalar, muna buƙatar gina ƙarin tsattsauran hanyoyin daidaitawa.

   A cikin batunmu, don nuna kudaden shiga, mun bar madaidaicin madaidaicin da ya rigaya ya kasance, kuma don layi "Salesarar siyarwa" ƙirƙiri karin taimako. Danna kan wannan layin tare da maɓallin linzamin kwamfuta na dama kuma zaɓi zaɓi daga jeri "Tsarin jerin bayanai ...".



9. Tsarin jerin bayanan bayanai yana farawa. Muna buƙatar motsawa zuwa ɓangaren Jere sigogiidan aka bude shi a wani sashe. A gefen dama na taga wani toshe ne Gina Row. An buƙata don saita canjin zuwa matsayi "A kan axumi na taimako". Danna sunan Rufe.



10. Bayan haka, za a gina bututu na tsaye na taya, da layin "Salesarar siyarwa" sake tunani game da daidaitawa. Don haka, an kammala nasarar aikin akan aikin.

Hanyar 4: ƙirƙira jadawalin dogaro bisa aikin algebra

Yanzu bari muyi la’akari da zabin samar da jadadda mai dogaro, wanda aikin algebra zai bayar.

Muna da ayyuka masu zuwa: y = 3x ^ 2 + 2x-15. Dangane da shi, yakamata ku gina jadawalin dogaro da dabi'u y daga x.

1. Kafin fara gina zane, zamu buƙaci ƙirƙirar tebur bisa aikin da aka ƙayyade. Za a nuna mahimmancin hujja (x) a cikin teburinmu a cikin kewayon daga -15 zuwa +30 a cikin matakai na 3. Don hanzarta tsarin shigar da bayanai, za mu yi amfani da kayan aiki mai sarrafa kansa. "Ci gaba".

   Saka a cikin tantanin farko na shafi "X" darajar "-15" kuma zaɓi shi. A cikin shafin "Gida" danna maballin Cikasanya a cikin toshe "Gyara". A cikin jerin, zaɓi zaɓi "Ci gaba ...".



2. Ana kunna kunna Window "Ci gaba". A cikin toshe "Wuri" alama sunan Harafi da shafi, tunda muna buƙatar cika layin daidai. A cikin rukunin "Nau'in" barin darajar "Ilmin lissafi"wanda aka shigar ta tsohuwa. A yankin "Mataki" ya kamata saita darajar "3". A yankin "Iyakataccen darajar" sanya lamba "30". Danna kan "Ok".



3. Bayan yin wannan algorithm na ayyuka, gaba ɗaya shafi "X" zai cika da dabi'u daidai da tsarin da aka tsara.



4. Yanzu muna buƙatar saita dabi'u Ywanda zai dace da wasu dabi'u X. Don haka, tuna cewa muna da tsari y = 3x ^ 2 + 2x-15. Kuna buƙatar canza shi zuwa dabara mai inganci wanda dabi'u suke X za a maye gurbinsa da nassoshi game da sel na tebur waɗanda ke ɗauke da muhawara masu dacewa.

   Zaɓi sel na farko a cikin shafi "Y". Ganin cewa a cikin yanayinmu adireshin farkon gardamar X wakilai ne suka wakilta su A2, sannan a maimakon wannan dabarar da muke sama zamu sami magana:

   = 3 * (A2 ^ 2) + 2 * A2-15

   Mun rubuta wannan magana a cikin sel na farko na shafi "Y". Don samun sakamakon lissafin, danna maɓallin Shigar.



5. Sakamakon aikin don hujja ta farko ta dabara an lasafta shi. Amma muna buƙatar lasafta dabi'un don sauran muhawara na tebur. Shigar da dabara don kowane darajar Y aiki ne mai matukar tsawo da wahala. Yana da sauri da sauƙin kwafa shi. Ana iya magance wannan matsala ta amfani da alamar cikawa kuma saboda irin wannan kayan haɗin haɗin gwiwa a cikin Excel kamar yadda dangantakarsu take. Lokacin kwafin dabara zuwa wasu jeri Y dabi'u X a cikin dabara zai canza ta atomatik canza dangi zuwa na farko daidaitawa.

   Matsar da siginan kwamfuta zuwa rightan dama na dama a cikin abin da aka rubuta rubutun nan. A wannan yanayin, canji ya kamata ya faru tare da siginan kwamfuta. Zai zama gicciyen baƙar fata, wanda ke ɗauke da sunan mai alamar. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja wannan alamar a ƙasan tebur a cikin shafi "Y".



6. Ayyukan da ke sama sunyi shafi "Y" ya cika da sakamakon lissafin aikin y = 3x ^ 2 + 2x-15.



7. Yanzu lokaci ya yi da za a tsara ginshiƙi daidai. Zaɓi duk bayanan shafin. Tab kuma Saka bayanai danna maballin Chart kungiyoyi Charts. A wannan yanayin, bari mu zaɓi daga jerin zaɓuɓɓuka Yarjejeniya tare da Alamomi.



8. Alamar tare da alamomi suna bayyana a yankin yankin. Amma, kamar yadda a cikin al'amuran da suka gabata, muna buƙatar yin wasu canje-canje domin ya sami daidaitaccen tsari.



9. Da farko dai, share layin "X", wanda yake a sararin samaniya a alamar 0 tsarawa. Zaɓi wannan abun kuma danna maballin. Share.



10. Hakanan ba ma buƙatar labari, tunda muna da layin guda ɗaya kaɗai ("Y") Sabili da haka, zaɓi almara kuma latsa maɓallin sake Share.



11. Yanzu muna buƙatar musanya dabi'u a cikin kwamitin daidaitawa tare da waɗanda ke dacewa da shafi "X" a cikin tebur.

    Ta danna maɓallin linzamin kwamfuta na dama, zaɓi sashin layi. A cikin menu muna motsawa da darajar "Zaɓi bayanai ...".



12. A cikin taga zaɓi na tushen kunnawa, danna maɓallin da muka riga muka sani "Canza"located a cikin toshe Sa hannu a kan tsinkayen kwance.



13. Tagan taga ya fara Labarin Axis. A yankin Rukunin Lissafi na Axis saka masu tsara hanyoyin tare da bayanan shafi "X". Mun sanya siginan kwamfuta a cikin rami na filin, sannan, bayan an sanya maballin hagu-linzamin hagu, zaɓi duk dabi'un shafi na teburin, ban da sunan kawai. Da zaran an nuna abubuwan gabatarwa a cikin filin, danna sunan "Ok".



14. Komawa taga zaɓi na data, danna maballin "Ok" a ciki, kamar yadda aka yi a gaban taga na baya.



15. Bayan wannan, shirin zai shirya zane mai hoto da aka gina a baya gwargwadon canje-canje da aka yi a saitunan. Ana iya ɗaukar nauyin jigilar dogara da aikin algebra gaba ɗaya an gama shi.

Darasi: Yadda ake yin gyaran kai a Microsoft Excel

Kamar yadda kake gani, ta yin amfani da shirin Excel, hanya don ƙirƙirar jigon dogara yana da sauƙin sauƙaƙe idan aka kwatanta da ƙirƙirar ta akan takarda. Sakamakon ginin ana iya amfani dashi duka don aikin ilimi, kuma kai tsaye don dalilai masu amfani. Zaɓin takamaiman zaɓi na gine-gine ya dogara da abin da ginshiƙi ya dogara da: ƙimar tebur ko aiki. A cikin magana ta biyu, kafin ƙirƙirar zane, har yanzu kuna buƙatar ƙirƙirar tebur tare da mahawara da ƙimar aiki. Bugu da ƙari, ana iya gina jadawalin, duka biyu kan aiki ɗaya, ko da yawa.