Isofthiwe yokusakaza ye-YouTube

Kubasebenzisi be-Microsoft Excel akuyona imfihlo ukuthi idatha kule prosesa ye-tabular ifakwa emaqenjini ahlukene. Ukuze umsebenzisi afinyelele le datha, isici ngasinye seshidi sinikezwa ikheli. Ake sithole ukuthi yiziphi izinto ezibalwe ku-Excel nokuthi ngabe kungenzeka yini ukuguqula le nombolo.

Izinhlobo Zokubala ku-Microsoft Excel

Okokuqala, kufanele kuthiwa i-Excel inamandla okushintsha phakathi kwezinhlobo ezimbili zokubala. Ikheli lezici lapho usebenzisa inketho yokuqala, efakwe ngokuzenzakalelayo, yiyo A1. Inketho yesibili imelwe ifomu elilandelayo - R1C1. Ukuze uyisebenzise, ​​udinga ukwenza ushintsho kuzilungiselelo. Ngaphezu kwalokho, umsebenzisi angakwazi ukubala amakheli, ngokusebenzisa izinketho eziningi ngesikhathi esisodwa. Ake sibheke zonke lezi zici ngokuningiliziwe.

Indlela 1: shintsha imodi yokubala

Okokuqala, ake sicabangele ukuthi kungenzeka ukushintsha imodi yokubala. Njengoba kushiwo ngaphambili, ikheli leseli elizenzakalelayo lisethiwe ngohlobo. A1. Okusho ukuthi, amakholomu aboniswa ngezinhlamvu zesiLatini, nemigqa - ngezibalo zama-Arabhu. Shintshela kwimodi R1C1 igcizelela ukuhluka okungekho kuphela izixhumanisi zemigqa, kodwa futhi izinsika zichazwe ngezinombolo. Ake sibone indlela yokwenza lokhu kuguqule.

1. Hambisa kuthebhu "Ifayela".



2. Ewindwangu evulekayo, iya esigabeni usebenzisa imenyu yokuma kwesokunxele "Izinketho".



3. Iwindi ye-Excel ivula. Ngemenyu, ekhona ngakwesobunxele, iya kwesigatshana "Amafomula".



4. Ngemuva kokushintshwa kunakekele eceleni kwesokudla kwewindi. Sifuna iqembu lezilungiselelo lapho "Ukusebenza namafomula". Mayelana nepharamitha "I-Link Style R1C1" ufake ifulege. Emva kwalokho, ungacindezela inkinobho "Kulungile" phansi kwefasitela.



5. Ngemuva kokusebenza okungenhla efasiteleni lemingcele, isitayela sokuxhumanisa sizoshintsha R1C1. Manje hhayi imigqa kuphela, kodwa amakholomu azobalwa.

Ukuze ubuyekeze ukuqokwa kwezixhumanisi ukuze kube okuzenzakalelayo, udinga ukwenza inqubo efanayo, kuphela ngalesi sikhathi ungahlolisisi ibhokisi "I-Link Style R1C1".

Isifundo: Kungani ku-Excel esikhundleni sezinombolo zezinhlamvu

Indlela 2: Ukugcwalisa Umaka

Ngaphezu kwalokho, umsebenzisi ngokwakhe angabala imigqa noma amakholomu lapho amangqamuzana atholakala khona, ngokusho kwezidingo zabo. Lokhu kubalwa ngokwezifiso kungasetshenziswa ukukhomba imigqa noma amakholomu etafuleni, ukudlulisela inombolo yomugqa emisebenzini eyakhelwe ngaphakathi kwe-Excel, nangezinye izinjongo. Yiqiniso, ukubalwa kwenombolo kungenziwa ngesandla, ngokuthayipha izinombolo ezidingekile kusuka kwikhibhodi, kodwa kulula kakhulu futhi ngokushesha ukwenza le nqubo usebenzisa amathuluzi okugcwalisa ngokuzenzakalelayo. Lokhu kuyiqiniso ngokukhethekile uma ubala inani elikhulu lemininingwane.

Ake sibheke ukuthi ukusebenzisa uphawu lokugcwalisa ungenza kanjani ukulandelela okuzenzekelayo kwezakhi zamashidi.

1. Beka inombolo "1" esitokisini esilungiselela ukuqala ukubala. Bese uhambisa isikhombisi kuya enqenqemeni engakwesokudla kwesici esicacisiwe. Ngesikhathi esifanayo, kufanele iguqulwe ibe mgwaqo omnyama. Ibizwa ngokuthi uphawu lokugcwalisa. Sibamba inkinobho yegundane lesokunxele bese uhudulela isikhombisi phansi noma ngakwesokudla, kuye ngokuthi yini okudingayo ukuyibala: imigqa noma amakholomu.



2. Ngemuva kokuthi ufinyelele esitokisini sokugcina ukuze ubale, khipha inkinobho yegundane. Kodwa, njengoba sibona, zonke izakhi ezinezinombolo zigcwaliswa kuphela ngamayunithi. Ukuze ulungise lokhu, chofoza isithonjana esiphezulu kwohlu olubalwe. Veza inkinobho eduze kwento "Gcwalisa".



3. Ngemva kokwenza lesi senzo, lonke uhla luzobalwa ngokulandelana.

Indlela 3: Ukuqhubeka

Enye indlela izinto eziku-Excel zingabalwa ngayo ukusebenzisa ithuluzi elibizwa ngokuthi "Ukuqhubeka".

1. Njengendlela yokudlula, setha inombolo "1" esitokisini sokuqala okufanele sibalwe. Emva kwalokho, mane ukhethe le nto yeshidi ngokuchofoza kukho inkinobho yegundane lesokunxele.



2. Uma ibanga elifunayo likhethiwe, hamba kuthebhu "Ikhaya". Chofoza inkinobho "Gcwalisa"efakwe kuthebhu ku-block Ukuhlela. Uhla lwezenzo luvulwa. Khetha isikhundla kusuka kuso "Ukuqhubeka ...".



3. Iwindi le-Excel livuliwe. "Ukuqhubeka". Kulo iwindi, izilungiselelo eziningi. Okokuqala, ake siyeke ebhodini. "Indawo". Kulo, inkinobho inezikhundla ezimbili: "Emigqa" futhi "Ngamakholomu". Uma udinga ukwenza inombolo yokubala, bese ukhetha okukhethwa kukho "Emigqa"uma mpo - khona-ke "Ngamakholomu".

   Ebhokisini lesethingi "Thayipha" ngezinjongo zethu, udinga ukusetha inkinobho endaweni "I-Arithmetic". Kodwa-ke, usuvele usele ndawo ngokuzenzakalelayo, ngakho-ke udinga ukulawula kuphela isikhundla sakhe.

   Izilungiselelo zokuvala "Izinyathelo" iyasebenza kuphela uma ukhetha uhlobo Izinsuku. Njengoba sakhetha uhlobo "I-Arithmetic", ngeke sibe nesithakazelo ebhokisini elingenhla.

   Ensimini "Isinyathelo" kufanele usethe inombolo "1". Ensimini "Inani elilinganiselwe" setha inani lezinto ezibalwe.

   Emva kokwenza izenzo ezingenhla, chofoza inkinobho "Kulungile" phansi kwefasitela "Ukuqhubeka".



4. Njengoba sibona, kuchaziwe efasiteleni "Ukuqhubeka" ububanzi bezingxenye zeshidi zizobalwa ngokulandelana.

Uma ungafisi ukubala inani lezinto zezingxenye ukuze zibalwe, ukuze zibonise endle "Inani elilinganiselwe" efasiteleni "Ukuqhubeka"ngakho-ke kulokhu kuyadingeka ukhethe lonke uhla oluzobalwa ngaphambi kokuqalisa iwindi elicacisiwe.

Emva kwalokho efasiteleni "Ukuqhubeka" yenza zonke izenzo ezifanayo ezichazwe ngenhla, kodwa manje sishiya ensimini "Inani elilinganiselwe" ayinalutho.

Umphumela uzoba okufanayo: izinto ezikhethiwe zizobalwa.

Isifundo: Indlela yokuqedela ngokuzenzakalela ku-Excel

Indlela 4: sebenzisa umsebenzi

Ungakwazi ukubhala izakhi zeshidi; ungasebenzisa futhi imisebenzi eyakhelwe ngaphakathi ye-Excel. Isibonelo, ungasebenzisa opharetha ngenombolo yokubala LINE.

Umsebenzi LINE ibhekisela ebhodini labaqhubi "Izixhumanisi nezigaba". Umsebenzi walo oyinhloko ukubuyisela inombolo ye-Excel sheet lapho isixhumanisi sizofakwa khona. Okusho ukuthi, uma sicacisa njengengxabano yalolu msebenzi noma yisiphi iseli emgqeni wokuqala wekhasi, khona-ke kuzokhipha inani "1" esitokisini lapho kutholakala khona. Uma ucacisa isixhumanisi esakhiweni somugqa wesibili, opharetha uzobonisa inombolo "2" nokunye
Umsebenzi we-syntax LINE okulandelayo:

= LINE (isixhumanisi)

Njengoba ungabona, ukuphikisana okuphela kwalokhu msebenzi kuyisithenjwa esitokisini inomboro womugqa ozokhishwa kuyo into ecacisiwe.

Ake sibone ukuthi singasebenza kanjani no-opharetha ocacisiwe ekusebenzeni.

1. Khetha into ezoba ngowokuqala ebangeni elibaliwe. Chofoza kusithonjana "Faka umsebenzi"elitholakala ngaphezu kwendawo yokusebenzela ye-Excel sheet.



2. Iqala Umsebenzi weWebhu. Ukwenza ushintsho kuwo kusigaba "Izixhumanisi nezigaba". Kusuka kumagama opharetha ohlwini, khetha igama "LINE". Ngemuva kokuqokomisa leli gama, chofoza inkinobho. "Kulungile".



3. Iqalisa iwindi lempikiswano yokusebenza. LINE. Inensimu eyodwa kuphela, ngokusho kwenombolo yalezi zizathu. Ensimini "Xhumanisa" sidinga ukungena ikheli lanoma isiphi iseli esitholakala kumugqa wokuqala wekhasi. Ukuxhumanisa kungangena ngesandla ngokuthayipha ngokusebenzisa ikhibhodi. Noma kunjalo, kulula kakhulu ukwenza lokhu ngokumane ubeke isikhombisi ensimini, bese uchofoza inkinobho yegundane lesokunxele kunoma iyiphi into emgqeni wokuqala wekhasi. Ikheli lakhe lizoboniswa masinyane emawindini e-arguments LINE. Bese uchofoza inkinobho "Kulungile".



4. Esitokisini sephepha lapho umsebenzi ukhona khona LINE, isibalo sibonisiwe "1".



5. Manje sidinga ukubala yonke imigqa. Ukuze ungenzi inqubo usebenzisa opharetha kuzo zonke izakhi, okuyinto ngokuqinisekile kuthatha isikhathi eside, ake enze ikhophi ifomula usebenzisa uphawu lokugcwalisa kakade ajwayelekile kithi. Beka isikhombisi engqenqemeni engakwesokudla kweseli lefomula. LINE futhi ngemva kokuvela kumakaki okugcwalisa, ubambe inkinobho yesinxele segundane. Donsela isikhombisi phansi kwenani lemigqa edinga ukubalwa.



6. Njengoba ubona, ngemuva kokwenza lesi senzo, yonke imigqa ebangeni elicacisiwe izobalwa ngokubalwa kwezinombolo zomsebenzisi.

Kodwa senze kuphela ukulinganisa imigqa, futhi ukuqedela umsebenzi wokwazisa ikheli leseli njengenombolo ngaphakathi kwetafula, kufanele futhi sibhale amakholomu. Lokhu kungenziwa futhi usebenzisa umsebenzi owakhiwe ngaphakathi kwe-Excel. Lo opharetha kulindeleke ukuthi abe negama "STOLBETS".

Umsebenzi COLUMN futhi kungokwesigaba se-opharetha "Izixhumanisi nezigaba". Njengoba ungase uqagele, umsebenzi walo ukuthola inombolo yekholomu kusiqephu esicacisiwe se-sheet, iseli salo esibhekisiwe. I-syntax yalo msebenzi isifana nesitatimende sangaphambilini:

= COLUMN (isixhumanisi)

Njengoba ubona, igama kuphela lo-opharetha ngokwalo lihlukile, futhi ukuphikisana, njengokwedlulela kwesikhathi, kusho ukubhekisela kwento ethile yeshidi.

Ake sibone ukuthi singayifeza kanjani umsebenzi ngosizo lwalesi thuluzi ngokusebenza.

1. Khetha into, ezohambelana nekholomu yokuqala yebanga elicutshungulwayo. Sichofoza kusithonjana "Faka umsebenzi".



2. Iya ku Umsebenzi weWebhuhamba kusigaba "Izixhumanisi nezigaba" futhi lapho sikhetha igama "STOLBETS". Sichofoza inkinobho "Kulungile".



3. Iwindi lempikiswano iqala. COLUMN. Njengesikhathi sangaphambilini, faka isikhombisi ensimini "Xhumanisa". Kodwa kulokhu sikhetha noma iyiphi into engekho emgqeni wokuqala wekhasi, kodwa yekholomu yokuqala. Izixhumanisi zizovela masinyane ensimini. Khona-ke ungachofoza inkinobho "Kulungile".



4. Ngemva kwalokho, isibalo sizoboniswa kuseli elicacisiwe. "1"ehambelana nenani lekholomu elihlobene letafula, elichazwe ngumsebenzisi. Ukubalwa kwamakholomu asele, kanye nasendabeni yemigqa, sisebenzisa uphawu lokugcwalisa. Sihamba ngaphezu komkhawulo ongakwesokudla weseli equkethe umsebenzi COLUMN. Silinde kuze kuvele umaka wokugcwalisa futhi, ubambe inkinobho yegundane lesokunxele phansi, donsela isikhombisi ngakwesokudla ngenombolo edingekayo yezinto.

Manje wonke amaseli wetafula lethu lombandela anomumo wokulinganisa. Isibonelo, isici lapho isibalo sesi-5 sisethwe esithombeni esingezansi sinokuxhumanisa komsebenzisi (3;3), yize ikheli layo eliphelele kumongo weshidi lihlala E9.

Isifundo: Umsebenzi weWebhu ku-Microsoft Excel

Indlela yesi-5: Yika i-Cell Name

Ngaphezu kwalezi zindlela ezingenhla, kufanele kuqashelwe ukuthi, naphezu kwesabelo sezinombolo kumakholomu nemigqa yohlu oluthile, amagama amaseli angaphakathi kuwo azobekwa ngokuhambisana nokubala kwekhasi lonke. Lokhu kungabonakala ensimini yegama elikhethekile lapho into ikhethiwe.

Ukuze ushintshe igama elihambelana nezixhumanisi zeshidi kulowo esacacisile besebenzisa izixhumanisi ezihambelana nendawo yethu, khetha nje isici esifanayo ngokuchofoza inkinobho yegundane lesokunxele. Khona-ke, ngokusuka kukhibhodi egameni lensimu, thayipha egameni igama lomsebenzisi elibheka liyadingeka. Kungaba yiliphi igama. Kodwa kithi, sivele sifake izixhumanisi ezihlobene zalesi sici. Ake sikhombise inombolo yomugqa egameni lethu. "Ikhasi"kanye nenombolo yekholomu "Ithebula". Sithola igama lohlobo olulandelayo: "Stol3Str3". Siyidlulisela ensimini egameni bese ucindezela ukhiye Ngena.

Manje iseli lethu linikezwa igama ngokuvumelana nekheli layo elihlobene nendawo. Ngendlela efanayo, unganika amagama kwezinye izakhi zohlu.

Isifundo: Indlela yokwabela igama leseli ku-Excel

Njengoba ungabona, kunezinhlobo ezimbili zokubala okufakwa ngaphakathi ku-Excel: A1 (okuzenzakalelayo) futhi R1C1 (kufakwe ezilungiselelweni). Lezi zinhlobo zokubhekana nazo zisebenza kulo lonke leli shidi. Kodwa ngaphezu kwalokho, umsebenzisi ngamunye angenza izinombolo zakhe ngaphakathi kwetafula noma idatha ethile ethize. Kunezindlela eziningana eziqinisekisiwe zokwazisa izinombolo zomsebenzisi kumaseli: usebenzisa uphawu lokugcwalisa, ithuluzi "Ukuqhubeka" kanye nemisebenzi ekhethekile yokwakhiwa kwe-Excel. Ngemuva kokuthi ukufakwa kwenombolo kusethelwe, kungenzeka ukunikeza igama kwisici esithile sekhasi ngesisekelo salo.