Basa reTabhuku ndiko kuverenga kweiyo kukosha kwebasa kune imwe neimwe yakakodzera nharo yakatsanangurwa nedanho rakananga mune yakatarwa miganhu yakasimbiswa. Maitiro aya chishandiso chekugadzirisa mabasa akasiyana siyana. Ndiwo mubatsiri wayo, unogona kuburitsa midzi ye equation, tsvaga yakakwira uye minima, gadzirisa mamwe mabasa. Nechirongwa chekuwedzera, tablation iri nyore kuita kupfuura kushandisa pepa, kubata uye Calculator. Ngatitsvagei kuti izvi zvinoitwa sei mukushandisa uku.
Tabulation kushandiswa
Tabulization inoiswa nekugadzira tafura iyo kukosha kwekupokana nedanho rakasarudzwa richanyoreswa mune imwe ikoramu, uye yechipiri - iyo basa rinoenderana nazvo. Zvadaro, pane hwaro hwekuverenga, unogona kuvaka chirongwa. Funga kuti izvi zvinoitwa sei pane mumwe muenzaniso.Kugadzira tafura
Gadzira tafura ine tafura ine columns X, umo kukosha kwekupokana kuchatiratidzirwa, uye f (x), uko basa rinoenderana rinoratidzwa. Semuenzaniso, tora iyo basa f (x) = X ^ 2 + 2x, kunyangwe basa rerudzi rupi chero ringave rinoshandiswa kuti maitiro eTabulation. Isu tinoisa nhanho (h) muhuwandu hwe 2. Muganho kubva ku -10 kusvika ku10,10 to 10. Zvino tinoda kuzadza iyo nharo yekora, takanamatira padanho 2 pamiganhu yechipiri pamiganhu yakatarwa.
- Muchitokisi chekutanga chekamuri "X" Enter kukosha "-10". Pakarepo mushure meizvozvo isu tinodzvanya pane iyo Enter bhatani. Izvi zvakakosha kwazvo, nekuti kana iwe ukaedza kushandisa mbeva, kukosha muchitokisi kuchashanduka kuita formula, uye mune iyi kesi hazvidikanwe.
- ZVESE ZVAKAWANDA ZVINOGONESESA ZVINOGONA KUTI VADZIDZWA NEMAHARA. Kunyanya sarudzo iyi yakakodzera kana huwandu hwenhaurwa hombe, uye nhanho yacho idiki.
Sarudza iyo sero ine kukosha kwekutanga kupokana. Ndichiri mu "Home" tab, tinya pane bhatani "Zadza", iro riri pane tepi iri mu "kurongedza" marongero "block. Mune runyorwa rwechiito chinoonekwa, ini ndinosarudza clause "kufambira mberi ...".
- Kufambira mberi kurongedza hwindo kunovhura. Mu "nzvimbo" parunyanga, isu tichaisa chinongedzo kuchinzvimbo "nemheremheni", sezvo tichiita tsika dzepfungwa dzinozoiswa muColumn, uye kwete muchikepe. Mu "nhanho", seta kukosha 2. Mu "Limit kukosha" munda, pinda iyo nhamba 10. Kuti utange kufambira mberi, tinya bhatani "OK".
- Sezvauri kuona, iyo ikholamu inozadzwa nemitengo ine gomba uye miganhu.
- Iye zvino iwe unofanirwa kuzadza iyo chikamu chebasa f (x) = x ^ 2 + 2x. Kuti uite izvi, muchitokisi chekutanga checumn inoenderana, nyora chirevo pane inotevera template:
= x ^ 2 + 2 * x
Panguva imwecheteyo, panzvimbo pekukosha kwe x tinotsiva iyo inoronga sero rekutanga kubva kune imwe ikhoramu ine nharo. Isu tinodzvanya pane iyo Enter bhatani kuratidza mhedzisiro yekuverenga pane iyo skrini.
- Kuti uverenge basa uye mune mamwe mitsara, isu tichashandisa zvakare tekinoroji ye autocomplete, asi mune iyi nyaya tichaisa iyo inozadza mucherechedzo. Isu tinogadza iyo yekukona kukona yekurudyi yekona yechitokisi umo iyo formula yatove iine. Iyo inozadza mucherechedzo inoonekwa, yakaunzwa muchimiro chemuviri muhukuru hwemuchinjiko. Clement iyo kuruboshwe bhatani bhatani uye kutambanudza ruzha padhuze nekhoramu yese yazadzwa.
- Mushure mekuita uku, iyo chikamu chose chine tsika dzebasa racho richa azere
Saka, basa rebhu rakaitwa. Pamwe chete, isu tinogona kuziva, semuenzaniso, kuti zvingangoita basa (0) rinowanikwa nehunyanzvi hwekupokana -2 uye pese pabasa mukati memiganhu yekupokana kubva -10 kusvika ku10 iri inowanikwa pane imwe pfungwa inoenderana neyekupokana 10, uye ndeye 120.
Chidzidzo: Maitiro ekuita auto-kuzadza muExcel
Kuvaka Graphics
Zvichienderana neiyo tab yebhuta iri patafura, unogona kuvaka chirongwa chebasa.
- Sarudza ese ese maitiro ari patafura nejishoor neiyo kuruboshwe bhatani bhatani. Ngatishandure ku "Insert" tab, mune chart chimbo chimbo block pane tepi isu tinodzvanya "Graphs" bhatani. Rondedzero yezvisarudzo zviripo zviripo zvinowanikwa. Sarudza mhando yatinofunga nezve yakakodzera kwazvo. Kwatiri, yakakwana, semuenzaniso, hurongwa hwakareruka.
- Mushure meizvozvo, chirongwa chechirongwa chinoita maitiro ekugadzira graph kubva pane yakasarudzwa tafura yetafura.
Kupfuurirazve, kana zvichidikanwa, mushandisi anogona kugadzirisa chati chazvino sezvazvinoita zvichishandiswa kushandisa zvidiki zvekushandisa nekuda kweizvi zvinangwa. Iwe unogona kuwedzera mazita emazwi eanoronga uye mifananidzo seyakazara, bvisa kana kutumidza zita rekuti ngano, bvisa mutsara wekukakavara, nezvimwe.
Chidzidzo: Maitiro ekuvaka hurongwa muExcel
Sezvatinoona, iyo tabulation basa, kazhinji, maitiro ari nyore. Chokwadi, kuverenga kunogona kutora nguva yakareba. Kunyanya kana miganhu yezvakakora ikava yakafara kwazvo, uye danho idiki. Zvakanyanya kuponesa nguva yekubatsira Excel auto-yakazara zvishandiso. Mukuwedzera, muchirongwa chimwe chete, pane hwaro hwemhedzisiro, iwe unogona kuvaka girafu yemharidzo yekuona.