Umsebenzi wokwakha kwi-Excel

Esona senzo sezona sezenzo zemathematics ezisetyenziswa rhoqo kubunjineli kunye nezinye izibalo kukwakha inani kwinani lesibini, elahlukileyo kwisikwere esahlukileyo. Umzekelo, le ndlela ibala indawo yento okanye umzobo. Ngelishwa, akukho sixhobo sahlukileyo kwinkqubo ye-Excel esakha inombolo echaziweyo kwisikwere. Nangona kunjalo, lo msebenzi unokwenziwa usebenzisa izixhobo ezifanayo ezisetyenziselwa ukwakha naliphi na elinye inqanaba. Masifumanise ukuba ungazisebenzisa njani ukubala isikwere kwinani elichaziweyo.

Inkqubo yokwakha isikwere

Njengoko uyazi, isikwere senani sibalwa ngokuphindaphindwa kwaso. Le migaqo ngokwemvelo ibalo lwesalathiso esichaziweyo kunye ne-Excel. Kule nkqubo, sinokwakha inamba kwisikwere ngeendlela ezimbini: ukusebenzisa uphawu lomsebenzi ukuya kwinqanaba lefomula "^" kunye nokusebenzisa umsebenzi weqondo. Qwalasela i-algorithm yokusebenzisa ezi ndlela zikhethileyo ukuze uziqonde ukuba yeyiphi engcono.

Indlela yoku-1: Ukwakha ngoncedo lwefomula

Okokuqala, cinga ngendlela elula kunye neyona ndlela iqhelekileyo yokwakha isidanga sesibini kwi-Excel, equka ukusetyenziswa kwefomula ngesimboli "". Kwangelo xesha, njengento, eya kuphakanyiswa kwisikwere, ungasebenzisa inombolo okanye ikhonkco kwiseli, apho ixabiso lenani likhona.

Imbono ngokubanzi malunga nefomula yokwakhiwa kwesikwere imi ngolu hlobo lulandelayo:

= N ^ 2

Kuyo, endaweni yo "N", kuyimfuneko ukufaka inombolo ethile ekufuneka inyuswe kwisikwere.

Makhe sibone ukuba isebenza njani kwimizekelo ethile. Ukuqala, kwakhiwa inani kwisikwere esiya kuba yinxalenye yefomula.

1. Sibonisa iseli ephepheni apho ubalo luya kwenziwa khona. Sibeka kuwo umqondiso "= =. Emva koko sibhala ixabiso lenombolo esinqwenela ukwakha isidanga senqanawa. Mayibe linani 5. Okulandelayo, beka uphawu lwedigri. Luyisimboli "^" Ngaphandle kweecatshulwa. Emva koko kufuneka sichaze ukuba yeyiphi na into ekufuneka yenziwe. Kuba isikwere sisidanga sesibini, emva koko sibeke inani "2" ngaphandle kocango. Ngenxa yoko, kwimeko yethu, iFomula yajika:

   = 5 ^ 2



2. Ukubonisa iziphumo zokubala kwiscreen, cofa iqhosha lokungena kwikhibhodi. Njengoko ubona, le nkqubo ibalwe ngokuchanekileyo ukuba inani le-5 kwisikwere liya kulingana nowe-25.

Ngoku makhe sibone ukuba yenze njani ixabiso kwisikwere esikwelinye iseli.

1. Faka i "Isayine" elinganayo (=) kwiseli apho iziphumo zobalo ziya kubonakala khona. Okulandelayo, cofa kwinto yephepha, apho inombolo oyifunayo ukwakha isikwere. Emva koko, ukusuka kwikhibhodi, siqesha intetho "^ 2". Kwimeko yethu, le foamu ilandelayo yavela:

   = A2 ^ 2



2. Ukubala iziphumo, njengokokugqibela, nqakraza kwiqhosha leNqaku. Isicelo sibalwa kwaye sibonisa iziphumo kwinqanaba elikhethiweyo.

Indlela yesi-2: Sebenzisa umsebenzi weqondo

Kwakhona, ukwakha inamba kwisikwere, ungasebenzisa umsebenzi we-Excel degree. Lo msebenzi ungena kwiCandelo leMisebenzi yeMathematics kunye nomsebenzi wayo kukwakha ixabiso elithile lamanani ukuya kwinqanaba elichaziweyo. I-syntax yomsebenzi imi ngolu hlobo lulandelayo:

= Isidanga (inombolo; isidanga)

"Inombolo" yengxoxo inokuba linani elithile okanye ireferensi kwilitye lephepha, apho ikhoyo.

Ingxoxo "Degree" ibonisa isidanga apho inani lifanele likhiwe khona. Kuba sijamelene nombuzo wolwakhiwo lwesikwere, emva koko kwimeko yethu le ngxabano iya kulingana no-2.

Ngoku makhe sijonge umzekelo othile, indlela yokwenza isikwere sisebenzisa i-orrator yedigri.

1. Khetha iseli apho iziphumo zobalo ziya kubonakala. Emva koko, cofa kwi-Icon "yokufakwa". Ibekwe ngasekhohlo kwe-formula.



2. Iwindows yeWizard yeWizard iqala ukusebenza. Sivelisa inguqu kuyo kwicandelo "leMathematics". Kuluhlu lwekhitshi, khetha ixabiso "Degree". Emva koko nqakraza kwiqhosha "Kulungile".



3. Ifestile yempikiswano yomsebenzi ochaziweyo isunguliwe. Njengoko sibona, kukho amasimi amabini kuyo, ehambelana nenani leempikiswano kulo msebenzi wezibalo.

   Kwintsimi "yenombolo", chaza ixabiso lamanani ekufuneka akhuliswe kwisikwere.

   Kwintsimi "Degree", sichaza inani "2", kuba kufuneka sisebenze ngokuchanekileyo isikwere.

   Emva koko, cofa iqhosha u "Kulungile" kwindawo esezantsi yefestile.



4. Njengoko ubona, kwangoko emva koku, iziphumo zokwakhiwa kwesikwere ziboniswe ngexesha elimiselweyo.

Kwakhona, ukusombulula lo msebenzi, endaweni yengxoxo, ungasebenzisa ikhonkco kwiseli ekhoyo.

1. Ukwenza oku, tsalela umnxeba kwifestile yeempikiswano zomsebenzi ongasentla ngendlela esiyenze ngayo ngaphezulu. Kwifestile ebalekayo kwintsimi "yeNombolo", chaza ikhonkco kwiseli, apho ixabiso lenani likwisikwere. Oku kungenziwa ngokufaka isikhombisi ebaleni kwaye ucofe iqhosha lemouse lasekhohlo kwinqaku elifanelekileyo ephepheni. Idilesi iya kuvela kwangoko efestileni.

   Kwintsimi "degree", njengokokugqibela, sibeka inani "2", emva koko ucofe iqhosha u "Kulungile".



2. I-operator isebenzisa idatha efakiweyo kwaye ibonisa ukubala iziphumo kwiscreen. Njengoko sibona, kule meko, iziphumo ezinokubakho zilingana no-36.

Bona: Ungawakha njani inqanaba le-Excel

Njengoko ubona, zimbini iindlela zokuwela inani kwisikwere: usebenzisa i- "^ ^ ^" "" "" "" " Zombini ezi ndlela zinokukhethwa zinokusetyenziselwa ukwakha inani kuyo nayiphi na enye isidanga, kodwa ukubala isikwere kwiimeko zombini kuya kufuneka uchaze isidanga "2". Zonke iindlela ezichaziweyo zinokwenza ukubalwa, ngokubhekisele kwixabiso elichaziweyo lendidi, ke ngokusebenzisa ikhonkco kwiseli apho ikhoyo ngezo njongo. Kwaye enkulu, ezi khetho zilingana ngokusebenza, ngoko kunzima ukuthi yiphi enye engcono. Kuyimeko yeendlela kunye nezinto eziphambili ngokubaluleka komsebenzisi ngamnye, kodwa ifomula enophawu "^" Ihlala isetyenziswa rhoqo.