Le olona qhakamshelweno lungundoqo kwaye xa kuthelekiswa Excel. Indlela yokusebenzisa?

Nokuba usandul 'ukuqalisa ukusebenza kunye nenkqubo-Microsoft Excel, mhlawumbi uyazi ukuba enye zalo eziluncedo kulula ukuba ukusebenza kunye neefomula neetafile. Ngoko ke, namhlanje kunye nawe, cinga Ukuqwalaselwa iitafile kwaye ufumanise ukuba yintoni na iimbekiselo isalamane, ngokugqibeleleyo exutyiweyo. Umsebenzi wabo ilula, ngoko ke kulula ukuqwalasela kubo practice. Ngoko ke yintoni na isalathisi ngokwenene isalamane?

definition

References kwi Microsoft Excel - oku akufani njengoko amakhonkco kwi Internet. Wabiza reference dilesi yeseli (umz: A1, B10). Zahlula-hlulwe iintlobo ezimbini eziphambili - amakhonkco ngokugqibeleleyo isalamane. Ngo-Excel wayethetha kwenzeka phakathi kwiiseli, ngoko xa uhambisa okanye ifomula ukukopa, ngokufuthi sifuna ukugcina okanye, icala, ukuba indawo data.

link isihlobo

Olu hlobo lo eqhelekileyo kakhulu. Ukuba zange uye kwizifundo ezikhethekileyo, uya kufunda, ngoko kunqabile ukudibana iimbekiselo epheleleyo. Ngoko siqala nesibakala sokuba kube lula.

iimbekiselo Absolute kunye isihlobo neefomula zisetyenziswa ukuba ukusebenza kunye needilesi iseli, kodwa ukuze esahlukileyo. Umba phambi kwethu kukho uhlobo olungundoqo kwaye akukho ukugcina iidilesi iseli kwifomula ngexesha transfer yayo. Xiya xikombiso lexi.

• Masithi sinikwa esiseleni kunye data (imiqolo) - M1, M2, M3, N1, N2, N3. Ezantsi kubo kwiseli M4 siya kubhala ifomula ke, ngenxa yazo na isiphumo amanani amathathu (M4 = M1 + M2 + M3). Njengabo bonke elula. Ngoku kufuneka ukuba ukubala imixholo yeseli h4. Kubalulekile kwakhona isixa idatha ahlala kuyo. Tsala okanye nje bekhuphela iseli M4, ngoku sithatha ifomula in h4. Ngenxa yoko, zonke iimbekiselo ezicatshulwe kuyo (M1, M2, M3) izakubuyiselwa H1, H2 kunye H3, ngokulandelelana kwazo.

Oku kubizwa ngokuba isihlobo dilesi. Umzekelo ibonakala ilula kwaye kuvela umbuzo zendalo, akukho lula ukuba ubhale indlela entsha? Hayi, iitafile ezinkulu izibalo sibala ngokomthamo, nto leyo kuba ezahlukeneyo imisebenzi kunye nabasebenzisi nto zikwazi kunokuba khuphela nje ukutshintshela ifomula kunokuba kwakhona kwenza amazwi ngakumbi.

olona qhakamshelweno lungundoqo

Njengoko sele kukhankanyiwe, amakhonkco ngokugqibeleleyo kwaye isihlobo Excel bakhonza iinjongo ezahlukeneyo. Uhlobo lwesibini amakhonkco phambi kwethu namhlanje, yenzelwe ukugcina nokulungisa naziphi na utshintsho neentshukumo kwifomula.

• Masithi kufuneka ukusombulula nawuphi na umsebenzi wezandla. Wena ube rhoqo ethile, zigcinwe A1. Kakade ke, singakwazi ukubhala nanini na le nombolo ngesandla, kodwa kulula ukubhala endaweni ethile nye. imihlathi emibini kwedatha njengoko linikwe thina (M1, M2, P1, P2). I-M3 and P3 iiseli kuyimfuneko ukubala le fomyula ilandelayo: M3 = (M1 + M2) * $ A $ 1. Ke kaloku, xa tsala kunye nokukopisha P3 iseli ukufumana P3 ilandelayo japan = (P1 + P2) * $ A $ 1. Yiloo nto ke idilesi esetyenziswa yi kwiseli ongayi kushukuma.

Ukwenza idilesi qhakamshelweno lungundoqo, nqakraza ifomula, khetha olifunayo "ikhonkco" kwaye cinezela F4. Okanye ngesandla chwetheza abalinganiswa "dollar".

ingxubevange

Olu hlobo iyiyimbi ufumaneka ifomula. Nanjengoko igama layo lixela, eli lixesha reference ngokwenene isalamane. Akukho nzima ukuba baqashele ukuba, xa kusenziwa oku, yonyulwa A1 okanye $ A $ 1. Ngenxa yoko, ikuvumela ukugcina wayethetha umhlathi okanye umqolo, kodwa qhubeka "rhutyu" kuyo. Xiya xikombiso lexi.

Ngoko ke, sinesizathu itafile kunye data. Kwikholam ethi "A", siye ixabiso elithile, kwaye umgca "1", lo mba kufuneka phinda ngayo. Iseli B2, C3 izakuqulatha iziphumo. Njengoko unokubona i qhakamshelweno lungundoqo kwaye isalamane apha namandla. Kwiimeko ezinjalo, kufuneka kusetyenziswa uhlobo mixed.

Thina kubhala ifomula kwi yokuqala yeseli A2 * B2 = B1. Kodwa ukuba yirhuqe kwi ekunene, kuyimfuneko ukulungisa kwikholam "A", njalo phantsi ukulungisa umtya "1". Ngoko ke, upelo oluchanekileyo olungumgubo bekuya kuba = $ B2 A2 * B $ 1. Ngoko, xa utsala ifomula, sifumana uthotho lamaxabiso nganye kwezi iiseli esele:

• B3 = $ A3 * B $ 1
• C2 = A2 * $ C $ 1
• C3 = $ A3 * C $ 1

Njengoko ubona, i qhakamshelweno lungundoqo nesihlobo akuyi kukunceda apha. Ngako oko, kuba ukubala okumbaxa kuyimfuneko ukusebenzisa uhlobo kuphela mixed. Oku kuya kuvumela yalula kwisikali itafile, ongeze kuwo la lwemiqolo nemihlathi. Kuphela xa kusingethwe kwezi ntlobo yokulungisa kufuneka uhlale silumke kakhulu, ngenxa yokuba, ukuba wenze impazamo kanye itafile esetyenziswa yi uqulunqo engumxube, ngoko ukufumana obubangela iya kuba nzima kunene.

Kuko konke. Ngethemba ngoku nisuke naba babeziqonda kakuhle, yintoni na qhakamshelweno lungundoqo kunye isalamane.