Yengetiwe Excel: Izici, izinqubo kanye izibonelo,

Excel-spreadsheet ikuvumela ukuba ngokushesha hhayi kuphela ukukhiqiza ezihlukahlukene izibalo, kodwa futhi ukuxazulula umsebenzi esikhundleni nzima. Ngokwesibonelo, kungase kwenziwe usebenzisa ukumodeliswa zezibalo esekelwe sesethi yamanani ngokuqhubekayo yomsebenzi, kuhlanganise imisebenzi ukuthola ukubaluleka Lesisemkhatsini ngu yengetiwe. Ku-Excel le njongo inikeza amathuluzi ahlukahlukene ukusebenzisa ukuthi bafundise lesi sihloko.

Yengetiwe Indlela: kuyini?

Esikhathini okuthiwa zezinombolo ukuhlaziywa indlela yokuthola amanani Intermediate umsebenzi ongaziwa Y (X) isethi ngokuqhubekayo okwaziwayo kakade.

Umsebenzi yengetiwe Y (X) kungaba kwenziwe kuphela kulabo agumenti, okuyizinto ngaphakathi isikhawu [X _0, X _n], kangangokuthi amagugu Y (X ₀₎ kanye Y (X _n).

Uma X ingeyona [X _0, X _n], kungenzeka ukusebenzisa extrapolation indlela.

Ngo ekwakhiweni classical inkinga yengetiwe liyadingeka ukuze uthole eseduze ahlaziye umsebenzi φ (X), lapho amanani ngesikhathi nodal amaphuzu X _i inamanani afanayo Y (X _i) the original ithebula m. E. Ukulandela isimo _{φ (X i) = Y i} (i = 0,1,2, ..., n).

yengetiwe Linear Excel

Isicelo-spreadsheet edume kakhulu kusuka ku-Microsoft kukhona okuwusizo kakhulu opharetha "ISIBIKEZELO".

Cabanga idatha wahlela itafula ngezansi.

Ohlwini lokuqala ukuphikisana x, kanti eyesibili - ukubaluleka ohambelana a komugqa umsebenzi f (x). Ake sithi kudingeka zifunde ukubaluleka kokuphila agumenti x = 28. Ukuze wenze lokhu:

• ukwaba iyiphi nalutho iseli processor etafuleni ishidi, lapho umphumela uyoba okukhiphayo kusukela ekuqaliseni ukusebenza isenzo, isibonelo C1;
• uchofoze isithonjana «fx» ( «Faka umsebenzi"), ibekwe ngakwesokunxele kwebha ifomula;
• ebhokisini "imisebenzi Master" angene esigabeni "Izibalo";
• thola opharetha "ISIBIKEZELO" bese uchofoza «OK».

Ngo-agumenti ukuze 3 igalofu. Eyokuqala ikhibhodi input agumenti value (kule umsebenzi othize 28). Ukuze ugcwalise "amagugu eyaziwa _ y», chofoza uphawu nge umcibisholo ebomvu esinxeleni sewindi elihambisana nokukhululwa endaweni efanele eshidini. Endabeni ethile, le ngxenye lamakheli ikholomu uhla B2: B7.

Ngokufanayo, ugcwalise "amagugu eyaziwa _ x" bese uchofoza inkinobho "OK".

Ngenxa yalokho, kuseli akhethiwe C1 uboniswa 176, okuyinto umphumela inqubo yengetiwe.

Graphic Indlela: Ukulungiselela

Yengetiwe ku-Excel, isibonelo okuyinto letinikwe lapha ngenhla, lena akuyona indlela kuphela ukuthola engaziwa amanani Intermediate umsebenzi Y (X) isethi ngokuqhubekayo okwaziwayo kakade. Ikakhulukazi, indlela sokuqhafaza ingasetshenziswa. Kungaba wusizo uma etafuleni elilodwa-agumenti ecacisiwe elilinganayo imisebenzi njengoba lowo kukhonjisiwe ngezansi (bheka. Iseli ngekheli B9).

Yengetiwe Excel kulokhu iqala isheduli ukwakhiwa. Ukuze wenze lokhu:

• kuthebhu "Faka" angawodwa ithebula ububanzi;
• ithuluzi block "Amashadi" isithonjana akhethiwe "Igrafu";
• e ohlwini oluvelayo, ukhethe lowo kangcono, ukulungela inhloso ethize.

Kusukela cell B9 isheduli esingenalutho ukuze waklebhula. Ngaphezu kwalokho, ikhona ezengeziwe umugqa X, okuyinto akudingekile, futhi eksisi evundla kabili esikhundleni amagugu agumenti ahlelwe ngokulandelana amaphuzu.

Yengetiwe Excel: isinqumo indlela ingcaca

Ake ihluzo processing. Ngenxa yalesi ezishisa kakhulu zikhipha izinhlayiyana okuqhubekayo umugqa oluhlaza futhi uyisuse ngokucindezela Susa, okuyinto on the ikhibhodi.

ke:

• ukwaba indiza lapho igrafu;
• khetha inkinobho "Khetha Idatha ..." kusuka kwimenyu yokuqukethwe;
• "Khetha Idatha Umthombo" ebhokisini kwesokudla, cindezela "Shintsha";
• chofoza uphawu nge umcibisholo ebomvu kuya kwesokudla emkhakheni "amalebula Ibanga-eksisi";
• ukwaba ububanzi A2: A11;
• chofoza inkinobho «OK»;
• futhi abangele iwindi "Idatha yomthombo Ukukhethwa";
• chofoza inkinobho "Amaseli efihlekile Akunalutho" elingezansi kwesobunxele;
• ku "Bonisa engenalutho Amaseli" umugqa inkinobho kuthiwa ihlelwe kabusha ku "Line" isikhundla bese ucindezela «OK»;
• uqinisekisa lesi senzo ngendlela efanayo.

Uma kwenziwe ngendlela efanele, igebe kuzosuswa, futhi yokuhamba isikhombisi iphuzu oyifunayo igrafu uzobona amagugu ohambelana agumenti futhi umsebenzi.

Ukusebenzisa umsebenzi ND ekhethekile

Manje ngoba sewuyazi ukuthi ungakwenza kanjani i yengetiwe Excel indlela sokuqhafaza noma opharetha "ISIBIKEZELO", ikhambi izinkinga eziningi ezingokoqobo ngawe ukuba kube budisi khulu. Kodwa akugcini lapho. uhlelo lwesipredishithi kusuka Microsoft uyakwazi ukuthola ukubaluleka esingaziwa umsebenzi usebenzisa umsebenzi LP.

Lokucabanga ukuthi sinomsebenzi isivele isakhiwa, yakhiwa isungule uphawu efanele esikalini. Ake sizame ukuba avale igebe. Ukuze wenze lokhu:

• Ithebula iseli elingalodwa sintula ukubaluleka umsebenzi;
• khetha isithonjana "Umsebenzi Faka";
• ku "Umsebenzi Iseluleki" ebhokisini "Izigaba" thola string "uhlu Okugcwele ngokulandelana kwezinhlamvu zamagama" (kwezinye izinguqulo wokugaya "Ihlola izakhiwo kanye namagugu");
• chofoza kwesithi "ND" anikine inkinobho «OK».

Ngemva kwalokho, kuseli B9 livela ukubaluleka iphutha "# N / A" Nokho, igrafu evulekile siqedwa ngokuzenzakalelayo.

Ungenza nakakhulu nje: ukwenza ikhibhodi kuseli B9 izimpawu "# N / A" (ngaphandle izingcaphuno).

yengetiwe bilinear

Ububanzi imisebenzi okuyiwona ungasebenzisa sekulingisa esebenzisa imisebenzi omunye variable, kunomkhawulo wemali. Ngakho-ke kunengqondo ukucabanga ukuthi ifomula kuyinto yengetiwe double isetshenziswa Excel. Izibonelo zingase zihluke kakhulu. Ngokwesibonelo kukhona itafula (bheka ngezansi.).

It liyadingeka ukuze ukubala ingcindezi komoya ukubaluleka esingangeminyaka 300 m ezingeni ukuphakama 25 m.

Ethebuleni ukwengeza okufakiwe ezintsha njengoba kukhonjisiwe kulesibonelo sibalo (bheka. Ngezansi).

Njengoba ubona, kwanezela ukuphakama cell ne-span e J1 futhi J2.

Ngu esikhundleni ezilandelanayo reverse "eqoqwe" megaformulu ezidingekayo ukuze uthole ingcindezi emoyeni at nemingcele ethize. Ukuze wenze lokhu:

• ukukopishela itekisi formula nge indawo yeseli J19 iseli J17;
• esikhundleni ku-formula ubheke J15 ukuze J15 cell Inani: J7 + (J8-J7) * J11 / J13;
• Phinda lezi zinyathelo kuze ifomula oyifunayo.

Ukusebenzisa spline

indlela Langaphambilini kuyinto ngempela nzima, ngakho kwezinye izimo akukhetha spline yengetiwe. Excel in essence yayo siqukethe ekutholeni yengetiwe umsebenzi φ (X) ngokuvumelana amafomula yohlobo olufanayo ngoba subsets ezahlukene agumenti. Ngaphezu kwalokho kwenziwe iboshiwe amagugu φ (x) namanye amagama ahlobene nalo ku amagugu umngcele agumenti ngayinye subsets. Ku-Excel le njongo kukhona imisebenzi ekhethekile kanye ngangokunokwenzeka ukubhala amamakhro ukuze VBA. Nokho, kumele esidalelwe umsebenzi othize, ngakho isifundo ngokuvamile akwenzi ingqondo.

Manje ngoba sewuyazi ukuthi kanjani ukubhala ifomula Excel ezimbili interpolating kahle noma ukuthola ukubaluleka esingaziwa umsebenzi komugqa ngokusebenzisa opharetha esakhelwe noma ihluzo. Sithemba ukuthi lolu lwazi uzokusiza ekuxazululeni izinkinga eziningi ezingokoqobo.