Uhlolojikelele lwemisebenzi yezibalo ku-Excel (Ingxenye 1). Imisebenzi eyi-10 Ewusizo Kakhulu Yezibalo

Umsebenzi we-Excel yisitatimende esikuvumela ukuthi wenze ngokuzenzakalelayo inqubo ethile yokusebenza nesizindalwazi. Ziza ngezinhlobo ezahlukene: zezibalo, ezinengqondo nezinye. Ziyisici esiyinhloko salolu hlelo. Imisebenzi yezibalo ze-Excel iphakathi kwesetshenziswa kakhulu. Lokhu akumangazi, ngoba lolu wuhlelo olwaqalwa ukuze kube lula ukucutshungulwa kwenani elikhulu lezinombolo. Miningi imisebenzi yezibalo, kodwa nansi engu-10 ewusizo kakhulu. Namuhla sizozibuyekeza.

Ungayisebenzisa kanjani imisebenzi yezibalo ohlelweni?

I-Excel inikeza amandla okusebenzisa imisebenzi yezibalo ehlukene engaphezu kuka-60, ongenza ngayo yonke imisebenzi. Kunezindlela ezimbalwa zokufaka umsebenzi wezibalo kuseli:

1. Ukusebenzisa inkinobho ethi "Faka Umsebenzi", etholakala kwesokunxele sebha yokufaka yefomula. Kungakhathaliseki ukuthi iyiphi ithebhu yemenyu eyinhloko ekhethiwe okwamanje, ungasebenzisa le ndlela.
2. Sebenzisa ithebhu Amafomula. Kukhona nenkinobho enekhono lokufaka umsebenzi. Itholakala ohlangothini lwesobunxele kakhulu lwebha yamathuluzi.
3. Sebenzisa izinkinobho ezishisayo Shift+F3 ukuze usebenzise isilekeleli somsebenzi.

Indlela yokugcina iyona elula kunazo zonke, nakuba ekuboneni kuqala kunzima kakhulu ngenxa yesidingo sokubamba ngekhanda inhlanganisela yokhiye. Kodwa ngokuzayo, ingonga isikhathi esiningi uma ungazi ukuthi yimuphi umsebenzi ongasetshenziswa ukwenza isici esithile. Ngemva kokubizwa kwewizadi yomsebenzi, ibhokisi lengxoxo lizovela.

Kuyo ungabona uhlu lokuya phansi olunezigaba, futhi sinentshisekelo yokuthi abafundi abahlakaniphile bangayiqonda kanjani imisebenzi yezibalo. Okulandelayo, udinga ukukhetha osithandayo, bese uqinisekise izenzo zakho ngokucindezela inkinobho ethi KULUNGILE. Futhi, umsebenzisi angabona labo abathandayo futhi afunde incazelo yabo.

Okulandelayo, iwindi lizovela elinezimpikiswano okudingeka sizidlulisele kumsebenzi.

Ngendlela, ungakhetha imisebenzi yezibalo ngokushesha kusuka ku-tape. Ukuze wenze lokhu, udinga iphaneli kwesokunxele, chofoza isithonjana esigqanyiswe ngesikwele esibomvu, bese ukhetha umsebenzi owufunayo.

Ungakwazi futhi ukufaka umsebenzi ngokwakho. Kulokhu, kubhalwe uphawu olulinganayo, emva kwalokho igama lalo msebenzi lifakwe ngesandla. Ake sibone ukuthi lokhu kusebenza kanjani ngokunikeza amagama athile omsebenzi.

Uhlu lwemisebenzi yezibalo

Manje ake sibhale imisebenzi yezibalo ethandwa kakhulu esetshenziswa kuzo zonke izindawo ezingenzeka empilweni yomuntu. Lokhu kokubili kuwumsebenzi ojwayelekile osetshenziselwa ukwengeza inombolo enkulu yezinombolo ngesikhathi esisodwa, kanye namafomula aqanjiwe afana nalokhu I-SUMMESLI, eyenza imisebenzi eminingana eyahlukene ngesikhathi esisodwa. Kukhona nenani elikhulu lezinye izici esizozibhekisisa njengamanje.

Umsebenzi we-SUM

Lesi sici okwamanje sisetshenziswa kakhulu. Yakhelwe ukufingqa isethi yezinombolo ngokushintshana phakathi kwazo. I-syntax yalo msebenzi ilula kakhulu futhi iqukethe okungenani izimpikiswano ezimbili - izinombolo noma izinkomba zamaseli, okudingekayo okudingekayo. Njengoba ubona, akudingekile ukubhala izinombolo kubakaki, kungenzeka futhi ukufaka izixhumanisi. Kulesi simo, ungakwazi ukucacisa ikheli leseli kokubili ngesandla futhi ngokushesha etafuleni ngokuchofoza iseli elihambisanayo ngemva kokuba ikhesa ibekwe endaweni yokufaka. Ngemva kokuthi ingxabano yokuqala isifakiwe, kwanele ukucindezela inkinobho ethi Tab ukuze uqale ukugcwalisa elandelayo.

I-SUMMESLI

Ngokusebenzisa amafomula lapho lo msebenzi ubhalwe khona, umsebenzisi angakwazi ukubala isamba samanani ahlangabezana nemibandela ethile. Bazosiza ukwenza ngokuzenzakalelayo ukukhethwa kwamanani alingana nemibandela ethile. Ifomula ibukeka kanje: =I-SUMIF(Ububanzi, Imibandela, Ububanzi_Isamba). Siyabona ukuthi amapharamitha amaningana anikezwa njengemingcele yalo msebenzi:

1. Ibanga leseli. Lokhu kufaka lawo maseli okufanele ahlolwe abhekane nesimo esishiwo ku-agumenti yesibili.
2. Isimo. Umbandela ngokwawo, lapho ububanzi obucaciswe ku-agumenti yokuqala buzohlolwa. Izimo ezingenzeka zimi kanje: mkhulu kuno (uphawu >), ngaphansi kokuthi (uphawu <), awulingani (<>).
3. uhla lokuhlanganisa. Ububanzi obuzofingqwa uma impikiswano yokuqala ifana nesimo. Ububanzi bamaseli nokufinyela kungase kufane.

Impikiswano yesithathu ingokuzithandela.

Umsebenzi I-PRIVATE

Ngokuvamile, abasebenzisi basebenzisa ifomula evamile yokuhlukanisa izinombolo ezimbili noma ngaphezulu. Uphawu / lusetshenziselwa ukwenza lo msebenzi we-arithmetic. Ukungalungi kwale ndlela kuyafana nokwenza mathupha kwanoma iyiphi enye imisebenzi ye-arithmetic. Uma inani ledatha likhulu kakhulu, kunzima kakhulu ukubala ngendlela efanele. Ungakwazi ukwenza ngokuzenzakalelayo inqubo yokuhlukanisa usebenzisa umsebenzi I-PRIVATE. I-syntax yayo yile elandelayo: =INGXENYE(Inombolo, Idinominetha). Njengoba ubona, sinezimpikiswano ezimbili eziyinhloko lapha: inombolo kanye nenani eliphansi. Zihambisana nenombolo ye-arithmetic yakudala kanye nedinominayitha.

Umsebenzi UMKHIQIZO

Lokhu kuphambene nomsebenzi wangaphambilini, owenza ukuphindaphindeka kwezinombolo noma ububanzi obufakwe lapho njengama-agumenti. Ngendlela efanayo nemisebenzi efanayo yangaphambilini, lokhu kwenza kube nokwenzeka ukufaka ulwazi hhayi kuphela ngezinombolo ezithile, kodwa futhi nezigaba ezinamanani ezinombolo.

Umsebenzi I-ROUNDWOOD

Ukuzungeza kungenye yezenzo ezidume kakhulu ezindaweni ezahlukahlukene zokuphila komuntu. Futhi nakuba ngemva kokwethulwa kobuchwepheshe bekhompiyutha akudingekile njengangaphambili, le fomula isasetshenziselwa ukuletha inombolo ibe yifomu elihle elingenalo inani elikhulu lezindawo zamadesimali. Ngezansi ungabona ukuthi i-syntax ejwayelekile yefomula esebenzisa lo msebenzi ibukeka kanjani: =Umjikelezo(inombolo,inombolo_amadijithi). Siyabona ukuthi kukhona izimpikiswano ezimbili lapha: inombolo ezoba yindilinga kanye nenani lamadijithi elizobonakala ekugcineni.

Ukuzungezisa kuyithuba elihle lokwenza impilo ibe lula kumfundi wespredishithi uma ukunemba kungabalulekile. Impela noma yimuphi umsebenzi ojwayelekile uvumela ukusetshenziswa kokuzungeza, ngoba ezimweni zansuku zonke akuvamile kakhulu ukwenza imisebenzi lapho udinga ukwenza izibalo ngokunemba kwezinkulungwane eziyikhulu zenombolo. Lo msebenzi uzungeza inombolo ngokwemithetho ejwayelekile,

Umsebenzi AMANDLA

Abasebenzisi be-Excel abaqalayo bavame ukuzibuza ukuthi bangakhuphula kanjani inombolo emandleni. Kulokhu, kusetshenziswa ifomula elula, ephindaphinda ngokuzenzakalelayo inombolo ngokwayo inani elithile lezikhathi. Iqukethe izimpikiswano ezimbili ezidingekayo: = AMANDLA(inombolo, amandla). Njengoba ungabona ku-syntax, i-agumenti yokuqala ikuvumela ukuthi ucacise inombolo ezophindaphindwa inombolo ethile yezikhathi. Impikiswano yesibili izinga ezophakanyiswa ngalo.

Umsebenzi izimpande

Lo msebenzi ukuvumela ukuthi unqume impande eyisikwele yenani elinikezwe kubakaki. Isifanekiso sefomula sibukeka kanje: =IMPANDE(inombolo). Uma ufaka le fomula ngebhokisi layo lokufaka, uzobona ukuthi kune-agumenti eyodwa kuphela okufanele ifakwe.

Umsebenzi UKWAZI NGATHI

Lona omunye umsebenzi wezibalo okuvumela ukubala i-logarithm yenombolo ethile. Kudingeka izimpikiswano ezimbili ukuze kusebenze: inombolo nesisekelo se-logarithm. Impikiswano yesibili, ngokomthetho, iwukuzikhethela. Kulokhu, inani lizothatha lelo elihlelwe ku-Excel njengalelo elishiwo ngokuzenzakalelayo. Okusho ukuthi, 10.

Nokho, uma udinga ukubala idesimali logarithm, ungasebenzisa umsebenzi we-LOG10.

Umsebenzi INSASA

Uma ungakwazi ukuhlukanisa inombolo eyodwa nenye ukuze umphumela ube inombolo ephelele, kusho ukuthi ngokuvamile kufanele uthole esele. Ukuze wenze lokhu, udinga ukufaka ifomula =I-REMAID(inombolo, isihlukanisi). Siyabona ukuthi kunezingxabano ezimbili. Eyokuqala inombolo lapho umsebenzi wokuhlukanisa wenziwa khona. Eyesibili i-Disor, inani inombolo ehlukaniswa ngayo. Ungafaka le fomula ngokufaka amanani afanele kubakaki uma uyifaka mathupha, noma ngewizadi yokufaka umsebenzi.

Iqiniso elithakazelisayo: ukusebenza kokuhlukanisa ngensalela kubuye kubizwe ngokuthi ukuhlukaniswa okuphelele futhi kuyisigaba esihlukile sezibalo. Kuphinde kubizwe ngokuthi yi-modulo division. Kodwa ekusebenzeni, igama elinjalo lingcono kakhulu ukugwema, ngoba ukudideka ngamagama kungenzeka.

Imisebenzi yezibalo engadumile

Ezinye izici azidumile kangako, kodwa zisamukelwa kabanzi. Okokuqala, lokhu kuwumsebenzi okuvumela ukuthi ukhethe inombolo engahleliwe emhubheni othile, kanye neyodwa eyenza inombolo yesiRoma ngenombolo yesi-Arabhu. Ake sizibheke ngokuningiliziwe.

Umsebenzi PHAKATHI KWECALA

Lo msebenzi uyathakazelisa ngoba ubonisa noma iyiphi inombolo ephakathi kwevelu A kanye nevelu B. Ziphinde zibe izimpikiswano zayo. Inani A liwumkhawulo ophansi wesampula, futhi inani B liwumkhawulo ongaphezulu.

Azikho izinombolo ezingahleliwe ngokuphelele. Zonke zakhiwe ngokuvumelana namaphethini athile. Kodwa lokhu akuthinti ukusetshenziswa okungokoqobo kwalesi fomula, iqiniso elithakazelisayo kuphela.

Umsebenzi UMROMA

Ifomethi yenombolo ejwayelekile esetshenziswa ku-Excel isi-Arabhu. Kodwa futhi ungabonisa izinombolo ngefomethi yesiRoman. Ukuze wenze lokhu, ungasebenzisa umsebenzi okhethekile onezimpikiswano ezimbili. Elokuqala liyireferensi yeseli eliqukethe inombolo, noma inombolo ngokwayo. Ingxabano yesibili yifomu.

Naphezu kweqiniso lokuthi izinombolo zamaRoma azisavamile njengoba zazivamile, ngezinye izikhathi zisasetshenziswa ku-. Ikakhulukazi, lolu hlobo lokumelwa luyadingeka ezimweni ezinjalo:

1. Uma udinga ukurekhoda ikhulu leminyaka noma inkulungwane yeminyaka. Kulokhu, ifomu lokurekhoda limi kanje: Ikhulu le-XXI noma i-II millennium.
2. Ukuhlanganisa izenzo.
3. Если было несколько монархов с одним именем, то римское число обозначает его порядковый номер.
4. Ukuqokwa kwe-Corps eMbuthweni Wezempi.
5. On a military uniform in the Armed Forces, the blood type is recorded using Roman numerals so that a wounded unknown soldier can be saved.
6. Izinombolo zeshidi nazo zivame ukuvezwa ngezinombolo zesi-Roman ukuze izithenjwa ezingaphakathi kombhalo zingadingi ukulungiswa uma isandulela sishintsha.
7. Ukwakha ukumaka okukhethekile kokudayela ukuze wengeze umphumela oyivelakancane.
8. Ukuqokwa kwenombolo ye-serial yesenzeko esibalulekile, umthetho noma umcimbi. Ngokwesibonelo, iMpi Yezwe II.
9. Kumakhemikhali, izinombolo zesiRoman zisho ikhono lezakhi zamakhemikhali ukudala inani elithile lezibopho nezinye izakhi.
10. Ku-solfeggio (lesi isiyalo esifunda ukwakheka kohlu lomculo futhi sithuthukise indlebe yomculo), izinombolo zesiRoma zikhombisa inombolo yesinyathelo ebangeni lomsindo.

Izinombolo zesiRoman nazo zisetshenziswa ekubaleni ukubhala inombolo yokuphuma kokunye. Ngakho-ke, ububanzi bokusetshenziswa kwezinombolo zamaRoma bukhulu.

Сейчас почти не спользуются те форматы даты, которые подразумевают в виде римских цифр, но подобный способлько прособение пособенные способный способный способный способлюблющей область. Ситуации, в которых используются римские цифры, могут отличаться в разных странах. Например, в Литве они активно используются на дорожных знаках, для обозначения дней недели, а также на витринах.

Isikhathi sokufingqa okuthile. Amafomula e-Excel ayithuba elihle lokwenza impilo yakho ibe lula. Namuhla sinikeze i-TOP yemisebenzi yezibalo edume kakhulu kuma-spreadsheet akuvumela ukuthi wenze imisebenzi eminingi. Kodwa ukuxazulula izinkinga ezithile, amafomula akhethekile afaneleka kangcono.