Ungayikhulisa kanjani iziqu ze-Excel

Ukwakhiwa kwenombolo kuyisenzo esijwayelekile sezibalo. Kusetshenziswa ekubaleni okuhlukahlukene, zombili izinhloso zokuziqeqesha nokuzijwayeza. Uhlelo lwe-Excel lunamathuluzi owakhelwe ngaphakathi wokubala leli nani. Ake sibheke ukuthi ungazisebenzisa kanjani emacaleni ahlukahlukene.

Isifundo: Ungakubeka Kanjani I-Degree Sign in Microsoft Word

Ukwakhiwa kwezinombolo

Ku-Excel, kukhona izindlela ezifanayo ezimbalwa zokwakha inombolo. Lokhu kungenziwa ngosizo lophawu olujwayelekile, umsebenzi, noma ukusebenzisa ezinye, hhayi okujwayelekile, izinketho zezenzo.

Indlela 1: Ukwakhiwa kusetshenziswa uphawu

Indlela ethandwa kakhulu futhi eyaziwayo yokwakha inombolo ku-Excel ukusetshenziswa kophawu olujwayelekile "^" ngalezi zinhloso. I-formula template yokwakhiwa ibukeka kanjena:

= x ^ n

Kule formula, u-X inombolo eyakhiwe, n izingalo zokwakha.

1. Ngokwesibonelo, ukwakha inani le-5 kuya kwesine. Sikunoma yisiphi iseli seshidi noma ngentambo yefomula sikhiqiza okufakiwe okulandelayo:

   = 5 ^ 4



2. Ukuze wenze ukubalwa futhi ubonise imiphumela yayo esikrinini sekhompyutha, chofoza inkinobho ethi Enter kwikhibhodi. Njengoba sibona, esimweni sethu esithile, umphumela uzolingana no-625.

Uma ukwakhiwa kuyingxenye ebalulekile yokubalwa okuyinkimbinkimbi, inqubo yenziwa ngaphansi kwemithetho ejwayelekile yezibalo. Isibonelo, ukuthi, ngokwesibonelo, ngokwesibonelo 5 + 4 ^ 3, i-Excel ngokushesha yenza ukuqothulwa kwenombolo 4, bese wengeza.

Ngaphezu kwalokho, usebenzisa opharetha "^" Ungazakhela hhayi izinombolo ezijwayelekile, kodwa futhi nemininingwane equkethwe kubuhlu oluthile lwamashidi.

Kwakhiwe ngokuqukethwe kwe-degree yesithupha kweseli A2.

1. Kunoma iyiphi indawo yamahhala ephepheni, bhala le nkulumo:

   = A2 ^ 6



2. Chofoza inkinobho ethi Enter. Njengoba sikwazi ukubona, ukubalwa kwenziwa kahle. Kusukela kuseli-A2 kwakukhona inombolo 7, umphumela wokubalwa kwakungu-117649.



3. Uma sifuna ukwakha ikholomu ephelele yezinombolo ngezinga elifanayo, akudingekile ukuqopha ifomula ngenani ngalinye. Vele ushise ngomugqa wokuqala wetafula. Lapho-ke udinga nje ukuletha isikhombisi engxenyeni engezansi kwesokudla seseli ngefomula. Gcwalisa umaka kuzovela. Cindezela inkinobho yegundane kwesobunxele bese welula phansi etafuleni.

Njengoba ukwazi ukubona, wonke amanani wokuphumula oyifunayo akhiwe ngezinga elithile.

Le ndlela ilula futhi ilungele kakhulu ngangokunokwenzeka, futhi ngenxa yalokho ithandwa kakhulu ngabasebenzisi. Yilona esetshenziswa kwiningi lokubala.

Isifundo: Sebenza ngamafomula ku-Excel

Isifundo: Ungayenza kanjani i-autocomplete ku-Excel

Indlela 2: Umsebenzi wohlelo lokusebenza

I-Excel futhi inesici esikhethekile salokhu kubalwa. Ibizwa - ngeziqu. I-syntax yayo ibukeka kanjena:

= Degree (inombolo; degree)

Cabanga ngesicelo saso esibonelweni esithile.

1. Chofoza esitokisini, lapho sihlela ukubonisa umphumela wokubalwa. Chofoza inkinobho ethi "PASTE function".



2. I-Wizard iyavula. Uhlu lwezinto ezifuna irekhodi "degree". Ngemuva kokuthola, sikugqamisa bese sicindezela inkinobho ethi "KULUNGILE".



3. Iwindi lokuphikisana livuleka. Lo opharetha unezimpikiswano ezimbili - inombolo nezinga. Ngaphezu kwalokho, njengengxabano yokuqala, kungasebenza njengencazelo yenombolo kanye neseli. Okungukuthi, izenzo zenziwa ngokubonisana ngendlela yokuqala. Uma ikheli leseli lisethwe njengengxabano yokuqala, kwanele ukubeka ikhesa igundane enkambini "yenombolo", bese uqhafaza endaweni oyifunayo yeshidi. Emva kwalokho, inani lezinombolo eligcinwe kulo lizovela enkundleni. Ngokweqiniso, ikheli leseli lingasetshenziswa futhi kwinkambu ye- "degree" njengengxabano, kodwa ekusebenzeni akuvamile ukuthi kusetshenziswe. Ngemuva kwayo yonke imininingwane ifakiwe ukuze wenze ukubala, cindezela inkinobho ethi "Kulungile".

Ukulandela lokhu, umphumela wokubalwa kwalo msebenzi uboniswa endaweni, eyabelwe esinyathelweni sokuqala sezenzo ezichaziwe.

Ngaphezu kwalokho, iwindi lokuphikisana lingabizwa ngokuguqula ithebhu le- "formulas". Ethepheni, cindezela inkinobho ethi "Mathematical", etholakala ku- "function Library Library". Uhlu lwezinto ezitholakalayo ezivulwa, udinga ukukhetha u- "degree". Ngemuva kwalokho, iwindi lezimpiko lizoqala.

Abasebenzisi abanokuhlangenwe nakho okuthile kungenzeka bangabingeli i-wizard yemisebenzi, kepha bamane bafake ifomula esitokisini ngemuva kwesibonakaliso se- "=", ngokuya nge-synntax yayo.

Le ndlela iyinkimbinkimbi kakhulu kunaleyo eyedlule. Ukusetshenziswa kwayo kungasizakala uma ukubalwa kufanele kwenziwe ngaphakathi kwemingcele yomsebenzi oyinhlanganisela ohlanganisa abahlinzeki abaningana.

Isifundo: Imisebenzi yeWizard ku-Excel

Indlela 3: Ukusungulwa kwe-ROOT

Vele, le ndlela ayijwayelekile, kepha futhi ingaguqulwa uma udinga ukwakha inqwaba ye-0.5. Sizohlaziya leli cala ngesibonelo esithile.

Sidinga ukwakha i-9 ngezinga elithile le-0.5 noma elihlukile - ½.

1. Khetha iseli lapho umphumela uzoboniswa khona. Chofoza inkinobho ethi "PASTE function".



2. Efasiteleni elisebenzayo lemisebenzi ye-wizard, lifuna into yezimpande. Sigqagqa kancane bese ucindezela inkinobho ethi "Kulungile".



3. Iwindi lokuphikisana livuleka. Ukuphela kwengxabano yomsebenzi wempande yinombolo. Umsebenzi ngokwawo wenza ukukhishwa kwempande yesikwele kusuka kwinombolo eyethuliwe. Kepha, njengoba impande yesikwele iyafana nokuzivocavoca i-degree ½, khona-ke le nketho isilungele thina. Ensimini "yenombolo", sifaka inombolo 9 bese uqhafaza inkinobho ethi "KULUNGILE".



4. Ngemuva kwalokho, umphumela ubalwa esitokisini. Kulokhu, kuyalingana no-3

Kepha-ke, le ndlela yokubalwa kwezibalo akuvamile, isebenzisa izinketho ezaziwayo futhi ezinembile zokubala.

Isifundo: Ungakubala Kanjani Impande E-Exale

Indlela 4: Ukuqopha inombolo nge-degree esitokisini

Le ndlela ayihlinzeki ngokuqaliswa kwekhompyutha. Kusebenza kuphela lapho udinga nje ukubhala inombolo nge-degree esitokisini.

1. Sifometha iseli lapho ukungena kuzokwenziwa khona ngefomethi yombhalo. Siyakugqama. Ukuba se-EM TAB "IKHAYA" ku-Ribbon kubha yamathuluzi "inombolo", chofoza ohlwini olwehliswayo lohlu lokukhetha iFomethi yohlobo. Sichofoza "embhalweni".



2. Kwesinye iseli, bhala inombolo nezinga lawo. Isibonelo, uma kudingeka sibhale ezintathu kuye ngezinga lesibili, bese ubhala "32".



3. Sibeka isikhombisi esitokisini futhi sabela idijithi yesibili kuphela.



4. Ngokucindezela inhlanganisela ye-CTRL + 1, shayela iwindi lokufomatha. Faka umkhaza eduze nepharamitha "esheshayo". Chofoza inkinobho ethi "KULUNGILE".



5. Ngemuva kwalokhu okukhohlisayo, inombolo ebekiwe iyabonakala esikrinini.

QAPHELA! Naphezu kweqiniso lokuthi isibalo esifinyelela ezingeni esitokisini sizokhonjiswa esitokisini, ukugqama kuyakubona njengombhalo ojwayelekile, hhayi inkulumo yezinombolo. Ngakho-ke, ukuze izibalo, le ndlela ayinakusetshenziswa. Ngalezi zinhloso, kusetshenziswa irekhodi elijwayelekile degree kulolu hlelo - "^".

Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel

Njengoba ubona, ohlelweni lwe-Excel Kunezindlela eziningana zokuwela inombolo. Ukuze ukhethe inketho ethile, okokuqala, udinga ukunquma ukuthi kungani udinga inkulumo. Uma udinga ukwakha isisho sokubhala isisho kwifomula noma ukukala inani, khona-ke kufanelekile ukuqopha ngophawu lwe- "^". Kwezinye izimo, ungafaka umsebenzi we-degree. Uma udinga ukwakha inqwaba ye-0.5, khona-ke kungenzeka ukusebenzisa umsebenzi wezimpande. Uma umsebenzisi efuna ukubonisa ukubonakala kokubonisa amandla ngaphandle kwezenzo ze-computational, khona-ke ukufometha kuzokusiza.