Tabuligation na aikin a Excel: Umurnin cikakken umarnin

Anonim

Tsarin aiki a Microsoft Excel

Aikin Tabulation shine lissafin darajar aikin kowane hujja da ta dace da takamaiman mataki a cikin ingantattun iyakoki. Wannan hanyar shine kayan aiki don warware ayyuka da yawa. Tare da taimakonta, zaku iya tsara tushen daidaituwa, sami babban aiki kuma minima, warware wasu ayyuka. Tare da ingantaccen shirin, da Tabulation ya fi sauƙin yi fiye da amfani da takarda, rike da coatulator. Bari mu gano yadda ake yin wannan a wannan aikace-aikacen.

Amfani da Tabul

Ana amfani da Tableization ta ƙirƙirar tebur wanda darajar muhawara tare da zaɓaɓɓen mataki za'a yi rikodin shi a shafi ɗaya, kuma a cikin na biyu - aikin yayi daidai da shi. Bayan haka, a kan lissafin, zaku iya gina jadawalin. Ka yi la'akari da yadda ake yin wannan akan takamaiman misali.

Kirkirar tebur

Airƙiri tebur tare da tebur tare da ginshiƙai x, wanda za'a nuna darajar gardama, da f (x), inda aka nuna aikin da ake amfani da aikin. Misali, dauki aikin f (x) = x ^ 2 + 2x, kodayake ana iya amfani da aikin kowane irin tsari. Mun saita mataki (h) a cikin adadin 2. Iyaka daga -10 zuwa 10. Yanzu muna buƙatar cika tsarin gargajiya, mai suna mataki na 2 a ƙayyadaddun ƙayyadaddun.

  1. A cikin tantanin farko na shafi "x" Shigar da darajar "-10". Nan da nan bayan mun danna maɓallin ENT. Wannan yana da matukar muhimmanci, tunda kunyi kokarin sarrafa linzamin kwamfuta, darajar a cikin sel zata juya cikin tsari, kuma a wannan yanayin ba lallai ba ne.
  2. Darajar farko ta muhawara a Microsoft Excel

  3. All ƙimar za a iya cika da hannu, masu suna kan mataki na 2, amma ya fi dacewa a yi wannan ta amfani da kayan aiki na Autofill. Musamman wannan zabin ya dace idan kewayon muhawara girma ne, kuma mataki ya kasance kaɗan.

    Select tantanin yana dauke da darajar mahawara ta farko. Duk da yake a cikin "gida", danna maɓallin "Cika", wanda yake a cikin tef a cikin tef a cikin "Gyara" saiti. A cikin jerin ayyukan da ya bayyana, na zabi kalmar "ci gaba ...".

  4. Canji zuwa tsarin ci gaba a Microsoft Excel

  5. Budewar da ke gudana. A cikin "wuri" sigogi, mun saita canzawa zuwa matsayin "ta ginshiƙai", tunda a cikin yanayin hujjar ta za a sanya a cikin shafi, kuma ba a cikin kirtani ba. A cikin filin "Mataki", saita darajar 2. A cikin "Iyakantaccen darajar" filin, shigar da lamba 10. Don fara ci gaba, danna maɓallin "Ok" maɓallin.
  6. Kafa ci gaba a Microsoft Excel

  7. Kamar yadda kake gani, shafi yana cike da dabi'u tare da fage da iyakoki.
  8. Cikinin gardamar ta cika a Microsoft Excel

  9. Yanzu kuna buƙatar cika shafi na f (x) = x ^ 2x. Don yin wannan, a cikin tantanin farko na shafi mai dacewa, rubuta magana akan samfurin masu zuwa:

    = x ^ 2 2 * x

    A lokaci guda, maimakon darajar X muka musanya dabarun farko daga shafi. Mun danna maballin ENT don nuna sakamakon lissafin akan allon.

  10. Amfanin farko na aikin a Microsoft Excel

  11. Domin lissafta aikin da sauran layin, zamu sake amfani da fasaha ta hanyar kai tsaye, amma a wannan yanayin za mu yi amfani da alamar cika. Mun kafa siginan siginan zuwa ƙananan kusurwar dama ta tantanin halitta wanda aka riga aka kunyata. Alamar mai cika, ta gabatar a cikin hanyar karamin girman gicciye. Clement A maɓallin linzamin kwamfuta na hagu da shimfiɗa siginan tare da duk shafi na cika.
  12. Cika alama a Microsoft Excel

  13. Bayan wannan aikin, dukkanin shafi tare da ƙimar aikin zai cika ta atomatik.

Ayyuka a Microsoft Excel

Saboda haka, aikin shafin ya gudana. A kan tushen sa, zamu iya ganowa, alal misali, cewa aƙalla aikin gardamar -2 da 0. Matsakaicin aiki a cikin iyakokin bambancin gardamar magana daga -10 zuwa 10 shine An samu a wani matsayi mai dacewa da hujjoji 10, kuma 120.

Darasi: Yadda ake yin cika da abin hawa

Gina zane-zane

Dangane da shafin tabulet a cikin tebur, zaku iya gina jadawalin aiki.

  1. Zaɓi duk dabi'u a cikin tebur tare da siginan kwamfuta tare da maɓallin linzamin kwamfuta na hagu. Bari mu juya zuwa shafin "Saka", a cikin ginshiƙi kayan aiki toshewa a kan tef muna danna maɓallin "zane". Jerin zaɓuɓɓukan zane mai samarwa. Zabi nau'in da muke la'akari da abin da ya fi dacewa. A cikin lamarinmu, cikakke ne, alal misali, jadawalin sauki.
  2. Canji zuwa Gina Shirin In Microsoft Excel

  3. Bayan haka, software na shirin yana aiwatar da hanyar gina jadawalin shirin da aka zaɓa.

An gina jadawalin a Microsoft Excel

Bugu da ari, idan ana so, mai amfani zai iya shirya ginshiƙi kamar yadda alama yana da alama ta amfani da kayan aikin fices don waɗannan dalilai. Kuna iya ƙara sunayen axes na daidaitawa da zane-zane a duk faɗin, cire ko suna da almara, cire layin gargajiya, da sauransu.

Darasi: Yadda ake Gina Jadawalin Are Excel

Kamar yadda muke gani, aikin shafi, gabaɗaya, tsari mai sauki ne. Gaskiya ne, lissafin na iya ɗaukar lokaci mai tsawo. Musamman idan iyakokin muhawara suna da yawa sosai, kuma matakin karami ne. Muhimin ajiyayyu lokacin don taimakawa kayan aikin farko-Excelonal. Bugu da kari, a cikin wannan shirin, bisa sakamakon, zaku iya gina jadawalin gabatarwa.

Kara karantawa