Indlela ukuze nande "Eksele" iiseli phakathi kwabo?

Kule mihla, omnye zixhobo ethandwa yobalo imbaxa inkqubo Microsoft Excel. ebanzi functionality aso lula isisombululo wemisebenzi iseti ebisakuba kwafuneka ukuba achithe ixesha elininzi. Namhlanje sijonga indlela nande "Eksele" iiseli kunye amanani amakhulu.

Multiplication ngo "Eksele"

Ngaphambi kokuba sibone indlela ukwanda kwamanani "Eksele", kubalulekile ukukhumbula ebanzi ukusebenza kwale program, into leyo eyenza ukuba basebenze zombini kunye isabelo ocacileyo amanani nokusebenzisa iiseli eziqulathe kwakhona amanani kunye neefomula, njengeyo- zabo. Ukuze phinda iiseli enye okanye ngaphezulu okanye inani iiseli ukuba zidingeka ibha yefomyula emva kophawu olulinganayo zibonisa izinto data sheet okanye ixabiso ebhaliweyo.

Multiplication weseli cell

Ngaphezu koko, kubalulekile ukuqonda mgaqo, njengoko kwi "Eksele 'ukuba phinda iseli kwiseli yaye yintoni ingxaki uyakwazi ukuhlangabezana kule nkqubo. Kuba phinda amaxabiso amabini emgceni iiseli kufuneka abhalise ifomula isakhiwo ulandelayo: "= A * B", apho "A" kwaye "B" - iilinki izinto ezahlukahlukeneyo sheet "EXEL", ngamanye iiseli.

Fumana iziphumo, ungafuna ukwenza ukhuphelo lolandelo, kwaye abasebenzisi rhoqo musa ukuthandabuza, khuphela nje ixabiso kule seli ngokufaka ibe kwenye. Nangona kunjalo, le ndlela iya kwenzeka utshintshe iilinki ezifanelekileyo esalatha factorization. Ukwenzela ukuphepha impazamo enjalo, kufuneka ibe esiseleni apho ufuna ukukhuphela yoko, faka ikhonkco iseli zikotshwe, okanye "ukulungisa" idilesi izinto zayo umqondiso "$". Le uphawu lwedola ugcina ixabiso Ngokubhekiselele parameter, landela kuyo - oko kukuthi, $ yekhonkco le A4 uya kusoloko jonga kumhlathi A, A $ 4 - umgca yesine, kwaye $ A $ 4 - kuphela iseli A4. Ngamanye amazwi, le ukulungiswa yeseli - ekudalweni inkomba ngokupheleleyo kuyo.

Uphindaphindo of columns nezintlu

Ukusebenzisa ukulungisa iidilesi iseli algorithm, ungaya ngqo indlela phinda ngo umhlathi okanye umqolo ukuba Emgceni "Eksele" column. Ukugcina ixesha ekubhaleni ifomula elikhulu, ungasebenzisa ngokulula ipropati etshintsha zeseli xa uhambisa ukuba idilesi isalathisi esitsha. Oko kukuthi, ukuba kuyimfuneko zande ngababini ixabiso kwimiqolo emibini, oko kwanele ukubhala indlela phindo ukuba isibini sokuqala iiseli, yaye emva koko, iphethe uphawu 'emnyama dibanisa ", owayebonakele kwikona esezantsi ekunene ukuya olule isiphumo phantsi ndawonye onke amaxabiso column-wokuphindaphinda.

Ukuze kufikelelwe isiphumo esifanayo ukuba imiqolo, kuyimfuneko kuphela ukuvelisa isiphumo ndisolulela ecaleni imigca ezichaphazelekayo. Kubalulekile ukuphawula ukuba ukuze uphephe uqala ngexesha ikopi elandelayo yeziphumo, kuyimfuneko ukulungisa ifomula kwikholam ekhankanyiweyo okanye umqolo - ke ukwazi ukuphepha iimpazamo ekubaleni.

I-phindo lo mqolo okanye kholamu kwiseli

Ngokuqonda indlela nande "Eksele" umhlathi ngoKholam okanye umqolo ukuba emgceni, kuyimfuneko ukuba bahleli omnye umsebenzi othile - phindo leseli kumqolo okanye umhlathi. Ukuba algorithm phindo usebenzisa intshukumo efanayo kwimeko phindo kwiikholam, umphumo iya banda kuphela ixabiso lukrozo lokuqala kule kholam, ukusukela idilesi iseli uya ezingaguquguqukiyo kwiseli nganye ekuhleni enye indawo.

Ukuze uphephe oku, kufuneka ukuba ukulungisa inombolo umgca iyanda yi iseli okanye ngokupheleleyo wayo - kulo mzekelo, iya kuba nako ukusebenzisa ixabiso layo ngokweekholamu ezininzi. Kwimeko phindo ngelayini iseli column ileta yokutshixa ethile ngokwaneleyo apho ahlala, okanye ukwenza zombini dilesi yeseli parameter njalo.

Indlela phinda wonke amanani emgceni okanye umhlathi

Maxa wambi "Eksele" kufuneka ukuba enze umsebenzi ofanayo loo lilonke, enza kuphela ukusebenza phindo. Nangona kunjalo, inkqubo eyodwa ngokuzenzekelayo le akakho, abaninzi kangaka, esazi ukuba "Eksele" phinda njani inani njengomhalthi owodwa okanye emgceni kunye namanye, yenze ngokucacileyo, ukurekhoda inyathelo ngenxa kwiseli nganye. Enyanisweni, kule nkqubo kukho umsebenzi ezinokunceda ukusombulula ingxaki indlela nande "Eksele" ngasinye ezinye izihlandlo eziliqela ngokukhawuleza.

Ukuze phinda uluhlu ezithile neseli enye kwenye, khetha nje menu "Insert Function" ukusebenza ebizwa ngokuba "ukwenza." Njengoko ingxabano lo msebenzi ngokuthi iiseli eziza liphindaphindwe omnye komnye, oko kuba ziintsika, imigca, iiseli, okanye ma yonke. Kufuneka kuqatshelwe ukuba ubukho iseli ezingenanto kuluhlu lwamajelo isiphumo phindo akalingani zero - kule meko program iya ngoyaba le seli, ngamanye null nenani umanyano.

isishwankathelo

Azi ukuba phinda njani "Eksele" lingaphunyezwa amaxwebhu kakuhle ezintsonkothileyo, kuquka iingxelo zoqoqosho kunye noqikelelo. Uninzi imisebenzi arithmetic inokwenziwa ngendlela efanayo, kodwa abanye kufuneka athathele ingqalelo nkcukacha wokuphunyezwa yabo, kwakunye ifomati cell. Ngoko ke, umzekelo, ngokwahlula iseli ukuba iseli engekho lamaxabiso omnye wabo, umphumo uba division imposiso ngu zero.