Izindlela zokuhamba nge-Excel

Uhlelo lwe-Microsoft Excel akuyona nje umhleli wethebula, kodwa futhi nesicelo esinamandla sokubala okuhlukahlukene. Okungenani lokhu kungenzeka kubonakale ngenxa yezici ezakhelwe ngaphakathi. Ngosizo lweminye imisebenzi (opharetha), ungabeka nezimo zokubala ezibizwa ngokuthi yimibandela. Ake sibheke imininingwane eminingi ukuthi ungazisebenzisa kanjani lapho usebenza ku-Efpelle.

Ukusetshenziswa kwezinqubo

Izimo ziyizimo lapho lolu hlelo lusebenza ngezenzo ezithile. Zisebenza emisebenzini eminingana eyakhelwe ngaphakathi. Egameni labo, inkulumo ethi "uma" ikhona kakhulu. Kuleli qembu labasebenza, okokuqala, kuyadingeka ukuthi kuthi ukubala phansi, ukubalwa, uSilemli, eSumpembremlin. Ngaphezu kwama-opharetha ashumekiwe, izindlela eziku-Excel zisetshenziswa futhi ekufomeni okunemibandela. Cabanga ngesicelo sabo lapho usebenza ngamathuluzi ahlukahlukene alolu hlelo lwe-tabular ngemininingwane eminingi.

Ukubalwa

Umsebenzi oyinhloko we-akhawunti yomhlinzeki weqembu lezibalo ubala oqashwe ngamanani ahlukahlukene weseli anelisa isimo esithile esinikeziwe. I-syntax yayo ilandelayo:

= Amashejuli (ibanga; inqubomgomo)

Njengoba sibona, lo opharetha unezimpikiswano ezimbili. I- "Uhla" imelela ikheli lezinto eziningi eziningi eshidini lapho ukubalwa kufanele kubalwe khona.

"I-Criterion" yingxabano ebeka isimo ukuthi kufanele iqukathe amaseli endaweni ebekiwe ukuze ifakwe ekubalweni. Inkulumo yezinombolo, umbhalo noma ukuxhumana esitokisini lapho inqubomgomo etholakala ingasetshenziswa njengepharamitha. Ngasikhathi sinye, lezi zibonakaliso ezilandelayo zingasetshenziswa ukucacisa inqubo: "" ("" "" "" ("(" AKUFUNI "). Isibonelo, uma ucacisa inkulumo ethi "

Futhi manje ake sibone isibonelo, njengoba lo opharetha usebenza.

Ngakho-ke, kukhona itafula lapho imali engenayo ivinjelwa ezitolo ezinhlanu ngesonto. Sidinga ukwazi inani lezinsuku zalesi sikhathi, lapho esitolo 2 imali engenayo ekuthengisweni idlula ama-ruble ayi-15,000.

1. Khetha into yeqabunga lapho opharetha ezobonisa umphumela wokubalwa. Ngemuva kwalokho, chofoza isithonjana esithi "Insert Function".



2. Ukugijima iWizard yemisebenzi. Yenza ukufudukela kubhulokhi "yezibalo". Lapho sithola futhi siqokomise igama elithi "kubaliwe". Ngemuva kwalokho kufanele kuvalwe inkinobho ethi "Kulungile".



3. Ukwenza kusebenze ama-argany window of the opharetha okungenhla kwenzeka. Ensimini "ibanga", chaza indawo yamaseli, phakathi kwawo okuzobalwa. Kuthu, kufanele ukhethe okuqukethwe komugqa wesitolo 2, lapho imali engenayo itholakala ngosuku. Sibeka isikhombisi enkombeni ebekiwe futhi, sibambe inkinobho yegundane kwesobunxele, khetha uhlu olufanele etafuleni. Ikheli le-array elikhethiwe lizovela efasiteleni.

   Ensimini elandelayo, "inqubo" idinga nje ukucacisa ipharamitha yokukhethwa ngokushesha. Kuthu, udinga ukubala kuphela lezo zinto zetafula lapho inani lidlula i-15000. Ngakho-ke, sisebenzisa ikhibhodi, sishayela enkundleni ebekiwe "> 15000".

   Ngemuva kwakho konke ukukhohlisa okungenhla kwenziwa, ubumba enkombeni ethi "KULUNGILE".



4. Uhlelo lubalwa futhi lukhombisa umphumela we-sheet element, eyabelwe ngaphambi kokusebenzisa imisebenzi ye-Wizard. Njengoba ubona, kulokhu, umphumela ulingana nenombolo 5. Lokhu kusho ukuthi ku-array egqanyisiwe kumaseli amahlanu adlula amanani ayi-15000. Lokho, kungaphethwa ngokuthi esitolo 2 kwezihlanu Izinsuku ezivela emalini engenayo eyisikhombisa zedlula ama-ruble ayi-15,000.

Isifundo: Umsebenzi wezemisebenzi ohlelweni lwe-Excel

-Khulu Kunakwenzeka

Umsebenzi olandelayo osebenza inqubo uyabalwa. Iphinde ibhekise eqenjini labasebenzi bezibalo. Umsebenzi weseluleko ubala amaseli kuhlu olubekiwe olugcwalisa isethi ethile yezimo. Kuyiqiniso iqiniso lokuthi ungacacisa hhayi eyodwa, kepha amapharamitha ambalwa, futhi uhlukanise lo opharetha kwangaphambili. I-syntax ilandelayo:

= Countal (Range_Longs1; Isimo1; Range_Longs2; Isimo2)

"Uhla lwezimo" luyimpikiswano yokuqala ye-opharetha yangaphambilini. Okungukuthi, kubhekiselwa kule ndawo lapho kubalwa khona amaseli ekwanelisa izimo ezibekiwe zizobalwa. Lo opharetha ukuvumela ukuthi usethe izindawo eziningana ezinjalo ngasikhathi sinye.

"Isimo" yisikhombimi esinquma ukuthi yiziphi izinto ezivela ezinhlwini zemininingwane ehambelana nayo zizobandakanya ukubala, futhi okungeke kufakwe. Indawo ngayinye enikeziwe yedatha kufanele ichazwe ngokwahlukana, noma ngabe ihlangana. Kuyadingeka ukuthi zonke izakhiwo zisetshenziswe njengoba izimo zesimo zinenombolo efanayo yemigqa namakholomu.

Ukuze usethe nemingcele eziningana esifanayo endaweni idatha, isibonelo, ukubala inani lamaseli amagugu zitholakala angaphezu kwenani elithile, kodwa engaphansi kwezigidi enye inombolo, kusobala njengoba i-agumenti "Izimo" eziningana izikhathi ukuze ucacise elifanayo. Kodwa ngesikhathi esifanayo, criteria ezahlukene kumele icaciswe njengeyunithi agumenti elihambisana.

On the Ngokwesibonelo, sonke etafuleni okufanayo enzuzweni seviki ezitolo uzobona ukuthi isebenza kanjani. Sidinga ukwazi ukuthi inani emalanga eliviki lapho imali kuzo zonke lezi Izitolo safinyelela kuyinsakavukela wabavusela. amazinga Revenue zimi kanje:

• Thenga 1 - ruble 14000;
• Thenga 2 - ruble 15000;
• Thenga 3 - ruble 24000;
• Thenga 4 - ruble 11000;
• Thenga 5 - ruble 32000.

1. Zuku ngenhla, siqokomisa isikhombisi-elementi ishidi zokusebenza, lapho umphumela kuwumphumela idatha kucutshungulwa countersmith. Ubumba kwisithonjana se- "Insert Function".



2. Ukuya iNkosi Imisebenzi, futhi athuthele "Izibalo" block. Ohlwini, kubalulekile ukuthola igama indlela nokubalwa ukukhiqiza isabelomali salo. Ngemva kokubulala isinyathelo esithile, udinga ucindezele inkinobho "OK".



3. Ukulandela ukuqaliswa algorithm ngenhla yezenzo, iwindi agumenti kuvula agumenti letibalekako.

   Esikhathini "Isimo umncele" field, faka ikheli le-string lapho idatha yemali esitolo 1 ngeliviki itholakala. Ukuze wenze lokhu, wafaka isikhombisi emkhakheni bese ukhetha string elihambisana ethebuleni. Ukuxhumanisa ziboniswa iwindi.

   Njengoba sazi ukuthi i-esitolo 1, izinga nsuku zonke kwemali engenayo kuyinto ruble 14,000 ke emkhakheni "Isimo 1" faka inkulumo ethi "> 14000".

   Emkhakheni "Izimo isukela (3,4,5)" Amasimu, izixhumanisi imigqa nge ngenzuzo seviki esitolo 2, esitolo 3, esitolo 4 kanye nokugcina 5. Isenzo wenziwa algorithm ngokufanayo i-agumenti yokuqala yaleli qembu.

   Emkhakheni "CONDITION2", "Condition3", "Condition4" futhi "Condition5" sethula amagugu "> 15000", "> 24000", "> 11000" futhi "> 32000". Njengoba akunzima ukuqagela, lezi zimiso zivumelana enzuzweni isikhawu kokweqa sivamile esitolo elihambisana.

   Ngemva yonke idatha ezidingekile esengene (Amasimu 10 kuphela), cindezela inkinobho "OK".



4. Uhlelo ibalwa nokuboniswa umphumela esikrinini. Njengoba ubona, kuba kulingana nesibalo 3. Lokhu kusho ukuthi ngezinsuku ezintathu kusukela ngesonto ihlaziye, izimali kuwo wonke Izitolo kudlulwe kuyinsakavukela wabavusela.

Manje sizoshintsha umsebenzi ngandlela thile. Kufanele sibale inani lezinsuku lapho isitolo 1 sathola khona imali edlula ama-ruble ayi-14,000, kepha ngaphansi kwama-ruble angama-17,000.

1. Sibeka isikhombisi endaweni lapho okuvezwa khona kukhonjiswa ekhasini lemiphumela yokubala. Ubumba kwisithonjana se- "Insert Function" ngenhla komsebenzi wamaqabunga.



2. Njengoba sisanda kusebenzisa ifomula yendlela yokubala, manje akudingekile ukushintshela eqenjini "lezibalo" lemisebenzi. Igama lalesi sisebenzisi lingatholakala esigabeni esithi "10 muva nje". Siyigqabisisa bese uchofoza inkinobho ethi "Kulungile".



3. Iwindi elijwayelekile lezimpikiswano zezeluleko ze-opharetha ezivuliwe. Sibeka ikhesa kunkambu ye- "Isimo Range Range" futhi, ngokuthengisa inkinobho yegundane kwesobunxele, khetha wonke amaseli lapho imali etholakala khona itholakala 1. Itholakala emgqeni, obizwa ngokuthi "isitolo 1". Ngemuva kwalokho, izixhumanisi zendawo ebekiwe zizokhonjiswa efasiteleni.

   Okulandelayo, setha isikhombisi endle "Yesimo1". Lapha sidinga ukucacisa umngcele ophansi wamanani kumaseli azobamba iqhaza ekubalweni. Khombisa inkulumo ethi "> 14000".

   Ensimini "Yesimo", singena ekhelini elifanayo ngendlela efanayo efakwe enkundleni 'eyahlukaniswa' insimu, okungukuthi, futhi sethula izixhumanisi zamaseli anamanani wemali okuphuma kokuqala.

   Ensimini "Isimo2" khombisa umkhawulo ophezulu wokukhethwa: "

   Ngemuva kwazo zonke lezi zenzo zenziwa, sinobumba enkingeni ethi "KULUNGILE".



4. Uhlelo lukhipha umphumela wokubalwa. Njengoba sikwazi ukubona, inani lokugcina lingukuthi ngo-5. Lokhu kusho ukuthi ngezinsuku ezi-5 ukusuka kumanani afundwayo ayisikhombisa esitolo sokuqala kwasuselwa kuma-ruble asuselwa ku-14,000 kuya kwayi-17,000.

Smerei

Omunye opharetha osebenzisa izindlela uthule. Ngokungafani nemisebenzi eyedlule, kubhekiswa kubhulokhi yezibalo zabahlinzeki. Umsebenzi wayo ukufingqa idatha kumaseli ahambelana nesimo esithile. I-syntax yile:

= Buthule (ibanga; inqubomgomo; [range_suming])

Ukuxabana "kwe-Range" kukhombisa indawo yamaseli azohlolwa ukuze ahambisane nesimo. Eqinisweni, inikezwa ngomgomo ofanayo nengxabano efanayo yokusebenza komsebenzi.

"I-Criterion" yingxabano eyisibopho echaza ipharamitha yokukhetha yamaseli kusuka endaweni ethile ebekiwe ebizwa ngokuthi ifinyeziwe. Imigomo yemiyalo iyefana naleyo yezimpikiswano ezifanayo zabasebenza ngaphambili, ezazibhekwa ngaphezulu.

I- "Summotion Range" yingxabano ongayikhetha. Kubonisa indawo ethile ye-array lapho kuzokwenziwa khona ifingqiso. Uma ishiyiwe futhi ingacaciswanga, khona-ke ngokuzenzakalelayo kukholakala ukuthi ilingana nenani lempikiswano "yebanga" lokuphikisana ".

Manje, njengaso sonke isikhathi, cabanga ukusetshenziswa kwalolu hlelo lokusebenza ekusebenzeni. Ngokusekelwe etafuleni elifanayo, sibhekene nomsebenzi ukubala inani lemali engenayo esitolo 1 isikhathi, kusukela ngo-03/11/2017.

1. Khetha iseli lapho kuzokhonjiswa khona umphumela. Chofoza isithonjana se- "Insert Function".



2. Ukuya kwi-Master of Imisebenzi ku-block "mathematical", sithola futhi siqokomise igama elithi "athula". Ubumba enkombeni ethi "KULUNGILE".



3. Kuzokwethulwa iwindi lokuphikisana nalo. Inezinkambu ezintathu ezihambelana nezimpikiswano zopharetha obekiwe.

   Ensimini ethi "Range", singena endaweni yetafula lapho amanani ahlolwe khona ukuhambisana nemibandela ezotholakala. Kuthu, kuzoba umugqa wezinsuku. Sibeka isikhombisi kulo mkhakha futhi sabela wonke amaseli lapho kutholakala khona izinsuku.

   Njengoba sidinga ukusonga kuphela amanani emali engenayo, kusukela ngoMashi 11, khona-ke enkundleni "Criterion" siyashayela "> 10.03.2017".

   Emkhakheni we- "Summonation Range Right", udinga ukucacisa le ndawo yayo ehlangabezana nenqubo ebekiwe izofingqa. Kuthu, lawa amagugu wemali engenayo yomugqa wesitolo1. Khetha uhlu oluhambisanayo lwezinto zeshidi.

   Ngemuva kokwethulwa kwayo yonke le mininingwane yenziwa, chofoza inkinobho ethi "Kulungile".



4. Ngemuva kwalokho, into ebekiwe yeshidi yokusebenza izokhonjiswa umphumela womsebenzi wokucubungula idatha uthule. Kuthu, kulingana no-47921.53. Lokhu kusho ukuthi kusukela ngo-11.03.2017, futhi kuze kube sekupheleni kwesikhathi sokuhlaziywa, imali etholile yesitolo 1 kwakungama-rubles angama-47921.53.

Ibona

Siphothule ukucwaninga kwabasebenza abasebenzisa inqubo ngokuhlala emisebenzini ye-SMEMBREMLIN. Umsebenzi walo msebenzi wezibalo ukufingqa amanani wezindawo ezicacisiwe zetafula akhethwe ngamapharamitha amaningana. I-syntax yopharetha ecacisiwe imi ngalendlela elandelayo:

= Smereving (uhla lwe-summation; rangeni_longs1; Isimo1; Range_Longs2; Isimo2)

I- "Summentation Range" iyingxabano ebhekene nalolo hlu, amaseli lapho kufana khona nenqubomgomo ethile kuzosongwa.

"Uhla lwezimo" - Ingxabano emele uhlu lwemininingwane eqinisekile ukuze kuthobelwe;

"Isimo" yingxabano, okuyindlela yokukhipha ukuze ingezwe.

Lo msebenzi usho imisebenzi ngasikhathi sinye ngamasethi ambalwa abaqhubi abafanayo.

Ake sibheke ukuthi lo opharetha usebenza kanjani ekuxazululeni imisebenzi ngomongo wethebula lethu lemali engenayo kusuka ekuthengisweni kwezitolo ezithengisayo. Sizodinga ukubala imali engenayo esilethwa yisitolo 1 isikhathi kusuka ku-09 kuye ku-13 Mashi 2017. Ngasikhathi sinye, lapho imali engenayo ifingqa, lezo zinsuku yilezo zinsuku kuphela lapho imali eyedlula khona ama-ruble ayi-14,000 kufanele ibhekwe.

1. Futhi, khetha iseli ngokuphuma nobumba kwisithonjana se- "Insert Function".



2. E-Wizard yemisebenzi, okokuqala, senza ukushukumisela kwibhulokhi "lezibalo", futhi lapho sabela khona into ebizwa ngokuthi "Smerembremn". Senza ngokuchofoza inkinobho ethi "KULUNGILE".



3. Iwindi lezimpikiswano le-opharetha liqala, igama layo elikhonjiswe ngenhla.

   Faka isikhombisi emkhakheni webanga le-18. Ngokungafani nezimpikiswano ezalandela, le hlobo lohlobo lwayo futhi ikhomba khona kulolo hlu lwamanani lapho kuhlangana khona ingxoxo yedatha ehlangabezana nayo ngaphansi kwezindlela ezibonisiwe ezizokwenziwa. Bese ukhetha indawo ye-Store1 Line, lapho amanani wemali engenayo ebekwa khona endaweni ehambelana nokuhweba.

   Ngemuva kokuthi ikheli liboniswe ewindini, iya ensimini "Yesimo". Lapha sizodinga ukubonisa izixhumanisi zentambo ngezinsuku. Sikhiqiza isivimbelo inkinobho yegundane lesokunxele futhi siqokomise zonke izinsuku etafuleni.

   Sibeka ikhesa enkambini "yesimo1". Isimo sokuqala ukuthi sizofingqa idatha hhayi ngaphambi kukaMashi 09. Ngakho-ke, sifaka inani "> 03/03/2017".

   Hambisa kwizimo "ezihlangeni". Lapha kuyadingeka ukwenza izixhumanisi ezifanayo ezaziqoshwa kwinkambu ye- "Isimo Range Range RELT. Senza lokhu ngendlela efanayo, okungukuthi, ngokwakha umugqa nezinsuku.

   Faka ikhesi enkambu ye- "Isimo2". Isimo sesibili ukuthi izinsuku lapho imali etholakala khona kufanele ifinyeleleke khona akufanele ibe ngaphambi kukaMashi 13. Ngakho-ke bhala phansi le nkulumo elandelayo: "

   Iya emkhakheni we- "Izimo 2". Kulokhu, kudingeka siqokomise i-array efanayo, ikheli lawo elenziwa njengegama elifanayo le-fum.

   Ngemuva kokuthi ikheli le-array ebekiwe livela efasiteleni, iya emkhakheni "Isimo3". Njengoba kunikezwe ukuthi amanani kuphela azobamba iqhaza engqungqutheleni, inani lawo lidlula ama-ruble ayi-14,000, yethula irekhodi lalesi simo esilandelayo: "> 14000".

   Ngemuva kwesenzo sokugcina senziwa ngodaka inkinobho "KULUNGILE".



4. Uhlelo lubonisa umphumela eshidini. Ilingana no-62491.38. Lokhu kusho ukuthi isikhathi esivela ku-09 kuya ku-13 Mashi 2017, inani lemali engenayo lapho kusongezelela izinsuku ezingama-14,000 ama-ruble, afinyelela kuma-ruble angama-62491.38.

Ukufomatha okunemibandela

Okugcina, okuchazwe yithi, ithuluzi, lapho kusetshenziswa yimiphi inqubo, ukufometha okunemibandela. Kwenza uhlobo olucacisiwe lokufometha lwamaseli ahlangabezana nemibandela ebekiwe. Bheka isibonelo sokusebenza ngokufometha okunemibandela.

Sigcizelela lawo maseli etafula eliluhlaza okwesibhakabhaka, lapho amanani ngosuku adlula khona ama-ruble ayi-14,000.

1. Silwa yonke indawo yezinto ezihlelekile etafuleni, ekhombisa imali yezitolo ngosuku.



2. Ukuthuthela kuthebhu "Yasekhaya". Isithonjana esithi "Ukufometha Okunemibandela" sibekwe ku-block "izitayela" ethepheni. Uhlu lwezenzo luyavula. Sibeka phezu kwaso esimweni esithi "Dala umthetho ...".



3. Isizukulwane sokuhlelwa kokufomatha sisebenza. Endaweni yokukhetha insimu, sabela igama elithi "format amaseli kuphela aqukethe". Emkhakheni wokuqala webhlokhi yezimo kusuka ohlwini lwezinketho ezingenzeka, khetha u- "Inani Leseli". Ensimini elandelayo, khetha isikhundla esithi "OKWENGEZIWE". Kokugcina, sicacisa inani ngokwalo, enkulu yazo edingekayo ukufometha izakhi zetafula. Sine-14,000. Ukukhetha uhlobo lokufometha, ubumba kwinkinobho ye- "format ...".



4. Iwindi lokufometha alisebenzi. Ukuthuthela kuthebhu "Gcwalisa". Ukusuka kwimibala ehlongozwayo yemibala yokuthela, khetha okwesibhakabhaka ngokuchofoza kuyo ngenkinobho yegundane kwesobunxele. Ngemuva kokuthi umbala okhethiwe uvele endaweni "yesampula", ubumba enkombeni ethi "KULUNGILE".



5. Ngokuzenzakalelayo ibuyela ekukhiqizweni kokuhlelwa kokufomatha. Kuyo, zombili umbala oluhlaza okwesibhakabhaka ziboniswa endaweni yesampula. Lapha sidinga ukukhiqiza isenzo esisodwa: ukubekwa enkingeni ethi "KULUNGILE".



6. Ngemuva kokuqeda isenzo sokugcina, wonke amaseli we-array aqokonyisiwe, lapho inani liqukethe ngaphezu kwe-14000, lizogcwaliswa ngombala oluhlaza okwesibhakabhaka.

Ngokuningiliziwe mayelana namathuba okufomatha okunemibandela, kuchazwe kwi-athikili ehlukile.

Isifundo: Ukufomatha okunemibandela kuhlelo lwe-Excel

Njengoba ubona, ngosizo lwamathuluzi usebenzisa izindlela lapho usebenza, kungenzeka ukuxazulula imisebenzi ehlukahlukene kakhulu ku-Effel. Kungaba njengamanani wokubala namanani nokufomatha, kanye nokwenza imisebenzi eminingi. Amathuluzi amakhulu asebenza kulolu hlelo ngezinqubo, okungukuthi, ngezimo ezithile, lapho ekhipha isenzo esibekiwe, iqoqo lemisebenzi eyakhelwe ngaphakathi, kanye nokufomatha okunemibandela.