Shafin aikace-aikacen yana aiki a cikin Microsoft Excel

Tabbatar da aiki shine ƙididdige darajar aiki don kowace gardama daidai, da aka ba da wani mataki, a cikin iyakokin iyakancewa. Wannan hanya shine kayan aiki don warware ɗayan ayyuka. Tare da taimakonsa, zaka iya gano tushen asalin, sami maxima da minima, magance wasu matsalolin. Yin amfani da Excel yana sa shafin ya fi sauki fiye da yin amfani da takarda, alkalami, da maƙirai. Bari mu ga yadda aka aikata hakan a cikin wannan aikin.

Yi amfani da rubutu

Ana amfani da tabbacin ta hanyar samar da tebur wanda za'a yi amfani da ma'anar gardama tare da matakan da aka zaɓa a daya shafi, kuma aikin aikin daidai a cikin na biyu. Bayan haka, bisa lissafi, zaka iya gina hoto. Yi la'akari da yadda aka aikata wannan tare da wani misali.

Shirye-shiryen Table

Ƙirƙiri ɗan layi na tebur tare da ginshiƙai xwanda zai zama darajar gardamar, kuma f (x)inda aikin darajar aiki ya nuna. Alal misali, ɗauki aikin f (x) = x ^ 2 + 2x, ko da yake ana iya amfani da kowane nau'i na hanyar da aka tsara. Saita mataki (h) a cikin adadin 2. Border daga -10 har zuwa 10. Yanzu muna buƙatar cika layin jayayya, bin matakin 2 a cikin iyaka.

1. A cikin wayar farko ta shafi "x" shigar da darajar "-10". Nan da nan bayan haka, danna maballin Shigar. Wannan yana da mahimmanci, domin idan kuna kokarin yin amfani da linzamin kwamfuta, darajar cikin tantanin halitta zai zama wata hanya, amma a wannan yanayin ba lallai ba ne.



2. Za'a iya cika dukkan ƙididdiga masu daraja tare da hannu, ta bi mataki 2amma yana da mafi dacewa don yin wannan tare da taimakon kayan aiki na auto-cika. Musamman wannan zabin yana da dacewa idan iyakar jayayya na da girma, kuma matakin yana da ƙananan ƙananan.

   Zaɓi tantanin halitta dauke da darajar gardama ta farko. Da yake cikin shafin "Gida", danna kan maɓallin "Cika"wanda aka sanya a kan rubutun a cikin saitunan akwatin Ana gyara. A cikin jerin abubuwan da suka bayyana, zaɓi abu "Ci gaba ...".



3. Maɓallin saitin ci gaba ya buɗe. A cikin saiti "Location" saita canzawa zuwa matsayi "Da ginshiƙai", tun da yake a cikin yanayinmu za a sanya dabi'u na gardama a cikin shafi, ba cikin jere ba. A cikin filin "Mataki" saita darajar 2. A cikin filin "Ƙimar ƙimar" shigar da lambar 10. Domin ci gaban ci gaba, danna maballin "Ok".



4. Kamar yadda kake gani, shafi yana cike da dabi'u tare da kafa matakai da iyakoki.



5. Yanzu muna bukatar mu cika aikin shafi. f (x) = x ^ 2 + 2x. Don yin wannan, a cikin tantanin farko na shafi na daidai wanda muke rubutun magana kamar yadda aka tsara:

   = x ^ 2 + 2 * x

   A wannan yanayin, maimakon darajar x canza matsayin haɗin farko na cell daga shafi tare da muhawara. Muna danna maɓallin Shigar, don nuna sakamakon sakamakon lissafi akan allon.



6. Domin yin lissafi na aikin a wasu layuka, za mu sake amfani da fasaha ta atomatik, amma a wannan yanayin muna amfani da alamar cikawa. Saita siginan kwamfuta a cikin kusurwar dama na tantanin halitta, wanda ya riga ya ƙunshi wannan tsari. Alamar cikawa ta bayyana, ta wakilci a matsayin karamin giciye. Riƙe maɓallin linzamin hagu kuma ja mai siginan kwamfuta tare da cikakken shafi.



7. Bayan wannan aikin, duk shafi tare da ayyukan dabi'un za a cika ta atomatik.

Sabili da haka, aikin da aka yi aiki ya gudana. Bisa ga wannan, zamu iya gano, alal misali, mafi yawan aikin (0) cimma tare da lambobin ƙwaƙwalwar -2 kuma 0. Ayyuka mafi girma a cikin bambancin jayayya daga -10 har zuwa 10 isa a daidai daidai da gardama 10kuma ya yi sama 120.

Darasi: Yadda za a yi ba da kyauta a Excel

Sanya

Bisa ga shafuka da aka samar a teburin, za ka iya yin amfani da aikin.

1. Zaɓi duk dabi'u a cikin teburin tare da siginan kwamfuta tare da maɓallin linzamin kwamfuta na hagu. Je zuwa shafin "Saka"a cikin wani akwati na kayan aiki "Sharuɗɗa" a kan tef danna maballin "Sharuɗɗa". Jerin samfurin zane mai zane yana nunawa. Zabi nau'in da muke la'akari da mafi dacewa. A cikin yanayin mu, alal misali, shirin mai sauƙi cikakke ne.



2. Bayan haka, a kan takardar, shirin yana aiwatar da hanyar yin mãkirci bisa ga tashar tebur da aka zaba.

Bugu da ari, idan an so, mai amfani zai iya shirya jadawalin yadda ya dace, ta amfani da kayan aikin Excel don wannan dalili. Zaka iya ƙara sunayen sunaye masu daidaitawa da kuma zane-zane a matsayin duka, cire ko sake maimaita labarin, share layin jayayya, da dai sauransu.

Darasi: Yadda za a gina zane a Excel

Kamar yadda zaku iya gani, aikin aiki, a gaba ɗaya, tsari ne mai sauki. Gaskiya, lissafi na iya ɗaukar lokaci mai tsawo. Musamman idan iyakokin muhawarar suna da matukar fadi, kuma matakan ne ƙananan. Kayayyakin kayan aikin kyauta na Excel zasu taimaka wajen ajiye lokaci. Bugu da ƙari, a cikin wannan shirin bisa ga sakamakon da aka samo, za ka iya ƙirƙirar hoto don zane mai gani.