Sebelisa litšupiso tsa sele le ho bontša ho atisa Excel
Joalo ka lisebelisoa tsohle tsa motheo tsa lipalo ho Excel, ho atisa palo e 'meli kapa ho feta ho kenyelletsa ho theha foromo.
Lintlha tse bohlokoa tseo u lokelang ho li hopola ka Excel formula:
- Litlhahlobo tsa Excel li qala kamehla ka letšoao le lekanang ( = ).
- Letšoao le lekanang kamehla le kena seleng moo u batlang hore karabo e bontšoe.
- Letšoao la ho atolosa kapa mochine o sebelisoang ho Excel formulas ke letšoao la asterisk ( * ).
Ho sebelisa Litlhaloso tsa Cell ka Litlhahlobo
Le hoja ho ka khoneha ho kenya linomoro ka ho toba ka mokhoa o motle, ho molemo haholo ho kenya data ho lisele tsa ho sebetsa ebe o sebelisa liaterese kapa litšupiso tsa lisele tseo ka mokhoa ona.
Monyetla o ka sehloohong oa ho sebelisa lisele tsa lisele ka mokhoa o fapaneng, ho e-na le boitsebiso ba sebele, ke hore, haeba hamorao, ho hlokahala hore ho fetole data, ke taba e bonolo ea ho nkela boitsebiso litsing tse hlalositsoeng ho e-na le ho ngola hape mokhoa ona.
Liphello tsa foromo li tla ntlafatsa hang-hang hang ha data e fetoletsoeng liseleng e fetoha.
Ho kenya Litlhaloso Tsa Cell ka Ho Sebelisa
Hape, le hoja ho ka khoneha hore u thaepe litemana tsa sele hore li sebelisoe lebitsong, mokhoa o motle ke ho sebelisa ho supa ho eketsa litlhaloso tsa sele.
Ho kenyeletsa ho kenyelletsa ho kopa lisele tse hlalositsoeng tse nang le data le pointer ea mouse ho eketsa lisele tsa selefouno. Melemo ea ho sebelisa mokhoa ona ke hore e fokotsa monyetla oa liphoso tse entsoeng ka ho thapa ka sefahleho se fosahetseng sa sele.
Ho Hlahisa Formula Example
Joalokaha ho bontšitsoe setšoantšong se ka holimo, mohlala ona o hlahisa foromo ka seleng ea C1 e tla eketsa data ka cell A1 ka data ho A2.
Morero o phethiloeng ka seleng ea E1 e tla ba:
= A1 * A2
Ho kenya Dintlha
- Tlanya nomoro ya 10 ka seleng A1 mme o tobetsa konopo ea ho kena lebokoseng,
- Tlanya nomoro 20 ka seleng A2 mme o tobetsa konopo ea ho kena ,
Ho kenya Foromo
- Tobetsa seleng ea C1 ho e etsa hore e be sele e sebetsang - ena ke moo liphello tsa foromo li tla bontšoa.
- Mofuta = (e le pontšo e lekanang ) ka seleng ea C1.
- Tobetsa seleng ea A1 ka pointer ea mouse ho kenya sele eo ea selefouno ka mokhoa ona.
- Tšoaea * ( letšoao la asterisk ) ka mor'a A1.
- Tobetsa seleng A2 ka pointer ea mouse ho kenya sele eo.
- Tobetsa konopo ea Kena ho lebokose ho tlatsa foromo.
- Karabo ea 200 e lokela ho ba teng ka seleng ea C1.
- Le hoja karabo e bontšoa ka seleng ea C1, ho tobetsa seleng eo ho tla bontšoa foromo ea sebele = A1 * A2 kahare ea foromo ka holim'a leqephe la mosebetsi.
Ho fetola Data Formule
Ho lekola bohlokoa ba ho sebelisa lisele tsa sele ka mokhoa o itseng:
- Fetola nomoro ka seleng ea A2 ho tloha ho 20 ho ea ho ea 5 'me u tobetse konopo ea Kena lebokoseng.
Karabo ka seleng ea C1 e lokela ho ntlafatsa ho fihlela ho 50 ho bontša phetoho ea data ka seleng ea A2.
Ho fetola Foromo
Haeba ho hlokahala ho lokisa kapa ho fetola foromo, tse peli tsa tse molemo ka ho fetisisa ke tsena:
- Tobetsa ka mofuthu sebopeho se hlahisitsoeng ho hlahisa Excel ho Hlela mode mme u etse liphetoho ho foromo. Sena se sebetsa hantle bakeng sa liphetoho tse nyenyane.
- Tobetsa hang ka seleng e nang le foromo le ho ngola hape foromo eohle. Mokhoa ona o molemo bakeng sa liphetoho tse kholo.
Ho theha Formule e Eketsehileng e Feteletseng
Ho ngola litlhaloso tse rarahaneng tse kenyelletsang mesebetsi e mengata - e kang ho tlosa, ho phaella, le ho arola, hammoho le ho atisa - ho eketsa basebelisi ba lipalo ba nepahetseng ka tatellano e nepahetseng e latetsoeng ke lisele tse nang le lintlha.
Pele o kopanya lipalo tse fapaneng tsa lipalo hammoho le moralo, ke habohlokoa ho utloisisa taelo ea liketso tseo Excel e li latelang ha ho hlahlojoa foromo.
E le ho itloaetsa, leka mohlala ona oa mohato le mohato oa mokhoa o rarahaneng haholoanyane .