Ungasinyusa njani isidanga kwi-Excel

Ukwakhiwa kwenani sisiseko esisezantsi sezibalo. Isetyenziswa kwizibalo ezahlukeneyo, zombini ngeenjongo zokufunda nokuziqhelanisa. Inkqubo ye-Excel yakha-kwizixhobo zokubala eli xabiso. Makhe sibone ukuba uza kuzisebenzisa kwiimeko ezahlukeneyo.

Isifundo: Ungabeka njani uphawu lwe-degree kwi-Microsoft

Ukwakhiwa kwamanani

E-Excel, kukho iindlela ezininzi zokwakha inani. Oku kungenziwa ngoncedo lwesimboli esemgangathweni, umsebenzi, okanye ukusebenzisa ezinye, hayi izinketho eziqhelekileyo.

Indlela yoku-1: Ukwakhiwa kusetyenziswa uphawu

Eyona ndlela ithandwayo nendaziwa ngokwakha inani le-Excel kukusetyenziswa kophawu olusemgangathweni "^" Ngeenjongo. Itemplate yefomati yokwakhiwa ijongeka ngolu hlobo:

= x ^ n

Kule fomula, x linani elakhiwe, n yinqanaba lokwakha.

1. Umzekelo, ukwakha i-5 yenombolo ukuya kwinqanaba lesine. Siso nasiphi na isisele sephepha okanye kwifomu yefomumu esiyivelisa oku kulandelayo:

   = 5 ^ 4



2. Ukwenzela ukuba ubalo kwaye ubonise iziphumo zayo kwiscreen sekhompyuter, cofa kwiqhosha lokungena kwikhibhodi. Njengoko sibona, kwimeko yethu ethile, isiphumo siyalingana no-625.

Ukuba ulwakhiwo luyinxalenye yenxalenye yobalo oluninzi ngakumbi, le nkqubo yenziwa phantsi kwemithetho jikelele yemathematics. Oko kukuthi, umzekelo, kumzekelo 5 + 4 ^ 3, I-Excel yagqwesa kwangoko ukwenza i-4 yenombolo 4, kwaye yongeze.

Ukongeza, ukusebenzisa umqhubi "^" Ungakhali kuphela amanani aqhelekileyo, kodwa nedatha equlathwe kuluhlu oluthile amashiti.

Kwakhiwa kwimigangatho yesithandathu kwiseli A2.

1. Kuyo nayiphi na indawo yasimahla ephepheni, bhala ibinzana:

   = A2 ^ 6



2. Cofa kwiqhosha lokungena. Njengoko sibona, ukubala kwenziwa ngokuchanekileyo. Ukusukela kwiseli A2 Kwakukho inani le-7, iziphumo zokubalo yayingu 117649.



3. Ukuba sifuna ukwakha ikholamu yonke yamanani akwinqanaba elifanayo, ke akukho mfuneko yokuba urekhode ifomula yexabiso ngalinye. Yitshise nje kumgca wokuqala wetafile. Emva koko kufuneka uzisa isikhombisi kwikona esezantsi ngasekunene kwesisele kunye nefomula. Gcwalisa uphawu luya kuvela. Cinezela iqhosha lemouse lasekhohlo kwaye wolule ezantsi kwetafile.

Njengoko ubona, onke amaxabiso exesha elifunekayo akhiwa kwinqanaba elichaziweyo.

Le ndlela yeyona ininzi kwaye ilunge ngakumbi kangangoko kunokwenzeka, kwaye ke ngoko ithandwa kakhulu ngabasebenzisi. Yiyo isetyenziswa kwisininzi sokubala.

Isifundo: Sebenza ngefomula kwi-Excel

Isifundo: Ungayenza njani i-autogram kwi-Excel

Indlela 2: Umsebenzi wesicelo

I-Excel ikwanenqaku elikhethekileyo lolobalo. Ibizwa ngokuba-isidanga. I-syntax yayo ijongeka ngolu hlobo:

= Isidanga (inombolo; isidanga)

Cinga ngesicelo sakhe kumzekelo othile.

1. Cofa kwiseli, apho siceba ukubonakalisa ukubala. Cofa kwiqhosha "Colas Fun".



2. I-Wizard ivula. Kuluhlu lwezinto ezifuna irekhodi "lesidanga". Emva kokuba ufumanise, siyayichaza kwaye cinezela iqhosha u "Kulungile".



3. Iwindow yempikiswano ivula. Lo msebenzi unempikiswano ezimbini-inani kunye nenqanaba. Ngapha koko, njengengxoxo yokuqala, inokusebenza njengentsingiselo yamanani kunye neseli. Oko kukuthi, iintshukumo zenziwa ngumlinganiso ngendlela yokuqala. Ukuba idilesi yeseli isetiwe njengengxabano yokuqala, kwanele ukubeka isikhombisi semouse kwintsimi "yenombolo", kwaye emva koko ucofe indawo oyifunayo yendawo. Emva koko, ixabiso lenani eligcinwe kuyo liya kubonakala ebaleni. Ithiyori, idilesi yeseli inokusetyenziswa kwintsimi ye "Degree" njengengxabano, kodwa ngokuziqhelanisa kunqabile ukuba isetyenziswe. Emva kokuba yonke idatha ingenisiwe ukuze ukubalwa, cinezela iqhosha u "Kulungile".

Ukulandela oku, isiphumo sokubala kulo msebenzi siboniswe kwindawo, esabiwa kwinyathelo lokuqala lezenzo ezichaziweyo.

Ukongeza, iwindow yempikiswano inokubizwa ngokujika kwithebhu "formulas". Kwiteyiphu, cinezela iqhosha "leMathematics", elikwiilayisensi yomsebenzi ". Kuluhlu lwezinto ezikhoyo ezivula, kufuneka ukhethe "isidanga". Emva koko, i-mpimpi ye-mpimpi iza kuqala.

Abasebenzisi abanamava athile abanakubangela i-wizard yemisebenzi, kodwa faka nje ifomula kwiseli emva kophawu lwe "=", ngokwe-syntax yayo.

Le ndlela inzima ngakumbi kunangaphambili. Ukusetyenziswa kwayo kunokugwetyelwa ukuba ubalo kufuneka lwenziwe ngaphakathi kwemida yomsebenzi ohlanganisiweyo olwenziwa abaqhubi abaliqela.

Isifundo: I-Wizard imisebenzi kwi-Excel

Indlela 3: Ukusekwa kwengcambu

Ewe kunjalo, le ndlela ayiqhelananga, kodwa inokubuyiselwa ukuba ufuna ukwakha inani le-0.5. Siza kulihlakulela eli tyala kumzekelo othile.

Kufuneka sakhe i-9 ukuya kwi-0.5 okanye ngokwahlukileyo - ½.

1. Khetha iseli apho iziphumo ziya kubonakala khona. Cofa kwiqhosha "Colas Fun".



2. Kwifestile yokusebenza yemisebenzi yewizard, ekhangela into yengcambu. Siyibonisa kwaye sicinezela iqhosha u "Kulungile".



3. Iwindow yempikiswano ivula. Ekuphela kwengxoxo yomsebenzi weengcambu linani. Umsebenzi ngokwalo wenza ukuba ukhuphele ingcambu yengcambu yenani elivunyiweyo. Kodwa, kuba ingcambu yesikwere ifana nokuzilolonga ukuya kwinqanaba ½, ke olu khetho lulungele thina. Kwintsimi "yenombolo", singena kwinombolo 9 kwaye ucofe iqhosha "Kulungile".



4. Emva koko, iziphumo zibalwa kwiseli. Kule meko, ilingana no 3. Lungiselelo eli nani leziphumo zolwakhiwo lwe-9 ukuya kwinqanaba le-0.5.

Kodwa, kunjalo, le ndlela yokubala irejista inqabile, isebenzisa iindlela ezahlukeneyo zokulwa.

Isifundo: Indlela yokubala ingcambu kwimvi

Indlela 4: Ukurekhoda inani elinesidanga kwiseli

Le ndlela ayiboneleli ngokuphunyezwa kwekhompyuter. Isebenza kuphela xa ufuna ukubhala inombolo enenqanaba kwiseli.

1. Sekela iseli apho ungeniso luya kwenziwa khona kwifomathi yokubhaliweyo. Siyichaza. Ukuba kwi-em tab "ekhaya" kwi-ribbon kwi-Toolbar "yenani", cofa kuluhlu lwe-Drop-Horting Uluhlu lwefomathi yokukhetha. Sicofa kwisicatshulwa "se-".



2. Kwiseli enye, bhala inombolo kunye nenqanaba layo. Umzekelo, ukuba kufuneka sibhale ezintathu ukuya kwinqanaba lesibini, emva koko bhala u- "32".



3. Sibeka isikhombisi esiseleni kwaye sabela idigi kuphela yesibini.



4. Ngokucinezela i-CTRL + 1 Indibaniselwano ephambili, biza ifestile yefomati. Faka i-tick kufutshane neparameter "ekhawulezayo". Cofa kwiqhosha "Kulungile".



5. Emva kokukhohlisa, inani elichaziweyo libonakalisiwe kwiscreen.

QAPHELA! Ngaphandle kwento yokuba inani elikwinqanaba elikwiseli liya kuboniswa kwiseli, i-Excel iyayibona njengetekisi eqhelekileyo, hayi intetho yamanani. Ke ngoko, ukubala, olu khetho alunakusetyenziswa. Ngeenjongo, irekhodi elinesidanga esiqhelekileyo lisetyenziswa kule nkqubo - "^".

Isifundo: Indlela yokutshintsha ifomathi yeseli kwi-Excel

Njengoko ubona, kwiNkqubo ye-Excel kukho iindlela ezininzi zokuwela inani. Ukwenzela ukukhetha ukhetho oluthile, okokuqala, kufuneka wenze isigqibo sokuba kutheni ufuna intetho. Ukuba ufuna ukwakha ibinzana lokubhala intetho kwifomula okanye ukubala ukubala ixabiso, ke kufanelekile ukurekhoda ngo "^" " Ngamanye amaxesha, ungawusebenzisa umsebenzi wesidanga. Ukuba ufuna ukwakha inani le-0.5, ke kunokwenzeka ukusebenzisa umsebenzi weengcambu. Ukuba umsebenzisi ufuna ukubonisa intetho yamandla ngaphandle kwezenzo zeComputer, emva koko ukufomatha kuya kuza kuhlangulo.