NGIDINGA UKUFOMETHA IDRAYIVU ENTSHA YE-USB FLASH

Ngokuvamile, ukuhlolwa kusetshenziselwa ukuhlola ikhwalithi yolwazi. Zibuye zisetshenziselwe ukuhlolwa kwengqondo nezinye izinhlobo zokuhlolwa. Ku-PC, izicelo ezihlukahlukene ezikhethekile zivame ukusetshenziselwa ukubhala izivivinyo. Kodwa ngisho nehlelo elijwayelekile le-Microsoft Excel, elitholakala kumakhompyutha cishe kuwo wonke abasebenzisi, lingabhekana nalo msebenzi. Ukusebenzisa amathuluzi walolu hlelo lokusebenza, ungabhala ukuhlolwa, okusho ukuthi ukusebenza akukona kuncane kunezixazululo ezenziwe ngosizo lwe-software ekhethekile. Ake sibone ukuthi singayifeza kanjani lo msebenzi ngosizo lwe-Excel.

Ukuqaliswa kokuhlolwa

Noma yikuphi ukuhlolwa kuhilela ukukhetha eyodwa yezimpendulo eziningana kumbuzo. Njengomthetho, zikhona eziningana zazo. Kuyinto efiselekayo ukuthi emva kokuqeda ukuhlolwa, umsebenzisi usuvele uzibonele, ngabe uhlangane nokuhlolwa noma cha. Ungafeza lo msebenzi ku-Excel ngezindlela eziningana. Ake sichaze i-algorithm ngezindlela ezihlukahlukene zokwenza lokhu.

Indlela 1: inkambu yokufaka

Okokuqala, ake sibheke inketho elula. Lisho uhlu lwemibuzo lapho izimpendulo zinikezwa khona. Umsebenzisi kuzodingeka akhombise emkhakheni okhethekile ukuhluka kwempendulo ayibheka njengokulungile.

Sibhala phansi umbuzo ngokwawo. Masisebenzise izinkulumo zezibalo kulo mkhuba wokulula, kanye nezibalo ezihlukahlukene zesisombululo sabo njengezimpendulo.

Sakhetha iseli ehlukile ukuze umsebenzisi angene lapho inombolo yempendulo ayibheka njengokulungile. Ukuze ucacise, umaka ngephuzi.

Manje hamba eshidi lesibini lwedokhumenti. Kuzobekwa kuyo izimpendulo ezifanele lapho lolu hlelo luzoqinisekisa idatha ngomsebenzisi. Kwelinye iseli, bhala le nkulumo "Umbuzo 1", futhi ngakulandelayo sifaka umsebenzi IFokuyinto, eqinisweni, ezolawula ukufaneleka kwezenzo zomsebenzisi. Ukuze ushayele lo msebenzi, khetha iseli target bese uchofoza isithonjana "Faka umsebenzi"kufakwe eduze kwe-bar bar.

Iwindi elijwayelekile liqala. Amakhosi omsebenzi. Iya kusigaba "Logic" futhi ubuke igama lapho "UMA". Ukusesha akufanele kube yisikhathi kusukela leli gama libekwa kuqala ohlwini lwabaqhubi abanengqondo. Emva kwalokho ukhethe lo msebenzi bese uchofoza inkinobho. "Kulungile".

Ivuselela iwindi lempikiswano ye-opharetha IF. Opharetha ocacisiwe unezinkambu ezintathu ezihambelana nenombolo yezimpikiswano zalo. I-syntax yalo msebenzi ithatha ifomu elilandelayo:
= IF (Expression_Log; Value_If_es_After; Value_Ins_Leg)
Ensimini "Inkulumo ye-boolean" kudingeka ufake izixhumanisi zeseli lapho umsebenzisi engena khona impendulo. Ngaphezu kwalokho, ensimini efanayo udinga ukucacisa inguqulo efanele. Ukuze ufake izixhumanisi zeseli elihlosiwe, setha isikhangiso ensimini. Okulandelayo, sibuyela Ishidi 1 bese ubhala isici esasihlose ukubhala inombolo ehlukile. Izixhumanisi zayo ziboniswa ngokushesha emkhakheni wewindi lempikiswano. Ngaphezu kwalokho, ukuze ubonise impendulo efanele, ensimini efanayo, emva kwekheli leseli, faka inkulumo ngaphandle kwamacaphuno "=3". Manje, uma umsebenzisi efaka idijithi kuleso sici esilitshe "3", impendulo izobhekwa njengokulungile, nakuzo zonke ezinye izimo - akulungile.
Ensimini "Vumela uma kuyiqiniso" setha inombolo "1"futhi ensimini "Vumela uma kungamanga" setha inombolo "0". Manje, uma umsebenzisi ekhetha inketho efanele, uzothola 1 amaphuzu, futhi uma kungalungile 0 amaphuzu Ukuze ulondoloze idatha efakiwe, chofoza inkinobho "Kulungile" ngezansi kwewindi lezingxoxo.

Ngokufanayo, sibhala imisebenzi emibili (noma noma yikuphi okudingayo) kushidi elibonakala kumsebenzisi.

Vula Ishidi 2 usebenzisa umsebenzi IF kuchaza okukhethwa kukho okulungile, njengoba senze esikhathini esedlule.

Manje sihlela amagoli. Kungenziwa nge-auto sum sum. Ukwenza lokhu, khetha zonke izakhi eziqukethe ifomula IF futhi uchofoze ku-avtosummy yesithonjana, esitholakala ku-ribbon kuthebhu "Ikhaya" ku-block Ukuhlela.

Njengoba ungabona, inani lalingamaphuzu angu-zero, ngoba asiphendulanga into eyodwa yokuhlola. Inombolo enkulu kunazo zonke amaphuzu umsebenzisi angaphumelela kulolu cala - 3uma ephendula yonke imibuzo ngokufanele.

Uma ufisa, ungayenza ukuze inani lamaphoyinti ahlolwe lizoboniswa ohlwini lomsebenzisi. Okungukuthi, umsebenzisi uzobona ngokushesha ukuthi wakwazi kanjani ukubhekana nomsebenzi. Ukwenza lokhu, khetha iseli elihlukile Ishidi 1esikubiza "Umphumela" (noma elinye igama elihle). Ukuze ungabambisani isikhathi eside, faka nje inkulumo kuwo "= Sheet2!"bese ufaka ikheli laleso sici ku Ishidi 2Kuphi inani lamaphuzu.

Ake sihlole ukuthi ukuhlola kwethu kusebenza kanjani, ngenhloso yokwenza iphutha elilodwa. Njengoba ungabona, umphumela walolu vavanyo 2 amaphuzu, okuhambisana nephutha elilodwa. Ukuhlolwa kusebenza kahle.

Isifundo: Uma ngabe umsebenzi ku-Excel

Indlela 2: Uhlu lokudonsa phansi

Ungahlela futhi uhlolo ku-Excel usebenzisa uhlu lokudonsa phansi. Ake sibone ukuthi singakwenza kanjani lokhu ngokusebenza.

Dala itafula. Engxenyeni engakwesokunxele kuyoba nemisebenzi, engxenyeni ephakathi kuyoba nezimpendulo umsebenzisi okumelwe akhethe ohlwini oludonsela phansi olunikezwa unjiniyela. Uhlangothi olungakwesokudla luzobonisa umphumela, owenziwe ngokuzenzakalelayo ngokuhambisana nokufaneleka kwezimpendulo ezikhethiwe ngumsebenzisi. Ngakho, ukuqala, sizokwakha uhlaka lwetafula bese wethula imibuzo. Sebenzisa isicelo esifanayo esasetshenziswa endleleni yangaphambilini.

Manje kufanele senze uhlu ngezimpendulo ezitholakalayo. Ukuze wenze lokhu, khetha into yokuqala kukholomu "Phendula". Emva kwalokho iya kuthebhu "Idatha". Okulandelayo, chofoza isithonjana. "Ukuqinisekiswa kwedatha"esitholakala kwibhulogi yamathuluzi "Ukusebenza nedatha".

Ngemuva kokuqedela lezi zinyathelo, iwindi lokuhlola isamba elibonakalayo livuliwe. Hambisa kuthebhu "Izinketho"uma kuqaliswe kunoma iyiphi enye ithebhu. Okulandelayo ensimini "Uhlobo Lwedatha" kusuka ohlwini lokudonsa phansi, ukhethe inani "Bhala". Ensimini "Umthombo" emva kwe-semicolon, udinga ukurekhoda izinketho zezinqumo ezizoboniswa ukukhethwa ohlwini lwethu lokuhlaselwa. Bese uchofoza inkinobho. "Kulungile" ngezansi kwewindi elisebenzayo.

Ngemva kwalezi zenzo, isithonjana ngesimo soxantathu ene-angle ekhomba phansi sizovela ngakwesokudla kweseli ngamanani angenisiwe. Ukuchofoza kuyo kuzovula uhlu ngezinketho esizifakile ngaphambili, okunye okumele kukhethwe.

Ngokufanayo, senza izinhlu zamanye amaseli kukholomu. "Phendula".

Manje kufanele sikwenze lokho kumaseli ahambelana nekholomu "Umphumela" iqiniso lokuthi impendulo yalo msebenzi yayilungile noma cha yaboniswa. Njengendlela yangaphambilini, lokhu kungenziwa ngokusebenzisa opharetha IF. Khetha ikholomu yokuqala yekholomu. "Umphumela" futhi shayela Umsebenzi weWebhu ngokuchofoza isithonjana "Faka umsebenzi".

Okulandelayo Umsebenzi weWebhu usebenzisa indlela efanayo echazwe ngendlela eyedlule, iya efasiteleni lempikiswano yokusebenza IF. Iwindi elifanayo esilibonayo kulesi sihloko sangaphambili livule ngaphambi kwethu. Ensimini "Inkulumo ye-boolean" ucacise ikheli leseli lapho sikhetha khona impendulo. Okulandelayo, faka uphawu "=" bese ubhala isisombululo esifanele. Esikhathini sethu kuyoba inombolo. 113. Ensimini "Vumela uma kuyiqiniso" sabeka inani lamaphoyinti esifuna ukuthi umsebenzisi akhokhiswe isinqumo esifanele. Vumela lokhu, njengokwesikhashana esidlule, kube inombolo "1". Ensimini "Vumela uma kungamanga" setha inani lamaphoyinti. Uma kwenzeka isinqumo esingalungile, masibe naso. Ngemva kokusebenza okungenhla, chofoza inkinobho. "Kulungile".

Ngokufanayo, sisebenzisa lo msebenzi IF kumaseli asele ekholomu "Umphumela". Ngokuvamile, esimweni ngasinye esimweni "Inkulumo ye-boolean" Kuyoba khona inguqulo yayo yesinqumo esifanele esifana nombuzo kulolu gqa
Emva kwalokho senza umugqa wokugcina, lapho inani lamaphuzu lizofakwa khona. Khetha wonke amaseli kukholomu. "Umphumela" bese uchofoza isithonjana se-avtoumum esivele sijwayele kithi kuthebhu "Ikhaya".

Ngemuva kwalokho, usebenzisa uhlu lokudonsa phansi kumaseli ekholomu "Phendula" Sizama ukukhomba izinqumo ezifanele zemisebenzi eyabelwe. Njengasendabeni yangaphambili, senza iphutha ngenhloso endaweni eyodwa. Njengoba sibona, manje asibona nje umphumela wokuhlola jikelele, kodwa futhi nombuzo othize, isisombululo esinephutha.

Indlela 3: Sebenzisa Ukulawula

Ukuhlolwa kungenziwa futhi ngokusebenzisa izinkinobho zokulawula inkinobho ukukhetha izixazululo.

Ukuze ukwazi ukusebenzisa izinhlobo zokulawula, okokuqala, kufanele uvule ithebhu "Unjiniyela". Ngokuzenzakalelayo kukhutshaziwe. Ngakho-ke, uma kungakaze kusebenze kunguqulo yakho ye-Excel, kuzomele kwenziwe ezinye izinyathelo. Okokuqala, hamba kuthebhu "Ifayela". Lapho siya kwesigaba "Izinketho".

Iwindi yemingcele ivuliwe. Kufanele ifinyelele esigabeni Ukusethwa kweRibhoni. Okulandelayo, ngakwesokudla kwefasitela, hlola ibhokisi eduze kwesimo "Unjiniyela". Ukuze izinguquko zisebenze chofoza inkinobho "Kulungile" phansi kwefasitela. Ngemuva kwezinyathelo, ithebhu "Unjiniyela" izovela kutheyipu.

Okokuqala, singena umsebenzi. Uma usebenzisa le ndlela, ngamunye wabo uzofakwa ephepheni elihlukile.

Ngemuva kwalokho, iya kuthebhu esanda kusebenzwa "Unjiniyela". Chofoza kusithonjana Namathiselaesitholakala kwibhulogi yamathuluzi "Ukulawula". Eqoqweni lezimpawu Ama-Form Controls khetha into ebizwa "Shintsha". Inesimo somshini ojikelezayo.

Sichofoza endaweni yombhalo lapho sifuna ukubeka khona izimpendulo. Yilapho ukulawulwa esikudingayo kuvela khona.

Khona-ke sifaka esinye sezixazululo esikhundleni segama lezinkinobho ezijwayelekile.

Ngemuva kwalokho, khetha into bese uchofoze kuso nge inkinobho yegundane efanele. Kusukela kuzinketho ezitholakalayo, khetha into "Kopisha".

Khetha amaseli ngezansi. Khona-ke sichofoza ngakwesokudla ekukhethweni. Ohlu oluvela, khetha isikhundla Namathisela.

Bese sifaka izikhathi ezimbili, ngoba sinqume ukuthi kuzoba nezixazululo ezine, nakuba kuleso simo ngasinye inombolo yabo ingahluka.

Bese uqamba kabusha inketho ngayinye ukuze ingalingani nomunye nomunye. Kodwa ungakhohlwa ukuthi enye yezinketho kumele ibe yiqiniso.

Okulandelayo, senza into yokuya emsebenzini olandelayo, futhi kulokhu lokhu kusho ukushintshela kushidi elilandelayo. Futhi, chofoza isithonjana Namathiselaitholakala kuthebhu "Unjiniyela". Lesi sikhathi siyaqhubeka nokukhethwa kwezinto eziqenjini. "ActiveX Elements". Ukukhetha into "Inkinobho"enefomu.

Chofoza endaweni yedokhumenti, elitholakala ngaphansi kwedatha efakiwe ngaphambili. Emva kwalokho, ibonisa into esiyidingayo.

Manje sidinga ukushintsha ezinye izakhiwo zebhokisi eliholele. Chofoza kuso nge inkinobho yesinxele yegundane futhi kwimenyu evuliwe ukhethe isikhundla "Izakhiwo".

Ifasitela yezindawo zokulawula zivula. Ensimini "Igama" shintsha igama kulowo ozosebenza kakhulu ngale nto, kusibonelo sethu kuyoba yigama "Next_ Umbuzo". Qaphela ukuthi akukho zikhala ezivunyelwe kule nsimu. Ensimini "Amazwibela" faka inani Umbuzo olandelayo ". Kukhona izikhala ezivele zivunyelwe, futhi leli gama lizobonakala kubhathini lethu. Ensimini "I-BackColor" khetha umbala ukuthi into ezoba nayo. Ngemuva kwalokho, ungavala iwindi lempahla ngokuchofoza isithonjana sokuvala esisezingeni eliphezulu ngakwesokudla.

Manje schofoza ngakwesokudla egameni leshidi langamanje. Emenyu evula, khetha into Qamba kabusha.

Emva kwalokho, igama leshidi lisebenza, futhi singena lapho igama elisha. "Umbuzo 1".

Futhi, chofoza kukho inkinobho yegundane elilungile, kodwa manje kwimenyu simisa ukhetho entweni "Hambisa noma ukopishe ...".

Ifasitela lokudala ikhophi lisunguliwe. Siphatha ibhokisi eceleni kwento "Yakha ikhophi" bese uchofoza inkinobho "Kulungile".

Emva kwalolu shintsho igama leshidi ku "Umbuzo 2" ngendlela efanayo nangaphambili. Leli shidi liqukethe okuqukethwe okufana ngokuphelele njengephepha langaphambilini.

Sishintsha inombolo yomsebenzi, umbhalo, nezimpendulo kuleli shidi kulabo esibhekwa njengadingekile.

Ngokufanayo, dala futhi ushintshe okuqukethwe kwekhasi. "Umbuzo 3". Kuphela kulo, ngoba lo msebenzi wokugcina, esikhundleni segama le-inkinobho Umbuzo olandelayo " ungafaka igama "Ukuhlolwa Okuphelele". Indlela yokwenza lokhu ixoxwa ngaphambilini.

Manje buyela kuthebhu "Umbuzo 1". Sidinga ukubopha ushintsho esitokisini esithile. Ukwenza lokhu, chofoza ngakwesokudla kunoma yikuphi ukushintshwa. Emenyu evula, khetha into "Fometha into ...".

Iwindi lefomathi yokulawula ivuliwe. Hambisa kuthebhu "Lawula". Ensimini "I-Cell Link" sabeka ikheli lento engenalutho. Inombolo izoboniswa kuyo ngokuhambisana noshintsho oluqondile oluzosebenza.

Senza inqubo efanayo kumashidi neminye imisebenzi. Ukuze kube lula, kuyadingeka ukuthi iseli elixhunyiwe libe endaweni efanayo, kodwa kumashidi ahlukene. Emva kwalokhu, sibuyela ohlwini futhi. "Umbuzo 1". Chofoza ngakwesokudla entweni Umbuzo olandelayo ". Emenyu, khetha isikhundla "Ikhodi Yomthombo".

Umhleli womyalo uvula. Phakathi kwamaqembu "Sub Sub" futhi "Qedela" kufanele sibhale ikhodi yokuguqula kuthebhu elandelayo. Kulesi simo, kuzobukeka kanje:
Ama-Worksheet ("Umbuzo 2"). Yenza kusebenze
Ngemva kwalokho, vala iwindi lomhleli.

Ukuphathwa okufana nale nkinobho ehambelanayo kwenziwa eshadini "Umbuzo 2". Kuphela lapho singena umyalo olandelayo:
Ama-Worksheets ("Umbuzo 3"). Yenza kusebenze

Kumhleli womyalo wephepha lebhokisi "Umbuzo 3" yenza okulandelayo:
Ama-Worksheet ("Umphumela"). Yenza kusebenze

Emva kwalokho dala ishidi elisha elibizwa "Umphumela". Izobonisa imiphumela yokudlula ukuhlolwa. Ngale njongo, sakha itafula lamakholomu amane: "Inombolo yombuzo", "Impendulo efanele", "Impendulo yangena" futhi "Umphumela". Faka ikholomu yokuqala ngokulandelana kwemisebenzi "1", "2" futhi "3". Ekholini yesibili phambi komsebenzi ngamunye, faka inombolo yesikhawulo eshintshayo ehambisana nesisombululo esifanele.

Esitokisini sokuqala ensimini "Impendulo yangena" beka uphawu "=" futhi ucacise isixhumanisi esitokisini esixhumene neshintsho kushidi "Umbuzo 1". Senza okufanayo namaseli angezansi, kuphela kubo esibonisa ukubhekisela kumaseli ahambelana namashidi "Umbuzo 2" futhi "Umbuzo 3".

Emva kwalokho ukhethe isici sokuqala sekholomu. "Umphumela" bese ubiza iwindi lempikiswano yokusebenza IF ngendlela efanayo esayikhuluma ngayo ngenhla. Ensimini "Inkulumo ye-boolean" ucacise ikheli leseli "Impendulo yangena" line ehambisanayo. Bese ubeka uphawu "=" futhi ngemva kwalokho sichaza izixhumanisi zesici kukholomu "Impendulo efanele" umugqa ofanayo. Emasimini "Vumela uma kuyiqiniso" futhi "Vumela uma kungamanga" sifaka izinombolo "1" futhi "0" ngokulandelana. Emva kwalokho, chofoza inkinobho "Kulungile".

Ukuze ukopishe leli fomula ebangeni elingezansi, faka isikhombisi ekhoneni elingezansi elingakwesokudla kwesici lapho umsebenzi ukhona khona. Ngesikhathi esifanayo, uphawu lokugcwalisa luvela ngesimo sesiphambano. Chofoza inkinobho yegundane lesokunxele bese uhudula umaki phansi ekupheleni kwetafula.

Ngemuva kwalokho, ukufingqa inani, sisebenzisa isamba semali, njengoba sekuvele kwenziwe kaningi.

Kulesi sivivinyo sokuhlola singacatshangwa siphelele. Ukulungele ngokuphelele le ndima.

Sigxile ezindleleni ezihlukahlukene zokwakha ukuhlolwa usebenzisa amathuluzi we-Excel. Yiqiniso, lokhu akulona uhlu oluphelele lwazo zonke izinketho zokudala ukuhlolwa kulolu hlelo lokusebenza. Ngokuhlanganisa amathuluzi ahlukahlukene kanye nezinto, ungadala izivivinyo ezingafani ngokuphelele ngokuhambisana nokusebenza. Ngesikhathi esifanayo, kufanele kuqashelwe ukuthi kuzo zonke izimo, lapho udala ukuhlolwa, umsebenzi ozwakalayo usetshenziswa. IF.