Uxhumanongqo kuya Excel - incazelo, izibonelo.

Kuzo zonke, ngisho iphakethe eyisisekelo "Microsoft Office" inikeza isipredishithi editor onamandla Excel ( "Excel"). Uhlu imisebenzi etholakalayo kuba umxhwele ngempela: kusukela kungenzeka ukuhlunga kanye nedatha zokuhlunga nesiphetho benethuba wakhela phezu kwesisekelo sabo isifinyezo namashadi. Futhi cishe akunakwenzeka noma iyiphi idatha elondolozwe setha kumhleli ngaphandle kukhompyutha ngokuhlukanisa amafomula imigqa namakholomu.

Amafomula ku "Excel"

Noma yimuphi ifomula - iqembu ehlanganisa ibonise lokho izenzo khiqiza cell obuhlukahlukene. Futhi uma umsebenzisi ubhekene isidingo ukukopisha "elula" ifomula kulo lonke irowu noma ikholomu ke uyaqaphela ukuthi kwezinye izimo ingxenye ifomula noma ifomula kufanele zihlala zinjalo ngokuphelele. Ngakho umsebenzisi ngeke azi ukuthi kukhona Excel izixhumanisi ngokuphelele futhi isihlobo. Cabanga imiqondo le kabanzi.

isixhumanisi isihlobo

Khumbula ukuthi isixhumanisi isihlobo kuya Excel, kulula kunangaphambili. Lolu hlobo isixhumanisi kukhethwa ngokuzenzakalela futhi sishintsha inani layo uma edonsa (ukukopisha) formula kumaseli engumakhelwane kungakhathaliseki ukukopisha kanye amakhalamu noma imigqa.

Cabangela isibonelo esilula. Yakha iqoqo elincane idatha, ehlanganisa amakholomu amabili: "Umsebenzi" futhi "iholo":

Ngo kwemigomo "EXCEL" cela A1 isitayela izinkomba - ekhuluma enjalo elula futhi enembile kubasebenzisi abaningi. Lapha, A, B, C - amagama ikholomu nezinombolo umugqa. Ngakho, idatha cell "Zakirova E. M." ikheli - A4. Lokhu ukuphambuka encane uzodinga lapho sifika ukubhekana amareferensi amafomula.

Manje zicabange sifuna ukubala ngesisekelo iholo ngamunye idatha umsebenzi kwabasebenzi. Sabela yeseli C2 kufanisa futhi ukwethula le ndlela elandelayo (okusekelwe ulwazi emholweni 40% omholo): = B2 * 100/40. Lapha B2 - isisebenzi iholo yokuqala kuthebula. Bese ucindezela Faka Move igundane onqenqemeni engezansi kwesokudla C2 cell, abalindi kuze kube yilapho izinguquko pointer ukuba nomzimba omncane omnyama esiphambanweni. Cindezela inkinobho yesinxele, hudula ifomula phansi ekupheleni etafuleni, ukuthi, kuze kube C7 cell (ungakwazi ukushintsha isinyathelo by kabili ngokuchofoza igundane onqenqemeni engezansi kwesokudla iseli). Ikholomu ngokuzenzakalelayo ugcwale idatha:

idatha Formula iseli zimi kanje:

Njengoba ubona, lapho thina welulela ifomula phansi mpo igama ikholomu uhlala ingashintshiwe (B), kodwa inani umugqa ishintshile njalo. Ngokufanayo, ukukopishela ifomula nendawo, sithola yezinhlamvu ukubaluleka njalo nge ikamelo ukushintsha ikholomu. Ngakho-ke, isixhumanisi ibizwa ngokuthi "isihlobo" - ikhophi ifomula waqale wangena zizoshintsha isixhumanisi mayelana nesimo yayo uhla leaf amaseli.

Njengoba sibona, ukubhekana neqiniso lokuthi ukuhlobana isihlobo kuya Excel, akunzima.

Ake sicabangele lezi zinhlobo ezilandelayo link.

uxhumanongqo

uxhumanongqo kuya Excel - uhlobo elilandelayo ezivamile link. Kulokhu, lapho ukukopisha irowu ifomula fixed kanye ikholomu, okubhekiselwa kuzo izimangalo.

Yiqiniso, kukodwa nje inkombakuqheliwe ngokuphelele alisetshenziswa wedwa, ngoba ikhophi akusiyo iphuzu kakhulu. Ngakho-ke, lolu hlobo ukusabalala ekuhlanganisweni amafomula, lapho ezinye zazo - isithenjwa ngokuphelele, abanye njengabakhulu isihlobo.

Sibethula isibonelo, enye isethi idatha - nesabelo njalo ngenyanga emholweni, bonke abasebenzi okufanayo:

Ngakho, kubalulekile ukuba ukushintsha futhi iseli C2 nge ukubala nomholo, manje-ke ngeke aqukethe le ndlela elandelayo:

Lapho senza ucindezela Faka, sibona ukuthi iholo recalculated kahle kuseli. Kodwa lapho sizobe ukunweba ifomula kubo bonke abasebenzi, baye iholo akabalwa, ngokusebenzisa isihlobo isixhumanisi wazama ukuthatha amagugu G4..G8, lapho kudzingeke lutho. Ukuze sigweme isimo esinjalo, kubalulekile ukuba usebenzise i inkombakuqheliwe ngokuphelele Excel. Ukukhiya ikhalamu noma umugqa, eshintsha uma ukopisha ifomula kufanele bekungeke kudingeke ukuba ubeke ngokulandelana eduze igama ikhalamu noma umugqa inombolo ledola ($).

Thina ukushintsha ifomula kwethu okulandelayo:

Futhi lapho silingisa ke, zonke emholweni wabasebenzi recalculated:

Eceleni welithi "inkombakuqheliwe ngokuphelele" Excel uhlale nomqondo izinkomba okuxubile.

isixhumanisi elixutshwe

Cabanga lolu hlobo yokukhuluma. Ezixutshiwe isixhumanisi - isixhumanisi esiye sashintsha uma ukopisha inombolo ikholomu inombolo umugqa njalo, noma okuphambene nalokho. Ngakho uphawu dollar imele phambi inombolo irowu ngokulandelana (A $ 1) noma ngaphambi inombolo kukholomu ($ A1) - okungukuthi, ngaphambi kokuba i-elementi ukuthi ngeke kushintshe.

Xhumanisa elixutshwe esetshenziswa kakhulu kaningi kunakuqala isithenjwa kweqiniso ngokuphelele. Ngokwesibonelo, ngisho isibonelo esilula langaphambilini, asikwazanga esikhundleni kahle ifomula = (B2 + $ G $ 3) * 100/40 ukuba = (B2 + G $ 3) * 100/40 bese umphumela ofanayo, ngoba sisuke ukukopisha ifomula thwi futhi nenombolo ikholomu kunoma isiphi isimo namanje abakashintshi. Futhi lokho ingasaphathwa izimo lapho kudingeka ngempela ukuba ukukhiya kuphela inombolo irowu noma ikholomu, futhi sishiyele konke etholakalayo ushintsho.

Eqinisweni ezithakazelisayo

Kuyoba ezithakazelisayo ukwazi lokho inkombakuqheliwe ngokuphelele Excel lingasethwa hhayi kuphela inkomba esizimele uphawu dollar phambi irowu kanye / noma ikholomu. "Excel" ivumela ngokucindezela ikhi F4 emva ecacisa nekheli iseli ukukhetha uhlobo link - okokuqala isixhumanisi icindezelwa nge ushintsho isihlobo sakhe esasithanda ngokuphelele, kanti eyesibili - inombolo okuxubile lefakwako, wesithathu - inombolo okuxubile ikholomu fixed, kahle, ngokuzayo ngokuchofoza futhi iba isihlobo. Shintsha ukubukeka izixhumanisi Excel ngakho kulula kakhulu, ngoba akudingekile iphendukele ekushintsheni isendlalelo sekhibhodi.