I-Basic Math kwi-Excel yoKongeza ukuKhupha, ukuHlukana, nokuPhinda
Ngezantsi ziqhagamshelweyo eziqhotyoshelweyo ukuya kwizifundo ezifakela imisebenzi yamatriki ayisiseko kwi-Excel.
Ukuba ufuna ukwazi ukufaka, ukususa, ukuphindaphinda, okanye ukwahlula amanani kwi-Excel, amanqaku achazwe apha ngezantsi aya kukubonisa indlela yokwenza ifomula ukwenza njalo.
Indlela yokukrazula kwi-Excel
Izihloko ezibandakanyiweyo:
- Indlela yokususa amanani usebenzisa ifomu ;
- Umzekelo wenyathelo ngesinyathelo sokudala ifomula yokukhupha kwi-Excel usebenzisa indawo kwaye nqakraza ;
- Kutheni ukusetyenziswa kweziboniso zeseli kuzakwenza kube lula ukuhlaziya izibalo zakho ukuba idatha yakho ingatshintsha.
Indlela yokwahlula kwi-Excel
Izihloko ezibandakanyiweyo:
- Indlela yokwahlula amanani amabini usebenzisa ifomu;
- Umzekelo wenyathelo ngesinyathelo sokudala ifomula yecandelo kwi-Excel usebenzisa indawo kwaye nqakraza;
- Kutheni ukusetyenziswa kweziboniso zeeseli kuzakwenza kube lula ukuhlaziya izibalo zakho ukuba idatha yakho ingatshintshwa;
Indlela yokwandisa kwi-Excel
Izihloko ezibandakanyiweyo:
- Indlela yokwandisa amanani amabini usebenzisa ifomu;
- Umzekelo wenyathelo-nge-nyathelo lokudala ifomula yokuphindaphinda kwi-Excel usebenzisa indawo kwaye nqakraza;
- Kutheni ukusetyenziswa kweziboniso zeseli kuzakwenza kube lula ukuhlaziya izibalo zakho ukuba idatha yakho ingatshintsha.
Indlela yokongeza kwi-Excel
Izihloko ezibandakanyiweyo:
- Indlela yokongeza amanani amabini usebenzisa ifomu;
- Umzekelo wenyathelo ngesinyathelo sokudala ifomula yokufakela kwi-Excel usebenzisa indawo kwaye nqakraza;
- Kutheni ukusetyenziswa kweziboniso zeseli kuzakwenza kube lula ukuhlaziya izibalo zakho ukuba idatha yakho ingatshintsha.
Ukutshintsha i-Order of Operations kwiifomula ze-Excel
Izihloko ezibandakanyiweyo:
- I- Order of Operations ezi nkqubo zisepredishithi zilandela xa kuhlolwa i-formula
- Indlela yokutshintsha umyalelo wemisebenzi kwiifomula
Abaxhasi kwi Excel
Nangona kungasetyenziswanga ngaphantsi kunabasebenzisi beemathematika abhalwe apha ngasentla, i-Excel isebenzisa umlingisi we-caret
( ^ ) njengomqhubi ocacileyo kwiifomula.
Abanye abavakalisi bathiwa ngokuphindaphindiwe ngokuphindaphindiweyo ukususela ekubeni i-exponent - okanye amandla njengoko kuthiwa ngamanye amaxesha-kubonisa ukuba kaninzi kangakanani inani lokusekwa kufuneka liphindiswe ngokwalo.
Ngokomzekelo, umboniso 4 ^ 2 (amane macwecwe) - unesibalo esiphezulu se-4 kunye ne-exponent ye-2, okanye kuthiwa iphakanyiswe kumandla amabini.
Ngayiphi na indlela, ifom ifom efutshane nje yokuthi inombolo yesiseko kufuneka iphandwe kabini (4 x 4) ukunika umphumo we-16.
Ngokufanayo, 5 ^ 3 (iibhite ezinhlanu) ibonisa ukuba inani le-5 kufuneka liphindwe ngokuphindwe kathathu (5 x 5 x 5) ukunika impendulo ye-125.
Imisebenzi yeMathematika ye-Excel
Ukongezelela kwiimfomula ezisisiseko ezibhalwe apha ngasentla, i-Excel ineemisebenzi emininzi - amafomula ekwakhiwe-angasetyenziselwa ukufeza inamba yemisebenzi yemathematika.
Le mi sebenzi iquka:
Umsebenzi we-SUM - yenza kube lula ukongeza iikholomu okanye imigqa yamanani;
Umsebenzi we-PRODUCT - ukwandisa amanani amabini okanye ngaphezulu kunye. Xa ukwandisa amanani amabini nje, iifomula yokuphindaphinda kulula;
Umsebenzi we-QUOTIENT - ubuyisela kuphela ukubuyisela inxalenye epheleleyo (inombolo epheleleyo kuphela) yomsebenzi wecandelo;
Umsebenzi we-MOD - ubuyisela kuphela intsalela yecandelo lolwahlulo.