Umsebenzi wokwakha ku-Excel

Enye yezinyathelo ezivame kakhulu zezibalo ezisetshenziselwa ubunjiniyela kanye nezinye izibalo ukwakheka kwenombolo nge-degree yesibili, okuhlukile kwesinye isikwele. Isibonelo, le ndlela ibala indawo yento noma isibalo. Ngeshwa, alikho ithuluzi elihlukile ohlelweni lwe-Excel oluzokwakha inombolo ebekiwe esigcawini. Noma kunjalo, lo msebenzi ungenziwa kusetshenziswa amathuluzi afanayo asetshenziselwa ukwakha amanye amazinga. Ake sibheke ukuthi ungawasebenzisa kanjani ukubala isikwele kusuka kwinombolo ebekiwe.

Inqubo yokwakhiwa kwesikwele

Njengoba wazi, isikwele senombolo sibalwa ngokuphindaphindwa kwaso uqobo. Lezi zimiso ngokwemvelo zigcizelela ukubalwa kwenkomba echaziwe futhi ku-Excel. Kulolu hlelo, singakha inombolo esikweleni ngezindlela ezimbili: sisebenzisa uphawu lokuzivocavoca ngezinga ngamafomula "^" nokusebenzisa umsebenzi we-degree. Cabanga nge-algorithm yokusebenzisa lezi zinketho zokuzijwayeza ukwazisa ukuthi iyiphi engcono.

Indlela 1: Ukwakhiwa ngosizo lwefomula

Okokuqala, cabanga ngendlela elula futhi evame kakhulu yokwakha iziqu zesibili ku-Excel, okubandakanya ukusetshenziswa kwefomula ngophawu "^". Ngasikhathi sinye, njengento, ezophakanyiswa esigcawini, ungasebenzisa inombolo noma isixhumanisi esitokisini, lapho leli velu lenombolo likhona.

Ukubuka okujwayelekile kwefomula yokwakhiwa kwesikwele kungokulandelayo:

= N ^ 2

Kuyo, esikhundleni se- "n", kuyadingeka ukufaka inombolo ethile okufanele iphakanyiswe esikwele.

Ake sibheke ukuthi isebenza kanjani ezibonelweni ezithile. Ukuqala, kwakhiwe inombolo esigcawini esizoba yingxenye yefomula.

1. Sigqamisa iseli eshidini lapho ukubalwa kuzokwenziwa khona. Sibeka uphawu kuyo "=". Ngemuva kwalokho sibhala inani lezinombolo esifisa ukwakha iziqu zesikwele. Akube yinombolo 5. Okulandelayo, faka uphawu lwe-degree. Uphawu "^" Ngaphandle kwezicaphuno. Ngemuva kwalokho kufanele sichaze ukuthi iyiphi into okufanele yakhiwe. Njengoba isikwele siyisiqu sesibili, bese sibeka inombolo "2" ngaphandle kwezingcaphuno. Ngenxa yalokho, esimweni sethu, ifomula yaphenduka:

   = 5 ^ 2



2. Ukubonisa imiphumela yokubalwa esikrinini, chofoza ukhiye we-ENTER kukhibhodi. Njengoba ukwazi ukubona, uhlelo lubalwe kahle ukuthi inombolo 5 esigcawini izolingana no-25.

Manje ake sibheke ukuthi ungakha kanjani inani esigcawini esitholakala kwelinye iseli.

1. Faka uphawu "olulinganayo" (=) esitokisini lapho umphumela wokubala uzoboniswa khona. Okulandelayo, chofoza kwinto yeshidi, lapho inombolo ofuna ukwakha isikwele. Ngemuva kwalokho, kusuka kukhibhodi, sibusha inkulumo ethi "^ 2 2". Endabeni yethu, ifomula elilandelayo laphenduka:

   = A2 ^ 2



2. Ukubala umphumela, njengoba okokugcina, chofoza inkinobho ethi Enter. Uhlelo lokusebenza lubalwa futhi lubonisa umphumela ekhasini leshidi elikhethiwe.

Indlela 2: Kusetshenziswa umsebenzi we-degree

Futhi, ukwakha inombolo esikweleni, ungasebenzisa umsebenzi oshumekiwe we-Excel degree. Lo osebenzisana ungena esigabeni semisebenzi yezibalo kanye nomsebenzi wawo ukwakha inani elithile lamanani ngezinga elithile. I-syntax yomsebenzi imi kanjena:

= Degree (inombolo; degree)

Ingxabano "yenombolo" ingaba inombolo ethile noma ireferensi yento yeshidi, lapho itholakala khona.

Ingxabano "degree" ikhombisa izinga lapho inombolo idinga ukuyekwa khona. Njengoba sibhekene nombuzo wokwakhiwa kwesikwele, lapho-ke le ngxabano leli lizolingana no-2.

Manje ake sibheke isibonelo esithile, ukuthi ungasenza kanjani isikwele usebenzisa i-degree opharetha.

1. Khetha iseli lapho umphumela wokubalwa uzokhonjiswa. Ngemuva kwalokho, chofoza isithonjana esithi "Insert Function". Itholakala ngakwesobunxele sentambo yefomula.



2. Iwindows wizard wizard iqala ukusebenza. Sikhiqiza inguquko kuyo esigabeni esithi "Mathematics". Ohlwini olunqatshiwe, khetha inani le- "degree". Bese uchofoza inkinobho ethi "KULUNGILE".



3. Iwindi lezimpikiswano ze-opharetha ebekiwe yethulwa. Njengoba sibona, kunamasimu amabili kuwo, ahambelana nenombolo yezimpikiswano kulo msebenzi wezibalo.

   Ensimini ethi "Number", chaza inani lezinombolo okufanele likhuliswe esigcawini.

   Ensimini "degree", sicacisa inombolo "2", ngoba sidinga ukwenza kabusha isikwele.

   Ngemuva kwalokho, sichofoza inkinobho ethi "Kulungile" endaweni engezansi yewindi.



4. Njengoba ubona, ngokushesha nje ngemuva kwalokhu, umphumela wokwakhiwa kwesikwele kukhonjiswa engxenyeni eshidiwe ebekiwe.

Futhi, ukuxazulula umsebenzi, esikhundleni sengxabano embalwa, ungasebenzisa isixhumanisi esisekweni elitholakala kulo.

1. Ukuze wenze lokhu, shayela iwindi lezimpikiswano zomsebenzi ongenhla ngendlela efanayo nathi sikwenzile ngaphezulu. Ewindini eligijimayo kwinkambu ye- "Number", chaza ukuxhumana esitokisini, lapho inani lezinombolo litholakala esigcawini. Lokhu kungenziwa ngokumane kufakwe isikhombisi enkundleni bese uchofoza inkinobho yegundane kwesobunxele endaweni efanele eshidini. Ikheli lizovela ngokushesha efasiteleni.

   Ensimini "degree", njengoba okokugcina, sibeka inombolo "2", bese uqhafaza inkinobho ethi "KULUNGILE".



2. I-opharetha icubungula idatha efakiwe futhi ibonisa umphumela wokubala esikrinini. Njengoba sibona, kulokhu, umphumela ongenzeka ulingana no-36.

Bheka futhi: ukuthi ungakha kanjani iziqu ku-Excel

Njengoba ubona, kunezindlela ezimbili zokuwela inombolo esikweleni: usebenzisa uphawu lwe- "^" nokusebenzisa umsebenzi owakhelwe ngaphakathi. Zombili lezi zinketho zingasetshenziswa nokwakha inombolo kunoma yiliphi elinye iziqu, kepha ukubala isikwele kuzo zombili lezi zigameko udinga ukucacisa i-degree "2". Ngayinye yezindlela ezibekiwe zingenza izibalo, ngokuqondile kusuka kwinani lezinombolo elicacisiwe, ngakho-ke ukusebenzisa isixhumanisi esitokisini lapho kutholakala khona ngalezi zinhloso. Ngobukhulu, lezi zinketho zilingana ngokusebenza, ngakho-ke kunzima ukusho ukuthi iyiphi engcono. Kungcono udaba lwemikhuba kanye nezinto eziza kuqala zomsebenzisi ngamunye, kepha ifomula ngophawu "^" kuvame ukusetshenziswa kaningi.