Indlela yokwengeza isithombe kumlando we-Instagram

I-Microsoft Excel akuyona nje umhleli wespredishithi, kodwa futhi nesicelo esinamandla kakhulu sokubala okuhlukahlukene. Okokugcina, lesi sici sinezici ezakhelwe ngaphakathi. Ngosizo lweminye imisebenzi (opharetha), kungenzeka ukuba ucacise ngisho nezimo zokubala, okubizwa ngokuthi yizidingo ezivamile. Ake sifunde kabanzi mayelana nokuthi ungayisebenzisa kanjani uma usebenza ku-Excel.

Isicelo sezinqubo

Imikhawulo yimiqathango lapho uhlelo lwenza khona izenzo ezithile. Zisetshenziswa ezinhlobonhlobo zemisebenzi eyakhelwe ngaphakathi. Igama labo ngokuvamile liqukethe inkulumo "UMA". Leli qembu lama-opharetha, okokuqala, kufanele lithathwe COUNTES, COUNTERSILN, Amanani, SUMMESLIMN. Ngaphandle kwama-opharetha akhiwe, i-Excel yokusebenza isetshenziselwa ukufometha okunemibandela. Cabanga ukusebenzisa kwabo lapho usebenza ngamathuluzi ahlukahlukene ale projekthi yetafula ngokuningiliziwe.

COUNTES

Umsebenzi oyinhloko womqhubi COUNTESe-group of statistical, yi-count of occupied values ​​of different cells okwanelisa isimo esithile esibekiwe. I-syntax yayo ilandelayo:

= COUNTERS (ibanga; umgogodla)

Njengoba ungabona, lo opharetha unezizathu ezimbili. "Range" ikheli lezinto eziningi ezitsheni lapho kubalwa khona inani.

"Criterion" - lena ingxabano ebeka isimo ukuthi amaseli wendawo ecacisiwe kumele abe nalokhu ukuze afakwe ohlwini. Njengoba ipharamitha, inkulumo yezinombolo, umbhalo, noma ukubhekisela kuseli eliqukethe umgomo kungasetshenziswa. Kulokhu, ukukhombisa umgomo, ungasebenzisa izinhlamvu ezilandelayo: "<" ("ngaphansi"), ">" ("okuningi"), "=" (kufana), "" ("akulingani"). Isibonelo, uma ucacisa inkulumo "<50", khona-ke ukubalwa kuzocabangela kuphela izakhi ezichazwe ngxabano "Range"lapho kunezinombolo zamanani ezincane ezingaphansi kuka-50. Ukusetshenziswa kwalezi zinhlamvu ukucacisa imingcele kuzofaneleka kuzo zonke ezinye izinketho, okuzoxoxwa kulokhu isifundo ngezansi.

Futhi manje ake sibheke isibonelo esithile sendlela lo opharetha asebenza ngayo ekusebenzeni.

Ngakho-ke, kukhona itafula elibonisa imali yezitolo ezinhlanu ngeviki. Sidinga ukuthola inombolo yezinsuku phakathi nalesi sikhathi, lapho imali engenayo yokuthengisa ye-Isitolo se-2 idlule ama-ruble angu-15,000.

1. Khetha ishidi leshidi lapho opharetha azokhipha khona umphumela wokubala. Emva kwalokho chofoza kusithonjana "Faka umsebenzi".



2. Qalisa Amakhosi omsebenzi. Hambisa ukuvimba "Isitatimende". Lapho sithola futhi sikhethe igama "COUNTES". Khona-ke kufanele uchofoze inkinobho "Kulungile".



3. Ukusebenza kwewindi lempikiswano ye-opharetha ngenhla. Ensimini "Range" bakhombise indawo yamaseli phakathi kwawo okuzobalwa khona. Esimweni sethu, khetha okuqukethwe komugqa. "Thenga 2"lapho izindinganiso zentengo ngosuku zikhona. Faka i-cursor enkambu ecacisiwe futhi, ubambe inkinobho yegundane lesokunxele, khetha i-array ehambisanayo etafuleni. Ikheli le-array ekhethiwe livela efasiteleni.

   Esikhathini esilandelayo "Criterion" kudingeka nje ukusetha ipharamitha yokukhetha ngokushesha. Esimweni sethu, udinga ukuthi ubale kuphela lezo zakhi zetafula lapho inani lingaphezu kuka-15,000. Ngakho-ke, ngokusebenzisa ikhibhodi, sifaka inkulumo emkhakheni ocacisiwe. ">15000".

   Emva kwakho konke okwenziwe ngenhla kwenziwa, chofoza inkinobho. "Kulungile".



4. Uhlelo lubala futhi lubonisa umphumela esakhiweni sekhasi elikhethiwe ngaphambi kokuqalisa. Amakhosi omsebenzi. Njengoba ubona, kulokhu umphumela ulingana nenombolo 5. Lokhu kusho ukuthi kumakhethi akhethiwe kunamaseli amahlanu kunamanani angaphezu kuka-15 000. Lokhu kungukuthi, singaphetha ngokuthi ku-Isitolo 2 ezinsukwini eziyisihlanu kusuka kulesi sikhombisa, imali engenayo ibuyele kuma-ruble angu-15,000.

Isifundo: I-Master of Imisebenzi e-Excel

COUNTERSILN

Umsebenzi olandelayo ophethe izinqubo COUNTERSILN. Iphinde ibe ngeqembu lezinombolo zama-operators. Umsebenzi COUNTERSILN ukubalwa kwamaseli ku-array ecacisiwe eyanelisa isethi ethile yemibandela. Kuyinto yokuthi ungacaciseli owodwa, kodwa imingcele eminingi, futhi uhlukanisa lo opharetha kusukela kwangaphambili. I-syntax ilandelayo:

= IKHAYA (isimo_yangezimo1; isimo1; isimo_range2; isimo2; ...)

"Isimo Somumo" kufana nokuphikisana kokuqala kwesitatimende sangaphambilini. Okusho ukuthi, yisixhumanisi endaweni lapho amaseli ahlangabezana nemibandela ecacisiwe azobalwa. Lo opharetha ikuvumela ukuthi ucacise izindawo eziningana ngalesi sikhathi.

"Isimo" kuyinto umgomo okhomba ukuthi yiziphi izakhi ezivela kwisethi yedatha ehambelanayo ezizobalwa, nokuthi yiziphi ezingenayo. Isifunda ngasinye esinikezwe idatha kufanele sicacise isimo ngokwahlukana, noma ngabe sihambisana. Kubalulekile ukuthi zonke izakhiwo ezisetshenziswe njengezindawo ezinemibandela zinenani elifanayo lemigqa namakholomu.

Ukuze usethe imingcele eminingana yedatha efanayo yedatha, isibonelo, ukubala inani lamaseli anamanani amanani kunenani elithile kodwa ngaphansi kwesinye isibalo sitholakala, ingxabano elandelayo isetshenziswa: "Isimo Somumo" izikhathi eziningana zicacisa okufanayo. Kodwa ngesikhathi esifanayo njengezingxabano ezihambelanayo "Isimo" kufanele ucacise izindlela ezihlukile.

Ukusebenzisa isibonelo setafula elifanayo ngokuthengisa masonto onke ezitolo, ake sibone ukuthi kusebenza kanjani. Sidinga ukuthola inombolo yezinsuku zeviki lapho imali engenayo kuzo zonke izigcawu ezicacisiwe kufinyeleleke esimweni esimisiwe esasungulwe sona. Izindinganiso zokuthola imali zilandelayo:

• Gcina ama-ruble angu-1 kuya ku-14,000;
• Gcina ama-ruble angu-2 kuya ku-15,000;
• Gcina ama-ruble angu-3 kuya ku-24,000;
• Gcina ama-ruble angu-4 kuya ku-11 000;
• Gcina ama-ruble angu-5 kuya ku-32,000.

1. Ukuze wenze umsebenzi ongenhla, khetha isici sephepha lokusebenzela ngesikhala lapho umphumela wokucubungula idatha uzoboniswa khona. COUNTERSILN. Sichofoza kusithonjana "Faka umsebenzi".



2. Iya ku Umsebenzi weWebhu, ukuhambisa ukuvimba futhi "Isitatimende". Uhlu kufanele lithole igama COUNTERSILN bese ukhetha. Ngemva kokwenza isenzo esicacisiwe, kufanele uchofoze inkinobho. "Kulungile".



3. Ukulandela ukukhishwa kwe-algorithm yesenzo esingenhla, iwindi lempikiswano ivuleka. COUNTERSILN.

   Ensimini "Isimo sesimo1" kufanele ufake ikheli lomugqa lapho idatha engenayo yeSitolo 1 seviki. Ukwenza lokhu, faka isikhombisi endle bese ukhetha umugqa ohambisanayo etafuleni. Ukuxhumanisa kuboniswa efasiteleni.

   Ukucabangela ukuthi kwisilinganiso seSitolo 1 nsuku zonke semali yi-ruble engu-14,000, bese ensimini "Isimo 1" faka inkulumo ">14000".

   Emasimini "Isimo Range2 (3,4,5)" Izixhumanisi zomugqa ngemali yamasonto onke ngokulandelana kweSitolo 2, Gcina 3, Gcina 4 futhi ugcine 5 kufanele kufakwe. Senza isenzo ngokuvumelana ne-algorithm efanayo efanayo ne-argument yokuqala yaleli qembu.

   Emasimini "Isimo2", "Isimo3", "Isimo4" futhi "Isimo5" siletha ngokulinganisa okulinganayo ">15000", ">24000", ">11000" futhi ">32000". Njengoba ungase ucabange, lezi zindinganiso zihambisana nengqikithi yenzuzo, edlulele esimeni sesitolo esivumelanayo.

   Emva kokufaka yonke imininingwane edingekayo (amasimu angu-10 ngokuphelele), chofoza inkinobho "Kulungile".



4. Uhlelo lubala futhi lubonisa umphumela esikrinini. Njengoba sibona, lilingana nenombolo 3. Lokhu kusho ukuthi ezinsukwini ezintathu kusukela ngesonto elihlaziyekile, imali engenayo kuzo zonke izitolo idlule izinga elimisiwe kubo.

Manje ake sishintshe umsebenzi kancane. Kufanele sibalwe inani lezinsuku lapho i-Shop 1 ithola khona imali engenayo i-ruble engu-14,000, kodwa i-ruble engaphansi kuka-17,000.

1. Beka isikhombisi kusici lapho umkhiqizo uzoboniswa eshadini lemiphumela yokubala. Sichofoza kusithonjana "Faka umsebenzi" phezu kwendawo yokusebenza yeshidi.



2. Njengoba sisanda kusebenzisa ifomula COUNTERSILN, manje akudingekile ukuya eqenjini "Isitatimende" Amakhosi omsebenzi. Igama lalo opharetha lingatholakala esigabeni "Kamuva Kusetshenziswa". Khetha bese uchofoza inkinobho. "Kulungile".



3. Ifasitela yama-opharetha opharetha asevele ajwayelekile kithi avula. COUNTERSILN. Faka i-cursor ensimini "Isimo sesimo1" futhi, uma ucindezela inkinobho yesinxele segundane, khetha wonke amaseli anenzuzo ngezinsuku zeSitolo 1. Atholakala emgqeni, obizwa ngokuthi "Thenga 1". Emva kwalokho, izixhumanisi zendawo ecacisiwe zizoboniswa efasiteleni.

   Okulandelayo, setha isikhangiso ensimini "Isimo1". Lapha sidinga ukucacisa umkhawulo ophansi wamagugu kumaseli azoba yingxenye ekubalweni. Cacisa inkulumo ">14000".

   Ensimini "Isimo sesigaba 2" sifaka ikheli elifanayo ngendlela efanayo esangena ensimini "Isimo sesimo1", okungukuthi, saphinda singene izixhumanisi zamaseli anemali evela ekutholeni kokuqala.

   Ensimini "Isimo2" ucacise umkhawulo ongaphezulu wokukhethwa: "<17000".

   Emva kwakho konke okushiwo kwenziwa, chofoza inkinobho. "Kulungile".



4. Lolu hlelo lunikeza umphumela wokubala. Njengoba sibona, inani eliphelele liyi-5. Lokhu kusho ukuthi ezinsukwini ezingu-5 kulaba abayisikhombisa abafundisiwe, imali engenayo esitolo sokuqala yayikude kusukela ku-14,000 kuya ku-17,000 rubleki.

Amanani

Omunye opharetha osebenzisa izinkomba Amanani. Ngokungafani nemisebenzi yangaphambilini, ibhekisela kubhulogi lwezibalo zama-opharetha. Umsebenzi walo ukufaka idatha kumaseli ahlangabezana nesimo esithile. I-syntax yile:

= AMAKHODI (ububanzi; umgomo; [sum_range]]

Ukuphikisana "Range" ikhomba endaweni yamaseli azohlolwa ukuze alandelwe. Eqinisweni, isethwe esimisweni esifanayo njengokuphikisana komsebenzi wegama elifanayo. COUNTES.

"Criterion" - ingxabano ephoqelekile ebeka ipharamitha yokukhetha amaseli kusuka endaweni ecacisiwe yedatha okungeziwe. Imigomo yokucacisa okufana neyodwa yeziphakamiso ezifanayo zamagatsha owedlule, okwakucatshangwa ngathi ngenhla.

"Isigaba sokubamba" - Lokhu kuyimpikiswano yokuzikhethela. Kubonisa isifunda esithile sendawo lapho kufakwa khona ukufingqwa. Uma uyishiya futhi ungacacisi, ngokuzenzakalelayo kubhekwa ukuthi lilingana nenani lempikiswano edingekayo "Range".

Manje, njengoba kunjalo, cabangela ukusetshenziswa kwalokhu opharetha ngokusebenza. Ngokusekelwe etafuleni elifanayo, sibhekene nomsebenzi wokubala inani lemali ku-Isitolo 1 isikhathi esiqala ngo-11.03.2017.

1. Khetha iseli lapho umphumela uzoboniswa khona. Chofoza kusithonjana "Faka umsebenzi".



2. Iya ku Umsebenzi weWebhu ku-block "Isibalo" thola bese ukhetha igama "SUMMESLI". Sichofoza inkinobho "Kulungile".



3. Iwindi lempikiswano yokusebenza iqala. Amanani. Inemikhakha emithathu ehambisana nezimpikiswano zomqhubi ocacisiwe.

   Ensimini "Range" singena endaweni yetafula lapho izindinganiso ezihlolwe ukuhambisana nemibandela zizotholakala khona. Esikhathini sethu kuyoba yinkambo yezinsuku. Faka i-cursor kule nkambu bese ukhetha wonke amaseli anezinsuku.

   Njengoba nje sidinga ukwengeza imali evela ku-Mashi 11, bese sisensimini "Criterion" sihamba ngokubaluleka ">10.03.2017".

   Ensimini "Isigaba sokubamba" kufanele ucacise indawo, amanani ayo ahlangabezana nawo okucacisiwe okuzobekwa ngawo. Esikhathini sethu, lezi yizilinganiso zokuthola imali emgqeni. "Isitolo1". Khetha izinto ezihambisanayo zeshidi.

   Ngemuva kokwethulwa kwedatha ecacisiwe, chofoza inkinobho "Kulungile".



4. Emva kwalokho, umphumela wokucutshungulwa kwedatha ngumsebenzi uzoboniswa esakhiweni esithile esicacisiwe sephepha lokusebenzela. Amanani. Esimweni sethu, lilingana no 47921.53. Lokhu kusho ukuthi kusukela ngo-11.03.2017, futhi kuze kube sekupheleni kwesikhathi esihlaziywe, imali engenayo ye-Isitolo 1 ibe ngama-ruble angu-47.921.53.

SUMMESLIMN

Sizoqedela ucwaningo lwabaqhubi abasebenzisa izindlela, ngokugxila emsebenzini SUMMESLIMN. Umsebenzi walo msebenzi wezibalo ukuhlanganisa amanani wezindawo ezikhonjisiwe etafuleni, okhethwe ngokwemigomo eminingana. I-syntax yalolu opharetha yile:

= I-SUMMESLIMN (isamba_imigomo_imigomo_imigomo_imigomo1; isimo1; isimo_imigomo2; isimo2; ...)

"Isigaba sokubamba" - Le ngxabano yikheli lamalungu, amangqamuzana ayo, ahambisana nomgudu othile, azofakwa.

"Isimo Somumo" - impikiswano emele idatha ehlukahlukene, ihlolwe ukuhambisana nesimo;

"Isimo" - Iphikisana elimelela umgomo wokukhetha wokufaka.

Lo msebenzi uhilela ukusebenza ngamaqoqo amaningana opharetha afanayo ngesikhathi esisodwa.

Ake sibone ukuthi lo mqhubi usebenza kanjani ekuxazululeni izinkinga kumongo wethebula lethu lokuthengisa kumaphoyinti okuthengisa. Sizodinga ukubala imali engenayo ye-Shop 1 yesikhathi kusuka ngoMashi 09 kuya ku-Mashi 13, 2017. Kulesi simo, ukufakwa kwemali engenayo kumele kubhekane nalezo zinsuku kuphela, inzuzo eyedlula ama-ruble angu-14 000.

1. Khetha iseli futhi ukuze ubonise inani futhi uchofoze kwisithonjana. "Faka umsebenzi".



2. Ngaphakathi Umsebenzi wizardOkokuqala, sithuthela ebhodini. "Isibalo", futhi lapho sikhetha into ebizwa "SUMMESLIMN". Chofoza inkinobho "Kulungile".



3. Iwindi lamaphuzu opharetha, igama lawo elibekwe ngenhla, liqalisiwe.

   Setha isikhombisi emkhakheni "Isigaba sokubamba". Ngokungafani nezimpikiswano ezalandela, lokhu kungomunye wothando futhi ukhomba amanani amanani lapho ukufakwa kwemininingwane ehambisana ne-criteria ecacisiwe kuyokwenziwa. Bese ukhetha indawo yomugqa "Isitolo1"Okufakwa kuzo izimali zengeniso ye-outlet ehambelanayo.

   Ngemuva kokuthi ikheli liboniswe efasiteleni, iya ensimini "Isimo sesimo1". Lapha kuzodingeka sibonise izixhumanisi zezintambo ngezinsuku. Senza isiqeshana senkinobho yesinxele segundane bese ukhetha zonke izinsuku etafuleni.

   Faka i-cursor ensimini "Isimo1". Isimo sokuqala ukuthi sizofingqa idatha hhayi ngaphambi kuka-Mashi 09. Ngakho-ke, singena inani ">08.03.2017".

   Hambisa ekuxabaneni "Isimo sesigaba 2". Lapha udinga ukufaka izixhumanisi ezifanayo ezirekhodiwe ensimini "Isimo sesimo1". Senza ngendlela efanayo, okungukuthi, ngokugqamisa umugqa ngamadethi.

   Setha isikhombisi emkhakheni "Isimo2". Isimo sesibili ukuthi izinsuku zokuthola imali angeke zenzeke ngaphambi kuka-Mashi 13. Ngakho-ke, bhala inkulumo elandelayo: "<14.03.2017".

   Iya ensimini "Isimo sesigaba 2". Kulesi simo, kudingeka sikhethe uhlu olufanayo lelokheli lalo elifakwe njengama-summation amaningi.

   Ngemuva kwekheli le-array ecacisiwe iboniswa efasiteleni, iya ensimini "Isimo3". Ukucabangela ukuthi izindinganiso kuphela ezidlula ama-ruble angu-14 000 azoba yingxenye yokufingqa, senza okulandelayo: ">14000".

   Emva kwesenzo sokugcina, chofoza inkinobho "Kulungile".



4. Lolu hlelo lubonisa umphumela eshadini. Ilingana no-62491.38. Lokhu kusho ukuthi kusukela kusukela mhla zingama-09 kuya ku-13 Mashi 2017, inani lemali engenayo uma uyengezela ngezinsuku lapho lidlula ama-ruble angu-14 000 abe ngama-ruble angama-62,491.38.

Ukufometha okunemibandela

Okokugcina, okuchazwe yithi, ithuluzi, lapho sisebenzisana nokuthi yiziphi izindlela ezisetshenziswayo, kufometha okunemibandela. Yenza uhlobo oluthile lwamaseli okufometha ahlangabezana nemibandela ecacisiwe. Bheka isibonelo sokusebenza ngokufometha okunemibandela.

Gqamisa lawo maseli etafuleni eluhlaza okwesibhakabhaka, lapho amanani osukwini adlula ama-ruble angu-14,000.

1. Khetha zonke izakhi ezisetafuleni, ezibonisa imali yokuthengiswa kwempahla ngosuku.



2. Hambisa kuthebhu "Ikhaya". Sichofoza kusithonjana "Ukufometha okunemibandela"efakwe ebhodini "Izitayela" kwi-tape. Uhla lwezenzo luvulwa. I-Klatsay kuyo endaweni "Dala umthetho ...".



3. Iwindow yokuhlela ifomathi yokufometha ivuliwe. Emkhakheni wemithetho yokukhetha uhlobo khetha igama "Fometha amaseli kuphela aqukethe". Esikhathini sokuqala saleso simo sivame ohlwini lokukhetha okungenzeka ukhetha "I-Cell Value". Esikhathini esilandelayo, khetha isikhundla "Okunye". Ekugcineni, sikhombisa inani ngokwalo, okukhudlwana kwalo ukufometha izakhi zetafula. Sinama-14,000. Ukuze ukhethe uhlobo lokufometha, chofoza inkinobho. "Fometha ...".



4. Iwindi yokufometha ivuliwe. Hambisa kuthebhu "Gcwalisa". Kusukela kokukhethwa kukho kombala okugcwalisiwe okukhethiwe, khetha ukwesibhakabhaka ngokuchofoza kuso ngenkinobho yegundane lesokunxele. Ngemuva kombala okhethiwe uboniswa ku "Isibonelo"chofoza inkinobho "Kulungile".



5. Ibuyela ngokuzenzekelayo efomini lokuhlela ifomathi yokufometha. Futhi endaweni "Isibonelo" kuboniswa nge-blue. Lapha sidinga ukwenza isenzo esisodwa esisodwa: chofoza inkinobho "Kulungile".



6. Ngemuva kwesenzo sokugcina, wonke amaseli wohlu olukhethiwe, olunezinombolo ezingaphezu kuka-14000, azogcwala umbala okwesibhakabhaka.

Ukuze uthole olunye ulwazi mayelana namathuba okufometha okunemibandela uchazwe kusihloko esithile.

Isifundo: Ukufometha okunemibandela ku-Excel

Njengoba sibona, ngosizo lwamathuluzi abasebenzisa imigomo emsebenzini wabo, ku-Excel eyodwa bangakwazi ukuxazulula imisebenzi ehlukahlukene. Lokhu kungaba kokubili kokubala nokulinganisa, nokufometha, kanye nokwenza eminye imisebenzi eminingi. Amathuluzi amakhulu asebenza kulolu hlelo ngezindinganiso, okungukuthi, ngezimo ezithile lapho lesi senzo sicushiwe khona, kuyisethi yemisebenzi eyakhelwe ngaphakathi, kanye nokufometha okunemibandela.