Aiwatar da aikin tabbing a Microsoft Excel

Tabulation na aiki shine ƙididdigar darajar aikin don kowane hujja mai dacewa da aka ƙayyade tare da takamaiman mataki, tsakanin iyakoki da aka ayyana. Wannan hanya kayan aiki ne don magance matsaloli da yawa. Tare da taimakonsa, zaku iya gano tushen daidaituwa, gano mafi ƙarancin da mafi ƙarancin yanayi, da warware sauran matsaloli. Yin amfani da Excel yafi sauki sauƙaƙawa fiye da amfani da takarda, alƙalami, da kalkuleta. Bari mu gano yadda ake yin wannan a cikin wannan aikace-aikacen.

Amfani da shafuka

Ana amfani da Tabulation ta hanyar ƙirƙirar tebur wanda za'a rubuta ƙimar gardama tare da matakin da aka zaɓa a cikin shafi ɗaya, da ƙimar aikin da ya dace a shafi na biyu. Sannan, dangane da lissafin, zaku iya gina jadawali. Yi la'akari da yadda ake yin wannan tare da takamaiman misali.

Tsarin tebur

Irƙiri kan tebur tare da ginshiƙai xwanda zai nuna darajar gardamar, kuma f (x)inda aka nuna ƙimar aikin mai aiki daidai. Misali, dauki aikin f (x) = x ^ 2 + 2xkodayake ana amfani da aikin shafin kowane nau'in. Saita mataki (h) a cikin adadin 2. Iyakokin daga -10 a da 10. Yanzu muna buƙatar cike shafin shafi na shawara, bin matakin 2 a tsakanin iyakokin da aka ba su.

1. A cikin tantanin farko na shafi x shigar da darajar "-10". Nan da nan bayan wannan, danna maballin Shigar. Wannan yana da mahimmanci, saboda idan kayi ƙoƙarin sarrafa linzamin kwamfuta, ƙimar da ke cikin tantanin halitta zai juya ya zama dabara, kuma a wannan yanayin ba lallai ba ne.



2. Duk sauran kara za'a iya cika su da hannu, bin matakin 2, amma ya fi dacewa a yi wannan ta amfani da kayan aiki cikakke. Wannan zaɓin yana dacewa musamman idan yanayin muhawara mai girma ne kuma matakin yana da ɗan ƙarami.

   Zaɓi tantanin da ya ƙunshi darajar gardamar farko. Kasancewa a cikin shafin "Gida"danna maballin Cika, wanda yake akan haƙarƙari a cikin toshe saitunan "Gyara". A cikin jerin ayyukan da ya bayyana, zaɓi "Ci gaba ...".



3. Window na ci gaba taga yana buɗewa. A cikin siga "Wuri" saita canzawa zuwa matsayi Harafi da shafi, tunda a yanayinmu za a sanya dabi'un hujja a cikin shafi, kuma ba a jere ba. A fagen "Mataki" saita darajar 2. A fagen "Iyakataccen darajar" shigar da lamba 10. Domin fara ci gaba, danna maɓallin "Ok".



4. Kamar yadda kake gani, shafin yana cike da dabi'u tare da matakan da aka saita da kuma iyakoki.



5. Yanzu kuna buƙatar cika fam ɗin aikin f (x) = x ^ 2 + 2x. Don yin wannan, a cikin tantanin farko na sashin layi mai dacewa, rubuta magana daidai da tsarin da ke biye:

   = x ^ 2 + 2 * x

   Haka kuma, maimakon darajar x Muna maye gurbin masu daidaitawa daga sel ɗin farko daga shafi tare da muhawara. Latsa maballin Shigardon nuna sakamakon lissafin.



6. Domin aiwatar da lissafin aikin a cikin sauran layin, mun sake amfani da fasahar sarrafa kansa, amma a wannan yanayin, muna amfani da alamar cikawa. Sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta wanda ya riga ya ƙunshi tsarin. Alamar cike take bayyana, an gabatar dashi azaman karamin giciye. Riƙe maɓallin linzamin kwamfuta na hagu ka ja siginar kwamfuta gaba ɗaya shafi don cika.



7. Bayan wannan matakin, gaba ɗaya shafi tare da dabi'u na aikin zai cika ta atomatik.

Saboda haka, aikin tabulation ya yi. Dangane da shi, zamu iya gano, misali, cewa mafi ƙarancin aikin (0) an cimma shi tare da dabi'ar muhawara -2 da 0. Matsakaicin aikin tsakanin bambancin hujja daga -10 a da 10 ana kaiwa a daidai dacewa da jayayya 10, kuma yana sanyawa 120.

Darasi: Yadda ake yin autocomplete a Excel

Shiryawa

Dangane da tabulation a cikin tebur, zaku iya tsara aikin.

1. Zaɓi duk dabi'u a cikin tebur tare da siginan kwamfuta yayin riƙe maɓallin linzamin kwamfuta na hagu. Je zuwa shafin Saka bayanai, a cikin akwatin kayan aiki Charts a kan tef danna kan maɓallin "Charts". Jerin zaɓuɓɓukan ƙira da ke akwai don ginshiƙi ya buɗe. Zaɓi nau'in da muke la'akari da wanda ya fi dacewa. A cikin yanayinmu, alal misali, tsari mai sauƙi cikakke ne.



2. Bayan wannan, a kan takardar aiki, shirin yana aiwatar da tsari na tsara zane bisa layinin tebur da aka zaɓa.

Furtherari, idan ana so, mai amfani na iya shirya jadawalin kamar yadda ya ga ya dace, ta yin amfani da kayan aikin Excel don waɗannan manufofin. Kuna iya ƙara sunayen madaukai masu daidaitawa da jadawalin gaba ɗaya, cire ko sake suna da almara, share layin gardama, da sauransu.

Darasi: Yadda za a gina jadawalin a Excel

Kamar yadda kake gani, sanya aiki gaba ɗaya aiki ne madaidaiciya. Gaskiya ne, lissafin na iya daukar lokaci mai tsawo. Musamman idan iyakokin hujjoji suna da faɗi sosai kuma matakin yayi ƙananan. Da muhimmanci a adana lokaci zai taimaka ingantattun kayan aikin kansu. Bugu da kari, a cikin shirin iri daya, dangane da sakamako, zaku iya gina jadawali don gabatarwar gani.