Ukusebenza amathebula "Excel": isinyathelo ngesinyathelo imiyalelo, izici kanye nezincomo

Iningi abasebenzisi computer ku-Windows izinhlelo esekelwe kwiqoqo-Microsoft Office ngokuqinisekile sibhekene MS Excel isicelo. Ngo abasebenzisi imfundamakhwela uhlelo kubangela ubunzima obuthile ekuthuthukisweni, nokho ukusebenza "Eksele" nge amafomula namathebula akunzima njengoba kungase kubonakale efika kuqala, uma wazi izimiso eziyisisekelo babeka phansi Isijobelelo.

Kuyini Excel?

Ngokwazo Excel kuyinto ephelele umshini zezibalo ukwenza sebuningini izibalo, we-Aljibhra, Trigonometric, nezinye imisebenzi ebudisi ngokufaka ukusebenza izinhlobo eziningana idatha eziyisisekelo, it is hhayi njalo ezihlobene wezibalo.

Ukusebenza amathebula "Excel" kusho ukusetshenziswa amathuba amaningi nenyunyana kanye ne-computing, futhi umbhalo osobala, nalamanye latinhlobonhlobo. Kodwa ohlelweni yayo yasekuqaleni ifomu ke badalelwa njengoba umhleli ezinamandla zezibalo. Nokho, abanye, thatha isicelo sokuqala nganoma yisiphi wokubala nge izici ezithuthukile. Iphutha Ezinohlonze!

Imisebenzi "Eksele" nethebula Wabasaqalayo: amaziyo kuqala nge esibonakalayo

Isinyathelo sokuqala ngemuva kokuvula uhlelo, umsebenzisi ubona kuwindo, equkethe izilawuli eziyisisekelo namathuluzi umsebenzi. Ezinguqulweni Kamuva, iwindi oluvelayo uma uqala isicelo, okuyinto uhlongoza ukwakha ifayela elisha, ngokwakhona ngokuthi "Incwadi 1" noma khetha isibonisi ngoba esinye isinyathelo.

Ukusebenza "Excel"-spreadsheet Wabasaqalayo ku esigabeni sokuqala ajwayelane hlelo kufanele igcine ngokunembile ukudala ithebula elingenalutho. Nakuba sibheka izakhi eziyisisekelo.

ensimini Main ithatha etafuleni ngokwayo, okuyinto ihlukaniswe amaseli. Ngasinye, ngokwezindlu zooyise, sibonga izixhumanisi mgudumbili - isiqu incwadi Inambalayini nekholomu (isibonelo, ukuthatha Excel 2016). Lokhu izinombolo kuyadingeka ukuze e ukuncika ifomula kungaba ukuchaza ngokucacile kahle idatha cell, ukusebenza kwe-okuyinto uzobe kukhiqizwa.

Kusukela phezulu, + njengasosukwini lokungivivinya ezinye izinhlelo zokusebenza ehhovisi, kukhona iqembu kwimenyu enkulu, futhi ngezansi nje - amathuluzi. Ngaphansi kwawo kukhona umugqa ekhethekile lapho ufaka ifomula, futhi kancane ngaphezulu kwesokunxele ungabona iwindi nge izixhumanisi iseli okwamanje (okuyinto isikwele). Ngezansi iphaneli ikhombisa amashidi kanye nokunyakaza ovundlile kwesitjheleli, futhi zitholakala ngaphansi inkinobho inkinobho futhi uhlobo lokusondeza. Ngakwesokudla kuyinto strip mpo ishidi ukuhambisa phezulu / phansi.

Imihlobo esisekelo wokusebenza kwedatha yokufaka lenyama

Ekuqaleni, kucatshangwa ukuthi umsebenzi "amatafula Eksele 'ngumsebenzisi Wabasaqalayo usuyijwayele imisebenzi ajwayelekile, isibonelo embhalweni umhleli efanayo iZwi.

Njengenjwayelo, itafula ungenza operation ikhophi noma idatha faka ahlabayo, faka umbhalo noma idatha yezinombolo.

Kodwa ngokubeka ehlukile kancane kusukela owenzelwe embizeni umbhalo abahleli. Iqiniso lokuthi uhlelo ekuqaleni amisiwe ukuqaphela ngokuzenzakalelayo ukuthi umsebenzisi nerejista e yiseli evuliwe. Isibonelo, uma ufaka string 01/02/2016, idatha kuzobhekwa njengoba usuku, futhi iseli esikhundleni izinombolo efakiwe izoba usuku ifomu lula - 02/01/2016. Shintsha isibonisi format kungaba ulula (ngaleso ngemva kwesikhashana).

Futhi ngakho kuba ngezinombolo. Ungafaka noma iyiphi idatha yezinombolo, ngisho nenombolo engafanele zedesimali, futhi izoboniswa ifomu lapho bonke babo bakujwayele ukubona. Kodwa, uma ufaka inombolo ephelele, ke izokwethulwa ngaphandle mantissa (zedesimali njengoba amaqanda). Guqula ezimbi zingenza nokuhlukileko.

Kodwa usuqedile, abasebenzisi abaningi imfundamakhwela ozama ukuthuthela iseli elilandelayo ngokusebenzisa yekhibhodi umcibisholo (efana nendlela kungenziwa eZwini amathebula). Futhi akusebenzi. Kungani? Kodwa kuphela ngoba umsebenzi nge "Excel"-spreadsheet lihlukile Igama umbhalo umhleli khulu. Inguquko esiyolandelwa ngokucindezela Enter noma ngokubeka isikwele asebenzayo kwesinye isitokisi ngokusebenzisa kwesokunxele ukuqhafaza igundane. Uma ngemva kokubhala okuthile iseli elisebenzayo, cindezela u-Esc, okokufaka izokhanselwa.

Izenzo ngamashidi

Ukusebenza amashidi ekuqaleni okungadala ubunzima akufanele. On iphaneli phansi has a ekhethekile inkinobho amashidi emva ngokucindezela okuzoba ithebula elisha nge ukudluliswa othomathikhi kuso bese ngokucacisa igama ( "Ishidi 1", "Page 2", njalo njalo. D.).

Chofoza kabili, ungakwazi kusebenze ekuqambeni kabusha noma iyiphi kuzo. Futhi, chofoza kwesokudla imenyu ingasetshenziswa ukubiza i imenyu eyengeziwe, lapho kukhona imiyalo ezimbalwa eziyisisekelo.

ifomethi amaseli

Manje into ebaluleke kakhulu - format yengqamuzana - omunye imiqondo eyisisekelo, okuyikhona inquma uhlobo idatha izosetshenziselwa ukuqashelwa lokuqukethwe zayo. Ishayela format ukuhlela kungenzeka ngokusebenzisa imenyu qhafaza kwesokudla-, lapho umugqa ezifanele kuyakhethwa noma ngokucindezela F2.

Iwindi ngakwesokunxele libonisa yonke nezakhiwo etholakalayo, futhi sibonisa ongakhetha for idatha isibonisi. Uma ubheka isibonelo nge usuku eboniswe ngenhla, njengoba format ekhethiwe, "Usuku", futhi ilungelo lokunquma ifomu oyifunayo (isibonelo, 1 February 2016).

ezinye ifomethi zingasetshenziswa ukufeza imisebenzi zezibalo, kodwa kunjalo elula, ukhetha Inombolo. Ngakwesokudla, kukhona izinhlobo eziningana zokungena, pointer nesibalo kwamadijithi emva iphuzu zamadesimali mantissa ensimini futhi wasishiyela isihlukanisi iqembu. Ukusebenzisa amanye ifomethi yezinombolo (lomchazi, ayingxenye, imali nokunye. D.), Too, kungenziwa usethe nemingcele oyifunayo.

Ngokuzenzakalelayo, ukuqashelwa idatha othomathikhi Ukusetha ifomethi evamile. Kodwa uma uthayipha izinhlamvu ezimbalwa noma uhlelo kungaba angesabi siguqulwa okunye. Ngakho-ke, ukuze ufake umbhalo for iseli esebenzayo kuyadingeka ukusetha inketho ezifanele.

Sebenza "Excel," nge amafomula (etafuleni): Isibonelo

Okokugcina, amazwi ambalwa mayelana amafomula. Okokuqala, ake sicabangele isibonelo isamba sezinombolo ezimbili ku A1 kanye A2. Isicelo kuhlanganisa inkinobho othomathikhi summation namanye imisebenzi eyengeziwe (ukubala arithmetic kusho esiphezulu, ubuncane, nokunye. D.). Simply ukufaka cell esebenzayo kukholamu esifanayo, engezansi, bese kukhethwa lemali kuzobalwa ngokuzenzakalelayo. Imisebenzi okufanayo amagugu ovundlile, kodwa iseli esebenzayo kwinani udinga ukulungiswa.

Kodwa ungakwazi ukufaka ifomula ngesandla (umsebenzi nge amatafula "Excel" futhi lisho kungenzeka ezifana lapho operation okuzenzakalelayo singanikezwanga). Ukuze esilinganayo kufanele kube kubha ifomula ukuba athi futhi zibeka ekusebenzeni A1 + A2 noma ISAMBA (A1; A2), futhi uma ufuna ucacise ibanga lamaseli, sebenzisa ifomu ngemva setshwayo: (A1: A20), ngemva kwalokho-ke ngeke it sinquma isamba sazo zonke izinombolo kumaseli kusukela ngowokuqala amabili, kukonke.

charting

Ukusebenza amathebula "Excel" Kuyathakazelisa ngalolo kuhilela ukusetshenziswa ekhethekile ngokuzenzakalela ithuluzi ugobe futhi imidwebo esekelwe esikhethiwe.

Ngenxa yale njongo, inkinobho ekhethekile ku iphaneli, emva ngokuchofoza okuyinto ungakhetha noma yimiphi imingcele noma ukubukeka oyifunayo. Ngemva kwalokho, ishadi noma igrafu uyibhala njengoba isithombe.

Cross-uxhumano, idatha kanye nokuthekelisa namazwe angaphandle

Uhlelo futhi ungakwazi ukufaka zokuxhumana idatha amashidi ezahlukene, ukusebenzisa izikhombo ukuze amanye amafayela format noma izinto kumaseva ku-intanethi, nezinye izengezo eziningi.

Ngaphezu kwalokho, amafayela e-Excel kungenziwa ukuthunyelwa kwezinye ifomethi (isib, PDF), ukukopisha idatha kusuka kubo, njalo njalo. D. Kodwa uhlelo kokuthi uvule amafayela wadala kwezinye izinhlelo zokusebenza (umbhalo ifomethi, yolwazi, amakhasi eWeb, XML- imibhalo, nokunye. d.).

Njengoba ubona, amathuba umhleli cishe angenamkhawulo. Futhi-ke, ukuchaza kubo bonke awulona isikhathi esanele. Nazi izinto eziyisisekelo nje kokuqala, kodwa umsebenzisi unesithakazelo kuyodingeka ufunde sendlalelolwati, ukuze balukhulume kahle uhlelo ezingeni eliphezulu kakhulu.