Indlela ukubala ingcambu e-Excel?

Microsoft Excel software enoluhlu olubanzi zemathematika nemisebenzi ezikuvumela ukuba ukusombulula imisebenzi enzima. Iqela amanyathelo alula - Ukongeza, uphinda-phindo, kunye nabanye - Kulula kakhulu ukwenza, esebenzisa oonobumba abakhethekileyo. Noko ke, kukho abo ezifuna inkcazelo ekhethekileyo - ke, asinguye wonke ubani uyazi ukuba ukubala indlela ingcambu e-Excel.

Yintoni na ke ingcambu ye isikwere?

Phambi ekuqaleni kwenkqubo yokufunda, ukufumana indlela ingcambu ukuya Excel, kufuneka uqhelane nesibakala sokuba lo msebenzi zezibalo. Xa inkcazelo, ingcambu esikweri yenani - yinto onombolo yakhe square lilingana nenani a. Zenzululwazi zemathematika ayikwazi kuphela iingcambu square kubonwa. Kwakhona kuza naliphi na inqanaba, ngoko ke ingcambu udla ngokubizwa ngokuba ingcambu bolwesibini udidi.

umsebenzi root

Ekusombululeni ingxaki ezinxulumene ne ekufumaneni isikwere ingcambu "Eksele" ukufumana iziphumo ezinqwenelekayo ngeendlela ezininzi. Ukusebenza kwale program ivumela zombini ukusebenzisa ubuchule eyakhelwe-kwezigqibo, kwaye ubhale ngokwakho, esebenzisa theorems ezizodwa neempawu ingcambu. Indlela elula yokufumana impendulo lisisikweri ingcambu umsebenzi. Ngo-Excel, lungafunyanwa ngokuvula iinketho menu okanye echaza ngesandla.

Le lwesivakalisi ilula kakhulu - emva ecacisa ukusetyenziswa omnye wale misebenzi (kophawu olulinganayo) kuyimfuneko ukubhalisa igama "ingcambu", ebonisa lokufowuna umyalelo ofanelekileyo. Okulandelayo iya kubhalwa kwizibiyeli eziguquguqukayo apho ufuna ukuba singathatha ingcambu yalama cala. Ngo-Excel ye, classes komsebenzi inokusetyenziswa njenge inani yokubana lenani kunye kukhankanywa esiseleni, kunye ibinzana lwezibalo ehluza inani.

Ukusebenzisa iimpawu zezibalo

Ingcambu e Excel, unako ukubala inani nezinye iindlela musa kufuna ulwazi olunzulu zenzululwazi zemathematika. Akwanelanga ukuba uyazi ukuba yintoni na iingcambu - esi sihloko wachukunyiswa phezu kwicandelo lokuqala nqaku. Ukusebenzisa inkcazo ingcambu, oko ungaboniswa njengoko amagunya njengamacala yenani ezimbini ezifunekayo. Ngoko ke, ukufumana ingcambu ngaphandle kokusebenzisa i "yingcambu 'ukuba nje aphakamisa inani ukuya emandleni.

Oku kunokwenziwa kwakhona ngeendlela ezimbini. Okokuqala ukusebenzisa eminye imisebenzi - "isigaba". It kwenyusa inani okanye kwesiphumo Ukuzibonakalisa ngokwezibalo kwi isidanga ekhethiweyo. Kulo mzekelo, kwi "ehle" zibonisa inani 1/2 okanye 0.5. Nkqo naliphi inani ukuya kumlinganiselo othile kunokwenzeka ngaphandle ukusetyenziswa kwalo naluphi na iimpawu - "Eksele" na abasebenzisi abakhethekileyo olawula lo msebenzi: "^". Kulo mzekelo, ukufumana ruthi, kwanele ukuba ukugqiba ibinzana kwindawo yegama, elandelwa ngokudibanisa "^ (1/2)" okanye "* (0.5)." Isiphumo sale nyathelo liya kufana ukwakhiwa kwamandla kunye umsebenzi kunye nokusetyenziswa "ingcambu" function.

Kufuneka kuqatshelwe ukuba indlela ekufumaneni ingcambu a exponentiation kakuhle ngakumbi. Isizathu soku kukuba ngoncedo ezi imisebenzi, ungafumana ingenangcambu ngaphandle ukusebenzisa naziphi na izibalo ezikhethekileyo ezongezelelweyo.

izibonelo

Ukuze ekugqibeleni ukusingatha ukubala njani isikwere njengengcambu Excel, kufuneka ucinge isibini imizekelo ngenxa iindlela ezimbini ezichazwe apha ngasentla.

Kwimeko yokuqala sebenzisa uphawu "ingcambu", esithi ngokusebenzisa iqhosha "Insert Umsebenzi". Kwi window eziya cacisa i data kuba ukubala, ezifana umahluko phakathi amaxabiso ababini iiseli, kwaye ngoku nqakraza "Gqiba".

Kwimeko yesibini, usebenzisa luguqulelo lobuntu-ayifundeki, nesabelo esicacileyo amandla ka, ibinzana ilandelayo ekufumaneni ingcambu esikweri yenani, umzekelo 9:

Isiphumo sale senzo siya imiselwe ku "3".