Umsebenzi imiphumela ephakathi ku-Excel

Lapho usebenza ngamatafula, kuvame ukuba nezimo lapho, ngaphezu kwemiphumela ejwayelekile, kuyadingeka ukuthulula nokuningiliziwe. Isibonelo, etafuleni lokuthengisa inyanga lapho umugqa ngamunye ngamunye ukhombisa inani lemali engenayo ekuthengisweni kohlobo oluthile lwezimpahla ngosuku, ungahlupha imiphumela yansuku zonke ekuthengisweni kwemikhiqizo yonke, futhi ekugcineni Ithebula, chaza inani lemali ephelele yanyanga zonke ebhizinisini. Ake sibheke ukuthi ungawenza kanjani imiphumela ephakathi kuhlelo lweMicrosoft Excel.

Kusetshenziswa umsebenzi "wemiphumela ephakathi" ku-Excel

Ngeshwa, akuwona wonke amatafula namasethi wedatha alungele ukusebenzisa imiphumela ephakathi nabo. Izimo eziphambili zimi kanjena:

• Ithebula kumele libe nefomethi yendawo evamile yamaseli;
• Isigqoko setafula kufanele sibe nomugqa owodwa bese sibekwe kulayini wokuqala weshidi;
• Ithebula akufanele libe imigqa ngedatha engenalutho.

Ukwakha imiphumela ephakathi e-Excel

Iya kwinqubo uqobo. Ngokusebenzisa lokhu, ithuluzi lihlangabezana nesigaba esihlukile esenziwe kwiphaneli ephezulu yohlelo.

1. Khetha noma isiphi iseli etafuleni bese uya kuthebhu yedatha. Chofoza inkinobho ethi "I-Intermediant Peeden", etholakala ethepheni ebhuthini "yesakhiwo".



2. Kuzovuleka iwindi lapho udinga ukumisa ukususwa kwemiphumela ephakathi. Esibonelweni sethu, kudingeka sibheke isamba semali ephelele yazo zonke izimpahla nsuku zonke. Inani ledethi litholakala kwikholomu yegama elifanayo. Ngakho-ke, ensimini "ngoshintsho ngakunye ku-", khetha ikholamu "yosuku".
3. In the "Operation", sikhetha inani "inani", njengoba sidinga ukungabonakali kahle usuku ngosuku. Ngaphezu kwenani, eminye imisebenzi eminingi iyatholakala, phakathi kwayo ungakwaba: inani, ubukhulu, ubuncane, umsebenzi.
4. Njengoba amanani wemali etholwayo ekhonjiswa "kwinani lemali engenayo, i-ruble" kholamu, bese enkombeni ethi "engeza" i-OTG ", akhethe ohlwini lwamakholomu etafula.
5. Ngaphezu kwalokho, udinga ukufaka umkhaza uma kungenjalo, eduze nepharamitha "buyisela imiphumela yamanje". Lokhu kuzovumela lapho kuvuselela itafula uma wenza inqubo yokubala imiphumela yesikhashana ngayo hhayi okokuqala, ungaphindi ukuqoshwa kwemiphumela efanayo.
6. Uma ubeka umkhaza "ekugcineni kwekhasi phakathi kwamaqembu" Into, lapho uprinta ibhulokhi ngayinye yetafula enomphumela ophakathi nendawo kuzophrintwa ekhasini elihlukile.
7. Lapho ungeza umkhaza obhekene nenani elithi "imiphumela ngaphansi kwedatha", imiphumela ephakathi izofakwa ngaphansi kwe-string block, isamba esilimele kuzo. Uma ususa umkhaza, khona-ke azokhonjiswa ngenhla kwemigqa. Kwabaningi, kulula kakhulu emigqeni, kepha okukhethiwe uqobo kukodwa.
8. Lapho usuqedile, chofoza ku-Ok.



9. Ngenxa yalokho, imiphumela ephakathi yavela etafuleni lethu. Ngaphezu kwalokho, wonke amaqembu ezintambo ahlanganiswa ngumphumela owodwa ophakathi nendawo angavuthwa ngokumane uchofoze esitezi "-" ngakwesobunxele setafula elibhekene neqembu elithile.



10. Ngakho-ke unganciphisa yonke imigqa etafuleni, ushiye imiphumela ephakathi nendawo nejwayelekile evamile ebonakalayo.



11. Kufanele futhi kuphawulwe ukuthi lapho kushintsha idatha emgqeni wetafula, imiphumela ephakathi izophinda iphinde iphinde iphinde iphinde iphinde iphinde iphinde iphinde iphinde ifinyeleleke.

Ifomula "I-Intermediate. Idatha"

Ngaphezu kwalokho okungenhla, kungenzeka ukuthi kuphume imiphumela ephakathi nendawo hhayi ngenkinobho etheyipini, kepha ngokubiza umsebenzi okhethekile nge- "Faka umsebenzi".

1. Ngemuva kokuchofoza esitokisini, lapho kuzokhonjiswa khona imiphumela emiphakathi, chofoza inkinobho ebekiwe, etholakala ngakwesokunxele sentambo yefomula.



2. "I-Master of Excents" izovuleka, lapho phakathi kohlu lwemisebenzi, sifuna into "Iphakathi nendawo. Umsebenzi". Siyiqokomise bese uchofoza u- "Kulungile".



3. Ewindini elisha, uzodinga ukufaka izimpikiswano zomsebenzi. Emugqeni "Inombolo Yokusebenza", faka inani lenye yezinketho zokucubungula idatha eziyishumi nanye, okungukuthi:
   • 1 - isilinganiso se-arithmetic value;
   • 2 - Inani lamaseli;
   • 3 - Inani lamaseli agcwele;
   • I-4 - inani eliphakeme ku-array yedatha ekhethiwe;
   • 5 - inani elincane;
   • 6 - Umkhiqizo wedatha kumaseli;
   • 7 - ukuphambuka okuyisibonelo okujwayelekile;
   • I-8 - ukuphambuka okujwayelekile kwenani elijwayelekile;
   • 9 - Isamba;
   • 10 - Isampula Ukuhlakazeka;
   • 11 - Ukuhlakazeka okwenziwa ngabantu jikelele.



4. Esibalweni "isixhumanisi 1", chaza ukuxhumana nalolo hlu lwamaseli ofuna ukuwabeka amanani aphakathi. Kuvunyelwe ukwethula ama-array amane ahlakazekile. Lapho ungeza izixhumanisi zebanga leseli, iwindi libonakala ngokushesha lengeza uhla olulandelayo. Njengoba akusizi kalula ukufaka uhla lwezandla kuwo wonke amacala, ungavele uchofoze inkinobho etholakala ngakwesokudla kwefomu lokufaka.



5. Umsebenzi wezimpikiswano zomsebenzi uzofika futhi ungavele ugqamise uhlu olufunayo lwedatha nesikhombisi. Ngemuva kokuthi ifakwe ngokuzenzakalelayo kwifomu, chofoza inkinobho ebekwe ngakwesokudla.



6. Iwindi lezingxoxo zomsebenzi liphinde livele. Uma udinga ukungeza enye idatha noma ngaphezulu idatha yedatha, sebenzisa i-algorithm efanayo echazwe ngenhla. Esimweni esiphambene, mane uchofoze Kulungile.



7. Imiphumela Ephakathi Yobubanzi Abazinikezele Idatha izokwakhiwa esitokisini lapho ifomula itholakala khona.



8. I-syntax yemisebenzi ngokwayo imi kanjena: I-Intermediates. Lezi (inombolo yokusebenza; ikheli_amissions_dasses). Esimweni sethu, indlela ifomula izobukeka kanjena: "I-Intermediate. Umsebenzi (9; C2: C6)". Lesi sici, sisebenzisa le syntax, singafakwa kumaseli nakule ngesandla, ngaphandle kokubiza i- "Master of Excences". Kubalulekile nje ukungakhohlwa ngaphambi kwefomula esitokisini ukusayina "=".

Ngakho-ke, kunezindlela ezimbili eziphambili zokwakha amanani aphansi aphakathi: ngenkinobho ethepheni nakwifomula ekhethekile. Ngaphezu kwalokho, umsebenzisi kufanele anqume ukuthi yiliphi inani elizoboniswa njengomphumela: inani, ubuncane, isilinganiso, inani eliphakeme, njll.