Ukutsalwa komsebenzi kwi-Excel: Imiyalelo eneenkcukacha

Umsebenzi wokuthimba ubalo lwexabiso lomsebenzi kwingxoxo nganye efanelekileyo echazwe kwinyathelo elithile kwimida esekwe kakuhle. Le nkqubo sisixhobo sokusombulula imisebenzi eyahlukeneyo. Ngoncedo lwayo, unokufaka ingeniso yeengcambu ze-equation, fumana iindawo eziphakamileyo kunye ne-minima, isombulula eminye imisebenzi. Ngenkqubo ye-Excel, i-Tablation ilula kakhulu ukuba yenze kunokusebenzisa iphepha, ukuphatha kunye ne-Calculator. Masifumanise ukuba kwenziwe njani kwesi sicelo.

Ukusetyenziswa kweThebhu

I-Tabulization isetyenziswa ngokwenza itafile apho ixabiso lengxoxo nenyathelo elikhethiweyo liya kurekhodwa kwikholamu enye, kwaye kumzuzwana-umsebenzi ohambelana nayo. Ke, kwisiseko sokubanga, unokwakha ishedyuli. Cinga ukuba kwenziwe njani oku kumzekelo othile.

Ukwenza itafile

Yenza itafile ngetafile enekholamu X, apho ixabiso lengxoxo luya kuboniswa, kwaye f (x), apho umsebenzi ohambelana nalo. Umzekelo, thatha umsebenzi f (x) = x ^ 2 + 2x, nangona umsebenzi walo naluphi na uhlobo olunokusetyenziselwa inkqubo yokutsalwa. Sibeka inyathelo (h) kwinani le-2. lomda ovela -10 ukuya kwi-10 ukuya kwi-10. Ngoku kufuneka sigcwalise ikholamu yengxoxo, sinamathela kwi-2 kwimida emiselweyo.

1. Kwiseli yokuqala yekholamu "X" Faka ixabiso "-10". Kwangoko emva koko sicofa kwiqhosha le-Enter. Oku kubaluleke kakhulu, kuba ukuba uzama ukuqhelisela imouse, ixabiso kwiseli liya kujika ibe yifomula, kwaye kule meko ayimfuneko.



2. Onke amaxabiso angaphezulu anokugcwaliswa ngesandla, anamathela kwinyathelo 2, kodwa kufanelekile ukwenza oku kusetyenziswa isixhobo se-Autof. Ngakumbi olu khetho lubalulekile ukuba uluhlu lweempikiswano lukhulu, kwaye inyathelo lincinci.

   Khetha iseli enexabiso lempikiswano yokuqala. Ngelixa "ekhaya" ithebhu, cofa kwiqhosha "lokugcwalisa", elikwe kwitheyiphu kwibhloko "yokuhlela". Kuluhlu lwesenzo esibonakalayo, ndikhetha igatya "inkqubela-phambili ...".



3. Ifestile yenkqubela phambili ivuliwe. Kwindlela "yendawo", sibeka iswitshi kwisikhundla "ngeekholamu", kuba kwimeko yethu amaxabiso empikiswano iya kubekwa kwikholamu, kwaye ayikho kumtya. Kwintsimi "yenqanaba", setha ixabiso 2. Kwixabiso "lexabiso le" umda ", faka i-10 le-10 kwiqhosha" Kulungile ".



4. Njengoko ubona, ikholamu izaliswe yimilinganiselo yesandi kunye nemida.



5. Ngoku kufuneka ugcwalise ikholamu yomsebenzi f (x) = x ^ 2X 2x. Ukwenza oku, kwiseli yokuqala yekholam ehambelana, bhala intetho kule template ilandelayo:

   = x ^ 2 + 2 * X

   Kwangelo xesha, endaweni yexabiso le-X esingenisayo ngokulungelelanisa isisele sokuqala kwikholamu ngeengxoxo. Sicofa kwiqhosha lokungena ukubonisa iziphumo zokubala kwiscreen.



6. Ukwenzela ukubala umsebenzi kwaye kweminye imigca, siya kuphinda sisebenzise itekhnoloji ye-autograsete, kodwa kule meko siya kusebenzisa iMark Remor. Sisolula isikhombisi kwikona esezantsi ngasekunene kwiseli apho ifomula sele iqulethe khona. Ukuzalelwa kokugcwalisa kuyavela, kuboniswe ngendlela encinci ngobukhulu bomnqamlezo. IClement iqhosha le mouse lasekhohlo kwaye yolule isikhombisi kuyo yonke ikholamu izele.



7. Emva kwesenzo, yonke ikholamu enemilinganiselo yomsebenzi iya kuzaliswa ngokuzenzekelayo.

Ke, umsebenzi wethebhu wenziwa. Ngenxa yoko, sinokufumanisa ukuba, umzekelo, ukuba ubuncinci umsebenzi (0) ufezekiswa ngamaxabiso empikiswano -2 kunye ne-0. Ifezekisiwe kwinqanaba elihambelana nengxoxo 10, kwaye ngu-120.

Isifundo: Ungazalisa njani ngokuzenzekelayo kwi-Excel

Imizobo yeMizobo

Esekwe kwithebhu edityanisiweyo etafileni, unokwakha ishedyuli yomsebenzi.

1. Khetha onke amaxabiso etafileni kunye nesikhombisi ngeqhosha lasekhohlo. Masiphendukele kwithebhu "Faka" ithebhu, kwisixhobo setshathi kwitheyiphu sicinezela iqhosha elithi "igrafu". Uluhlu lweendlela ezikhoyo zegrafiki ziyafumaneka. Khetha uhlobo esilujonga njengefanelekileyo. Kwimeko yethu, igqibelele, umzekelo, ishedyuli elula.



2. Emva koko, isoftware yenkqubo yenza inkqubo yokwakha igrafu esekwe kuluhlu olukhethiweyo lwetafile.

Ngapha koko, ukuba ufuna, umsebenzisi unokuhlela itshathi njengoko ibonakala iyimfuneko ukusebenzisa izixhobo ze-Excel ngezi njongo. Unokongeza amagama ee-axes zolungelelaniso kunye nemizobo epheleleyo, susa okanye gama kwakhona inqaku, susa umgca wempikiswano, njl.

Isifundo: Ungakha njani ishedyuli kwi-Excel

Njengoko sibona, umsebenzi wokutsalwa, ngokubanzi, inkqubo ilula. Kuyinyani, ukubala kunokuthatha ixesha elide. Ingakumbi ukuba imida yezahlulo zibanzi kakhulu, kwaye inyathelo lincinci. Igcinwe kakhulu ixesha lokuncedisa izixhobo ze-Excel ngokuzenzekelayo. Ukongeza, kwiprogram enye, kwisiseko sesiphumo, unokwakha igrafu ngentetho ebonakalayo.