Izindlela Zokubiza Ezingenayo yonke kwi-Microsoft Excel

Njengoba wazi, kumatafula e-Excel kunezinhlobo ezimbili zokukhuluma: isihlobo nokuphelele. Esimweni sokuqala, isixhumanisi siyashintsha ekuqondisweni kokukopishwa kwenani lokushintshwa kwesihlobo, esimweni sesibili siyalungiswa futhi sihlala singaguquki ngesikhathi sokukopisha. Kepha ngokuzenzakalelayo, wonke amakheli e-Excel aphelele. Ngasikhathi sinye, kaningi kunesidingo sokusebenzisa ngokuphelele ikheli (elinqunyelwe) lokukhuluma. Ake sibheke ukuthi lokhu kungenziwa kanjani.

Isebenzisa ikheli eliphelele

Singadinga ukukhulunywa ngokuphelele, ngokwesibonelo, esimweni lapho sikopisha ifomula, enye ingxenye yayo equkethe okuguquguqukayo kuboniswe ochungechungeni lwezinombolo, kanti eyesibili inenani elihlala likhona. Okusho ukuthi, le nombolo idlala indima yokuqina okwenziwa njalo, lapho udinga ukwenza khona ukusebenza okuthile (ukuphindaphinda, ukuhlukanisa, njll.) Kulo lonke uchungechunge lwezinombolo eziguqukayo.

Ku-Excel, kunezindlela ezimbili zokusetha ikheli elinqunyelwe: ngokwakha isixhumanisi esiphelele nokusebenzisa umsebenzi we-INDIRECT. Ake sibheke ngayinye yalezi zindlela ngemininingwane.

Indlela yoku-1: Isixhumanisi Esingapheli

Kuze kube manje, indlela edume futhi esetshenziswa njalo yokwakha ikheli ngokuphelele ukusebenzisa izixhumanisi eziphelele. Izixhumanisi ezingaphelele zinomehluko hhayi wokusebenza kuphela, kodwa futhi noku-syntactic. Ikheli lesihlobo linesi syntax elandelayo:

= A1

Ekhelini elinqunyelwe, uphawu lwedola lubekwe phambi kwenani lokuhlanganisa:

= $ A $ 1

Isiginali yedola singafakwa ngesandla. Ukuze wenze lokhu, beka ikhesa ngaphambili kwenani lokuqala lamakheli aqondisa (ngokuvundlile) atholakala esitokisini noma kubha yefomula. Okulandelayo, kufomethi yekhibhodi yolimi lwesiNgisi, chofoza inkinobho "4" isikhulumi esiphakeme (ukhiye ubanjwe phansi I-Shift) Yilapho uphawu ledola likhona. Ngemuva kwalokho udinga ukwenza inqubo efanayo nezixhumanisi eziqonde mpo.

Kunendlela esheshayo. Kuyadingeka ukubeka ikhesa esitokisini lapho ikheli litholakala khona bese uchofoza ukhiye wokusebenza we-F4. Ngemuva kwalokho, uphawu lwedola lizovela ngaso leso sikhathi kanyekanye phambi kokuxhumeka okuqondile nokuqonde mpo kwekheli elinikeziwe.

Manje ake sibheke ukuthi ikheli eliphelele lisetshenziswa kanjani ekusebenzeni ngokusebenzisa izixhumanisi ngokuphelele.

Thatha itafula elibala inkokhelo yabasebenzi. Ukubalwa kwenziwa ngokwandisa iholo labo siqu yi-coeffnty engaguquki, efanayo kubo bonke abasebenzi. Ukuqina ngokwako kutholakala kuseli elihlukile leshidi. Sibhekene nomsebenzi wokubala amaholo abo bonke abasebenzi ngokushesha okukhulu.

1. Ngakho-ke, esitokisini sokuqala sekholamu "Mholo" sethula ifomula yokuphindaphinda amanani omsebenzi ahambisanayo yi-coeffnty. Kithina, le formula inefomu elilandelayo:

   = C4 * G3



2. Ukubala umphumela ophelile, chofoza inkinobho Ngena kwikhibhodi. Inani liboniswa kuseli eliqukethe ifomula.



3. Sabala inani lomholo lesisebenzi sokuqala. Manje sidinga ukukwenza lokhu kuyo yonke eminye imigqa. Vele, umsebenzi ungabhalela iseli ngalinye kukholamu. "Mholo" ngesandla, ukufaka ifomula efanayo ngokulungiswa kwe-offset, kepha sinomsebenzi wokwenza izibalo ngokushesha okukhulu, futhi ukufaka ngesandla kuzothatha isikhathi esiningi. Yebo, futhi kungani umzamo wokuchitha usungula okufakwayo, uma ifomula ingakopishelwa kwamanye amaseli?

   Ukukopisha ifomula, sebenzisa ithuluzi elinjengomaka wokugcwalisa. Siba isikhombisi ekhoneni elingakwesokudla leseli lapho liqukethe. Ngasikhathi sinye, isikhombisi ngokwaso kumele siguqulwe kulomaki wokugcwalisa ofanayo ngesiphambano. Bamba phansi inkinobho yegundane kwesobunxele bese uhudula isikhombisi phansi ekugcineni kwetafula.



4. Kepha, njengoba sibona, esikhundleni sokubala kahle amaholo abanye abasebenzi, sathola ama-zeros eyodwa.



5. Sibheka isizathu salomphumela. Ukuze wenze lokhu, khetha iseli lesibili kwikholamu "Mholo". Ibha lefomula libonisa isabizwana elihambelana nalesi seli. Njengoba ubona, isici sokuqala (C5) Ihambelana nezinga lesisebenzi elikhokhelwa iholo laso. Ukushintshwa kwezixhumanisi uma kuqhathaniswa neseli edlule kwakubangelwe impahla yokuhlobana. Kodwa-ke, kulokhu kufanele lokhu. Ngenxa yalokhu, into yokuqala kwakuyizinga lesisebenzi esasilidinga. Kepha ukuguquka kwezixhumanisi kwenzeke ngento yesibili. Futhi manje ikheli lakhe alisho kubekiwe (1,28), kepha esitokisini esingenalutho ngezansi.

   

   Lesi yiso kanye isizathu esenza ukuthi ukubalwa kwamaholo kwabasebenzi abalandela kusuka ohlwini kube kungalungile.

6. Ukulungisa lesi simo, kudingeka siguqule ukubekwa eceleni kwento yesibili kusuka kusihlobo kuya kwesinye. Ukuze wenze lokhu, buyela kuseli lokuqala lekholamu "Mholo"ngokuyigqamisa. Okulandelayo, sidlulela kubha yefomula, lapho kuboniswa khona isisho esidingayo. Khetha isici sesibili (G3) bese uchofoza ukhiye wokusebenza kukhibhodi.



7. Njengoba ubona, uphawu lwedola lwavela eduze kwezixhumanisi zento yesibili, futhi lokhu, njengoba sikhumbula, kuyimpawu yokukhuluma ngokuphelele. Ukukhombisa umphumela esikrinini, cindezela inkinobho Ngena.



8. Manje, njengakuqala, sibiza umaki wokugcwalisa ngokubeka isikhombisi ekhoneni elingezansi kwesokudla sento yokuqala yekholamu "Mholo". Bamba inkinobho yegundane kwesobunxele bese uyihudula phansi.



9. Njengoba ubona, kulokhu, ukubalwa kwenziwa kahle futhi inani lemholo labo bonke abasebenzi bebhizinisi libalwe kahle.



10. Bheka ukuthi ifomula yenziwa kanjani. Ukuze wenze lokhu, khetha into yesibili yekholamu "Mholo". Sibheka inkulumo esethombeni yomugqa. Njengoba ubona, izixhumanisi zento yokuqala (C5), eseseyisihlobo, ihambise iphuzu elilodwa phansi ngokuqhathanisa neselula edlule. Kepha isici sesibili ($ G $ 3), ikheli lapho senze khona ukulungisa, lahlala lingashintshiwe.

I-Excel isebenzisa okubizwa ngamakheli ahlanganisiwe. Kulokhu, kungaba yikholomu noma umugqa kuhleliwe ekhelini lezinto. Lokhu kutholakala ngendlela yokuthi isibonakaliso sedola sibekwa kuphela phambi kwesinye sezixhumanisi zamakheli. Nasi isibonelo sesixhumanisi esivamile esihlanganisiwe:

= A $ 1

Leli kheli libhekwa njengelexubile:

= $ A1

Okusho ukuthi, ikheli eliphelele kusixhumanisi esihlanganisiwe lisetshenziselwa eyodwa kuphela kwamanani amabili ahlanganayo.

Ake sibheke ukuthi lesi sixhumanisi esixubile singasetshenziswa kanjani ekusebenzeni kwetafula lomholo elifanayo labasebenzi benkampani njengesibonelo.

1. Njengoba ubona, phambilini sikwenzile ukuze zonke izixhumanisi zento yesibili zixazululwe ngokuphelele. Kepha ake sibheke ukuthi kulokhu makumiswe yini amanani womabili? Njengoba ukwazi ukubona, lapho ukopisha, kuba noshintsho omile, futhi izixhumanisi ezivundlile zihlala zingashintshiwe. Ngakho-ke, kungenzeka ukusebenzisa ikheli eliphelele kuphela ezixhumeni zomugqa, bese ushiya izixhumanisi zekholomu njengoba zinjalo ngokuzenzakalelayo - isihlobo.

   Khetha into yokuqala yekholamu "Mholo" futhi emgqeni wamakhompiyutha senza ukukhohlisa okungenhla. Sithola ifomula lefomu elilandelayo:

   = C4 * G $ 3

   Njengoba ukwazi ukubona, ikheli elibekiwe kusici sesibili lisebenza kuphela kusixhumanisi selayini. Ukukhombisa umphumela esitokisini, chofoza inkinobho Ngena.



2. Ngemuva kwalokho, usebenzisa umaki wokugcwalisa, kopisha leli fomula ebangeni lamaseli akhiwe ngaphansi. Njengoba ukwazi ukubona, imali ekhokhelwa bonke abasebenzi yenziwa kahle.



3. Sibheka ukuthi ifomula elikopiwe liboniswa kanjani kuseli lesibili lekholamu esenze ngalo uxhaso. Njengoba ukwazi ukubona emugqeni wamafomula, ngemuva kokukhetha lesi sici sephepha, ngaphandle kokuthi izixhumanisi zemigqa kuphela zazikhuluma ngokuphelele endaweni yesibili, ukuguquguquka kokuxhumanisa kwekholomu akwenzekanga. Lokhu kungenxa yokuthi asikopisanga ngokuvundlile, kodwa ngokuqondile. Ukube besingakopisha ngokuvundlile, esimweni esifanayo, ngakolunye uhlangothi, kuzofanele senze ikheli elinqunyelwe labaxhumanisi bekholomu, futhi ngemigqa le nqubo ibizoba ngokuzithandela.

Isifundo: Izixhumanisi ezihlobene ngokuphelele nezihlobo ku-Excel

Indlela 2: Umsebenzi we-INDIRECT

Indlela yesibili yokuhlela ikheli eliphelele kuspredishithi se-Excel ukusebenzisa i-opharetha E-INDIA. Umsebenzi ocacisiwe ungowamaqembu opharetha abakhelwe ngaphakathi. Izinkomba kanye nokufika. Umsebenzi wayo ukwakha isixhumanisi seseli elicacisiwe ngokuphuma kokungxenye kweshidi lapho opharetha etholakala khona. Kulesi simo, isixhumanisi sinamathiselwe kubaxhumanisi kakhulu kunasisebenzisa isibonakaliso sedola. Ngakho-ke, kwesinye isikhathi kuyisiko ukubiza izixhumanisi usebenzisa E-INDIA ", ngokuphelele." Lesi sitatimende sine-syntax elandelayo:

= INDIRECT (cell_link; [a1])

Umsebenzi unezimpikiswano ezimbili, eyokuqala enesimo sokuphoqelelwa, kanti eyesibili ayinayo.

Ukuxabana Isixhumanisi Seseli isixhumanisi sento yeshidi le-Excel elifomu lombhalo. Lokho wukuthi, lokhu kuyisixhumanisi esijwayelekile, kepha kufakwe kumamaki wokucaphuna. Lokhu yikho kanye okwenza ukuthi sikwazi ukuhlinzeka ngezakhiwo eziphelele zokukhuluma.

Ukuxabana "a1" -ngokukhetha futhi kusetshenziswe ezimweni ezingavamile. Ukusetshenziswa kwayo kudingekile kuphela lapho umsebenzisi ekhetha enye indlela yokubeka ikheli, kunokusebenzisa okujwayelekile kwezixhumanisi ngohlobo "A1" (amakholomu anokuqanjwa incwadi, nemigqa - yedijithali) Enye indlela ukusebenzisa isitayela "R1C1", lapho amakholomu, njengemigqa, akhonjiswa ngezinombolo. Ungashintshela kule ndlela yokusebenza ngewindows ongakhetha e-Excel. Ngemuva kwalokho, ukusebenzisa opharetha E-INDIAnjengengxabano "a1" inani kufanele likhonjiswe FALSE. Uma usebenza kwimodi ejwayelekile yokubonisa yezixhumanisi, njengabaningi abanye abasebenzisi, ke njengengxabano "a1" ungacacisa inani "IQINISO". Kodwa-ke, leli nani liboniswa ngokuzenzakalelayo, ngakho-ke ingxabano ilula kakhulu ngokujwayelekile kuleli cala. "a1" ungacacisi.

Ake sibheke ukuthi ikheli eliphelele lihlelwe kanjani kusetshenziswa umsebenzi lizosebenza. E-INDIA, isibonelo, itafula lethu lomholo.

1. Sikhetha into yokuqala ikholamu "Mholo". Sibeka isibonakaliso "=". Njengoba sikhumbula, isici sokuqala kwifomula yokubalula yomholo ecacisiwe kumele sithunyelwe ikheli lesihlobo. Ngakho-ke, chofoza nje kuseli eliqukethe inani elihambisanayo lomholo (C4) Ukulandela ukuthi ikheli lakhe liboniswe kanjani kulokho ukubonisa umphumela, chofoza inkinobho zande (*) kwikhibhodi. Ngemuva kwalokho kudingeka siqhubekele ekusebenziseni opharetha E-INDIA. Chofoza isithonjana. "Faka umsebenzi".



2. Ewindini elivulayo Umsebenzi Wizards iya esigabeni Izinkomba kanye nokufika. Kuluhlu olwethulwe lwamagama, sihlukanisa igama "INDIA". Bese uchofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana nomsebenzi liyasebenza E-INDIA. Siqukethe izinkambu ezimbili ezihambelana nokuphikisana kwalomsebenzi.

   Faka ikhesa endle Isixhumanisi Seseli. Vele uchofoze kuzinto zeshidi lapho kuzobambisana khona ukubala iholo (G3) Ikheli lizovela ngokushesha emkhakheni wewindi lokuphikisana. Uma besiphatha umsebenzi ojwayelekile, khona-ke ukungeniswa kwekheli kungabhekwa njengokuphelele, kepha sisebenzisa umsebenzi E-INDIA. Njengoba sikhumbula, amakheli akuyo kufanele abe ngendlela yombhalo. Ngakho-ke, sisonga izixhumanisi ezitholakala enkanjini yewindows enamamaki wokucaphuna.

   Njengoba sisebenza kwimodi yokubonisa ejwayelekile, inkambu "A1" shiya kungenalutho. Chofoza inkinobho "Kulungile".



4. Uhlelo lokusebenza lenza isibalo futhi libonisa umphumela kuzinto zeshidi eliqukethe ifomula.



5. Manje sikopisha le formula kuwo wonke amanye amaseli kukholamu "Mholo" sisebenzisa umaki wokugcwalisa, njengoba senzile ngaphambili. Njengoba ubona, yonke imiphumela ibalwa kahle.



6. Ake sibheke ukuthi ifomula ikhonjiswa kanjani kwelinye lamaseli lapho lalikopishwa khona. Khetha into yesibili yekholamu bese ubheka umugqa wamafomula. Njengoba ubona, isici sokuqala, esiyisixhumanisi esihlobene, sashintsha izixhumanisi zaso. Ngasikhathi sinye, impikiswano yento yesibili, emelelwa ngumsebenzi E-INDIAwahlala engashintshiwe. Kulokhu, kusetshenziswe indlela yokubekisa engaguquki.

Isifundo: IFRS Yomsebenzi e-Excel

Ikheli eliphelele kumatafula e-Excel lingatholakala ngezindlela ezimbili: ukusebenzisa umsebenzi we-INDALO nokusebenzisa izixhumanisi ngokuphelele. Ngasikhathi sinye, umsebenzi uhlinzeka ngokubopha okuqinile ekhelini. Ikheli elithile ngokuphelele lingasetshenziswa kusetshenziswa izixhumanisi ezixubekile.