Ukukhulisa inombolo emandleni ku-Microsoft Excel

Ukukhulisa inombolo emandleni kuyisenzo esimaphakathi sembalo. Isetshenziselwa izibalo ezihlukahlukene, kokubili ngezinhloso zemfundo nangokusebenza. I-Excel inezakhi ezakhelwe ngaphakathi zokubala leli xabiso. Ake sibone ukuthi singawasebenzisa kanjani ezimweni ezehlukene.

Isifundo: Indlela yokubeka uphawu lwe-degree ku-Microsoft Word

Ukukhulisa izinombolo

Ku-Excel, kunezindlela eziningana zokuphakamisa inombolo emandleni ngesikhathi esifanayo. Lokhu kungenziwa ngosizo lwesimboli esivamile, umsebenzi noma ngokusebenzisa ezinye, hhayi ezivamile, izinketho.

Indlela 1: ukulungiswa usebenzisa uphawu

Indlela eyaziwa kakhulu futhi eyaziwa kakhulu yokuhlonza i-exponentiation yenombolo ku-Excel ukusebenzisa uphawu olujwayelekile. "^" ngenxa yalezi zinhloso. Isifanekiso sefomula sokwakhiwa kanje:

= x ^ n

Kule fomula x - lena inombolo yokwakha n - izinga lokumiswa.

1. Isibonelo, ukuphakamisa inombolo 5 kuya kwesine amandla, senza ukungena okulandelayo kunoma yisiphi iseli leshidi noma kubha yefomula:

   =5^4



2. Ukuze ubale futhi ubonise imiphumela yayo kukhompyutheni yekhompyutha, chofoza inkinobho. Ngena kwikhibhodi. Njengoba sibona, esimweni sethu, umphumela uzolingana no-625.

Uma ukwakhiwa kuyingxenye yokubala okuyinkimbinkimbi, khona-ke inqubo yenziwa ngokuvumelana nemithetho jikelele yemathematika. Yilokho, isibonelo, kusibonelo 5+4^3 ngokushesha i-Excel yenza i-exponentiation emandleni enomboro 4, bese uyengeza.

Ngaphezu kwalokho, usebenzisa opharetha "^" Kungenzeka ukwakha hhayi kuphela izinombolo ezejwayelekile, kodwa futhi nedatha equkethwe ebangeni elithile leshidi.

Phakamisa okuqukethwe kweseli A2 kuya ku-degree eyisithupha.

1. Kunoma yisiphi isikhala samahhala kushidi bhala inkulumo:

   = A2 ^ 6



2. Sicindezela inkinobho Ngena. Njengoba ungabona, ukubalwa kwenziwa ngendlela efanele. Njengoba isibalo sesi-7 sisesitokisini se-A2, umphumela wokubala wawuyi-117649.



3. Uma sifuna ukwakha ngezinga elifanayo ikholomu yonke yezinombolo, akudingekile ukuba ubhale ifomula ngayinye inani. Kwanele ukukuloba ngomugqa wokuqala wetafula. Khona-ke nje udinga ukuhambisa isikhombisi ekhoneni elingezansi kwesokudla leseli ngefomula. Uphawu lokugcwalisa luvela. Cindezela inkinobho yesinxele yesinxele bese uyihudulela phansi phansi kwetafula.

Njengoba ubona, wonke amanani we-interval oyifunayo aphakanyiselwe amandla akhethiwe.

Le ndlela ilula futhi elula ngangokunokwenzeka, ngakho-ke iyathandwa kakhulu ngabasebenzisi. Ukuthi lisetshenziselwa ukubalwa kwamacala amaningi.

Isifundo: Sebenzisa ngamafomula ku-Excel

Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel

Indlela 2: sebenzisa umsebenzi

E-Excel kunomsebenzi okhethekile wokwenza lokhu kubalwa. Kubizwa - IZIHLOKO. I-syntax yayo ilandelayo:

= DEGREE (inombolo; degree)

Cabangela ukusetshenziswa kwalo kwesibonelo esithile.

1. Sichofoza esitokisini lapho sihlela ukubonisa umphumela wokubala. Sicindezela inkinobho "Faka umsebenzi".



2. Ivula Umsebenzi weWebhu. Kuhlu lwezinto esizofuna irekhodi. "UKUKHULU". Ngemva kokuthola, khetha bese uchofoza inkinobho "Kulungile".



3. Iwindi lempikiswano ivuleka. Lo opharetha unezizathu ezimbili - inombolo nenani. Futhi njengoba ingxabano yokuqala ingenza, kokubili inani lamanani, neseli. Okusho ukuthi, izenzo zenziwa ngokufana nesindlela sokuqala. Uma ingxabano yokuqala ikheli leseli, bese ufaka isikhombisi segundane ensimini "Inombolo", bese uchofoza endaweni oyifunayo yeshidi. Emva kwalokho, inani lezinombolo eligcinwe kuso likhonjiswa ensimini. Izinganekwane emkhakheni "Isiqu" Ikheli leseli lingasetshenziswa futhi njengengxabano, kodwa ngokwenza lokhu akuvamile ukusebenzisa. Ngemuva kokuthi yonke idatha ifakiwe, ukuze wenze ukubalwa, chofoza inkinobho "Kulungile".

Ngemva kwalokhu, umphumela wokubala walo msebenzi uboniswa endaweni eyabelwe esiteji sokuqala sezenzo ezichazwe.

Ngaphezu kwalokho, iwindi lezingxoxo lingabizwa ngokuya kuthebhu "Amafomula". On the tape, chofoza inkinobho "Isibalo"itholakala ebhokisini lamathuluzi "I-Function Library". Kuhlu lwezinto ezitholakalayo okudingeka ukhethe "UKUKHULU". Ngemuva kwalokho, iwindi lezimangalo zalo msebenzi lizoqala.

Abasebenzisi abanolwazi oluthile bangase bangabizi Umsebenzi weWebhu, futhi faka nje ifomula esitokisini ngemuva kwesibonakaliso "="ngokusho kwe-syntax yayo.

Le ndlela yinkimbinkimbi kunokwedlule. Ukusetshenziswa kwalo kungalungiswa uma ukubalwa kudinga ukwenziwa ngaphakathi kwemingcele yomsebenzi ohlanganisiwe ohlanganisa opharetha abaningana.

Isifundo: I-Excel Function Wizard

Indlela ye-3: ukuhlonza i-exponentiation ngokusebenzisa impande

Yiqiniso, le ndlela ayiyona into evamile, kodwa ungabuye usebenzise kuyo uma udinga ukwakha inombolo emandleni ka-0.5. Ake sihlole leli cala ngesibonelo sokhonkolo.

Sidinga ukuphakamisa 9 emandleni 0.5 noma, ngaphandle kwalokho, kuya ku-½.

1. Khetha iseli lapho umphumela uzoboniswa khona. Chofoza inkinobho "Faka umsebenzi".



2. Ewindini evula Amakhosi omsebenzi ngifuna into I-ROOT. Khetha bese uchofoza inkinobho. "Kulungile".



3. Iwindi lempikiswano ivuleka. Ukungqubuzana komsebenzi owodwa I-ROOT iyinombolo. Umsebenzi ngokwayo wenza ukukhishwa kwengcambu yesigcawu senombolo efakiwe. Kodwa, njengoba izimpande zesikwele zifana nokuvuswa emandleni ka-½, khona-ke lokhu kukhetho kulungile kithi. Ensimini "Inombolo" faka inombolo 9 bese uchofoza inkinobho "Kulungile".



4. Emva kwalokho, umphumela ubalwa kuseli. Kulesi simo, lilingana no-3. Leli nani eliwumphumela wokuphakamisa 9 emandleni 0.5.

Kodwa, yiqiniso, basebenzisa le ndlela yokubala ngokungajwayelekile, besebenzisa izinketho eziningi ezikwaziwa futhi ezizwakalayo zokuzicubungula.

Isifundo: Indlela yokubala impande ku-Excel

Indlela 4: Bhala Inombolo ngeDeskithophu ku-Cell

Le ndlela ayihlinzeki ngezibalo ekwakhiweni. Isebenza kuphela uma nje udinga ukubhala inombolo ngezinga eliselifelini.

1. Fometha iseli ukuthi ibhaliswe kufomathi yombhalo. Khetha it. Ukuba ngaphakathi kuthebhu ethi "Ikhaya" kwi-tape ebhodini lamathuluzi "Inombolo", chofoza uhlu lokuhlunga olukhethiwe. Chofoza entweni "Umbhalo".



2. Kwelinye iseli, bhala inombolo nezinga layo. Isibonelo, uma sidinga ukubhala amathathu ukuya kweyesibili, bese sibhala "32".



3. Faka i-cursor esitokisini bese ukhetha kuphela idijithi yesibili kuphela.



4. I-keystroke Ctrl + 1 shayela iwindi lokufometha. Hlela umaki eduze kwepharamitha "I-Superscript". Sicindezela inkinobho "Kulungile".



5. Emva kwalokhu kusetshenziselwa, inombolo ecacisiwe enezinga izoboniswa esibukweni.

Qaphela! Nakuba inombolo izoboniswa ngokubonakalayo esitokisini ngezinga, i-Excel iyayithatha njengombhalo ocacile, hhayi inkulumo yezinombolo. Ngakho-ke, le nketho ayikwazi ukusetshenziselwa izibalo. Ngenxa yalezi zinhloso, irekhodi elijwayelekile elisetshenziswa kulolu hlelo - "^".

Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel

Njengoba ubona, ku-Excel kunezindlela eziningana zokuphakamisa inombolo emandleni. Ukuze ukhethe okhethekile, okokuqala, udinga ukunquma ukuthi yini oyidingayo inkulumo. Uma udinga ukwakha ukwakha inkulumo kwifomula noma ukuze ubale inani, ngakho-ke kungcono ukubhala "^". Kwezinye izimo, ungasebenzisa lo msebenzi IZIHLOKO. Uma udinga ukuphakamisa inombolo emandleni ka-0.5, khona-ke kungenzeka ukuthi ungasebenzisa lo msebenzi I-ROOT. Uma umsebenzisi efuna ukubukeka abonise inkulumo yamandla ngaphandle kwezenzo zokucubungula, ukufometha kuzokusiza.