Tablisation yimikorere muri Excel: amabwiriza arambuye

Anonim

Imikorere yo kubimenya muri Microsoft Excel

Imikorere ya Tabulation nibarwa kumurimo agaciro kuri buri mpaka zikwiye zerekanwe nintambwe yihariye kumupaka washizweho neza. Ubu buryo nigikoresho cyo gukemura imirimo itandukanye. Hamwe nubufasha bwayo, urashobora guhuza imizi yikigereranyo, shakisha hejuru na minima, ukemure indi mirimo. Hamwe na gahunda ya Excel, tabulation biroroshye cyane gukora kuruta gukoresha impapuro, ikiganza na calculatrice. Reka tumenye uko ibi bikorwa muriyi porogaramu.

Gukoresha Tabulation

Tambolisation ikoreshwa mugukora imbonerahamwe aho agaciro k'impaka nintambwe yatoranijwe izandikwa mu nkingi imwe, kandi mubya kabiri - imikorere ijyanye nayo. Noneho, hashingiwe ku kubara, urashobora kubaka gahunda. Reba uko ibi bikorwa kurugero runaka.

Gukora imbonerahamwe

Kora imbonerahamwe ifite ameza hamwe ninkingi x, aho agaciro k'impaka kazerekanwa, na f (x), aho imikorere ijyanye irega. Kurugero, fata imikorere f (x) = x ^ 2 + 2x, nubwo imikorere yubwoko ubwo aribwo bwose bukoreshwa muburyo bwo guturika. Twashizeho intambwe (H) ku bwinshi 2. Umupaka uva kuri -10 kugeza 10. Noneho dukeneye kuzuza inkingi yibitonyanga, gukomera ku ntambwe ya 2 ku mipaka ya mbere.

  1. Muri selire ya mbere yinkingi "x" andika agaciro "-10". Ako kanya nyuma yibyo tukanze kuri buto yintonde. Ibi nibyingenzi cyane, kubera ko ugerageza gukoresha imbeba, agaciro mu Kagari bizahinduka formula, kandi muriki gihe ntibikenewe.
  2. Agaciro ka mbere k'impaka muri Microsoft Excel

  3. Izindi ndangagaciro zose zirashobora kuzuzwa nintoki, gukomera ku ntambwe ya 2, ariko biroroshye gukora ibi ukoresheje igikoresho cyo muhogo. Cyane cyane ubu buryo bufite akamaro niba impaka zinyuranye, kandi intambwe ni nto.

    Hitamo Akagari urimo agaciro k'impaka za mbere. Mugihe muri tab "urugo", kanda kuri buto "Uzuza", uherereye kuri kaseti muri "guhindura" igenamiterere. Kurutonde rwibikorwa bigaragara, nahisemo ingingo "Iterambere ...".

  4. Inzibacyuho Kugena Iterambere Muri Microsoft Excel

  5. Idirishya rishiraho idirishya rifungura. Muri Parameter ya "Ahantu", twashyize ahagaragara kumwanya "kubijyanye n'inkingi", kuva muricyo indangagaciro zizashyirwa mu nkingi, ntabwo ari mu mugozi. Mu murima "intambwe", shiraho agaciro 2. Muri "ntarengwa agaciro", andika umubare wa 10. Kugirango utangire buto yo guterana, kanda buto ya "OK".
  6. Gushiraho iterambere muri Microsoft Excel

  7. Nkuko mubibona, inkingi yuzuye indangagaciro zifite ikibuga n'imbibi.
  8. Inkingi yimpaka zuzuye muri Microsoft Excel

  9. Noneho ukeneye kuzuza inkingi yimikorere f (x) = x ^ 2 + 2x. Kugirango ukore ibi, muri selire ya mbere yinkingi ihuye, andika imvugo ku cyitegererezo gikurikira:

    = x ^ 2 + 2 * x

    Mugihe kimwe, aho kuba agaciro ka x dusimbuza imirongo ya selile yambere uhereye ku nkingi nimpaka. Twanditse kuri buto yo kwinjiza kugirango yerekane ibisubizo byibarirwa kuri ecran.

  10. Agaciro ka mbere k'imikorere muri Microsoft Excel

  11. Kugirango tubare imikorere kandi mubindi birongo, tuzongera gukoresha ikoranabuhanga ryimodoka, ariko muriki gihe tuzashyira murwango rwuzuye. Dushiraho indanga kuruhande rwiburyo bwiburyo bwa selire aho formula isanzwe irimo. Ikimenyetso cyuzuye kigaragara, cyatanzwe muburyo buto bunini bwumusaraba. Clement ibumoso bwimbeba hanyuma urambura indanga kumuringi wose wuzuye.
  12. Kwuzuza Ikimenyetso muri Microsoft Excel

  13. Nyuma yibi bikorwa, inkingi yose hamwe nindangagaciro zimikorere zizahita zuzura.

Imikorere muri Microsoft Excel

Rero, imikorere ya tab yarakozwe. Ukurikije, turashobora kubimenya, kurugero, byibuze imikorere (0) bigerwaho nindangagaciro -2 na 0. Igikorwa kinini mumipaka itandukanijwe na -10 kugeza 10 Byagezweho ku ngingo ihuye n'impaka 10, kandi ni 120.

Isomo: Nigute ushobora gukora Auto-Kuzuza Excel

Gushushanya

Ukurikije tab igana kumeza, urashobora kubaka gahunda yimikorere.

  1. Hitamo indangagaciro zose mumeza hamwe na indanga hamwe na buto yimbeba yibumoso. Reka duhindukire kuri tab "Shyiramo", mugikoresho c'imbonezahamwe kuri kaseti tukanda buto "Igishushanyo". Urutonde rwibishushanyo mbonera birahari. Hitamo ubwoko dusuzuma cyane. Ku bitureba, biratunganye, kurugero, gahunda yoroshye.
  2. Inzibacyuho mukubaka igishushanyo muri Microsoft Excel

  3. Nyuma yibyo, software ya porogaramu ikora uburyo bwo kubaka igishushanyo gishingiye kumeza yatoranijwe.

Gahunda yubatswe muri Microsoft Excel

Byongeye, niba ubyifuzwa, umukoresha arashobora guhindura imbonerahamwe nkuko bigaragara ko ari ngombwa ukoresheje ibikoresho byoroshye kuri izo ntego. Urashobora kongeramo amazina yamashone ya coordines nibishushanyo muri rusange, kuvana cyangwa guhindura izina umugani, ukuremo izina ryimpaka, nibindi

Isomo: Uburyo bwo kubaka gahunda muri Excel

Nkuko tubibona, imikorere ya tabution, muri rusange, inzira yoroshye. Nibyo, kubara birashobora gufata igihe kirekire. Cyane cyane niba imbibi zimpaka zagutse cyane, kandi intambwe ni nto. Yakijije cyane umwanya wo gufasha Excel Auto-Yuzuye Ibikoresho. Byongeye kandi, muri gahunda imwe, hashingiwe kubisubizo, urashobora kubaka igishushanyo cyo kwerekana amashusho.

Soma byinshi