Omunye wemisebenzi ejwayelekile ukusebenza kwezibalo esetshenziswa kwezobunjiniyela nakwezinye izibalo ukukhulisa inombolo kumandla wesibili, okubizwa nangokuthi isikwele. Isibonelo, le ndlela ibala indawo yento noma isibalo. Ngeshwa, i-Excel ayinathuluzi elihlukile elingalinganisa inani elinikeziwe kahle. Kodwa-ke, lo msebenzi ungenziwa kusetshenziswa amathuluzi afanayo asetshenziselwa ukukhulisa noma yiliphi elinye ibanga. Ake sibheke ukuthi kufanele zisetshenziswe kanjani ukubala isikwele senombolo enikeziwe.
Inqubo eyisikwele
Njengoba wazi, isikwele senombolo sibalwa ngokuyiphindaphinda iyodwa. Lezi zimiso, yiqiniso, ngaphansi kwesibalo sale nkomba ku-Excel. Kulolu hlelo, ungakweleta inombolo ngezindlela ezimbili: ngokusebenzisa isithasiselo amafomula "^" kanye nokusebenzisa umsebenzi IDIVINILE. Cabanga nge-algorithm yokusebenzisa lezi zinketho ekusebenzeni ukuze uhlole ukuthi iyiphi engcono.
Indlela yoku-1: ukwakhiwa kusetshenziswa ifomula
Okokuqala, cabanga ngendlela elula futhi evame ukusetshenziswa yokwenyusa ukuya elesibili ku-Excel, okubandakanya ukusetshenziswa kwefomula enophawu "^". Ngasikhathi sinye, njengento okufanele yenziwe yisikwele, ungasebenzisa inombolo noma isixhumanisi esitokisini lapho leli nani lamanani litholakala khona.
Indlela ejwayelekile yefomula yokuphamba imi kanje:
= n ^ 2
Kulesi esikhundleni "n" udinga ukufaka inombolo ethile, okufanele ikalwe.
Ake sibheke ukuthi kusebenza kanjani kulezi zibonelo ezithile. Okokuqala, sizofaka izinombolo zenombolo ezoba yingxenye yefomula.
- Khetha iseli eshidini lapho kuzobalwa khona. Sibeka uphawu kuyo "=". Ngemuva kwalokho sibhala inani lezinombolo, esifuna ukulikala. Kukhale inombolo 5. Okulandelayo, sibeka uphawu lwe-degree. Kuwuphawu. "^" ngaphandle kwezingcaphuno. Ngemuva kwalokho kufanele sikhombise ukuthi ukwakheka kufanele kwenziwe ngezinga elingakanani. Njengoba isikwele siyidigri yesibili, sibeka inombolo "2" ngaphandle kwezingcaphuno. Ngenxa yalokho, kithi, ifomula yatholakala:
=5^2 - Ukubonisa umphumela wokubala esikrinini, chofoza inkinobho Ngena kwikhibhodi. Njengoba ukwazi ukubona, uhlelo balubala kahle lelo nani 5 isikwele sizolingana 25.
Manje ake sibheke ukuthi sikwele kanjani inani elitholakala kwesinye iseli.
- Setha isibonakaliso okulinganayo (=) esitokisini lapho kuzobukiswa khona inani eliphelele Okulandelayo, chofoza kwinto eshidi lapho inamba itholakala khona, ofuna ukuyikala. Ngemuva kwalokho, sithayipha inkulumo evela kukhibhodi "^2". Kithi, ifomula elandelayo yatholakala:
= A2 ^ 2 - Ukubala umphumela, njengokugcina, chofoza inkinobho Ngena. Uhlelo lokusebenza lubala futhi lubonise ingqikithi kuzinto ezikhethiwe zeshidi.
Indlela 2: sebenzisa umsebenzi we-DEGREE
Ungasebenzisa futhi umsebenzi owakhelwe ngaphakathi we-Excel ukukala inombolo. IDIVINILE. Lo opharetha ufakwa esigabeni semisebenzi yezibalo futhi umsebenzi wayo ukukhulisa inani elithile lezinombolo ngezinga elithile. I-syntax yomsebenzi yilena elandelayo:
= DEGREE (inombolo; idigri)
Ukuxabana "Inombolo" kungaba yinombolo ethile noma isethenjwa kuzinto zeshidi lapho itholakala khona.
Ukuxabana "Isiqu" kubonisa ukuthi inani kufanele likhuliswe ngalo. Njengoba sibhekene nombuzo wokuphamba kabili, ngakithi le ngxabano izolingana 2.
Manje ake sibheke isibonelo ukhonkolo sokuthi squaring kwenziwa kanjani usebenzisa opharetha IDIVINILE.
- Khetha iseli okuzokhonjiswa kulo umphumela wokubala. Ngemuva kwalokho chofoza isithonjana "Faka umsebenzi". Itholakala kwesobunxele sebha yefomula.
- Iwindows liqala ukukhuphuka. Umsebenzi Wizards. Senza ushintsho kulo esigabeni "Izibalo". Kuluhlu olwehliswayo, khetha inani "DEGREE". Bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana lo opharetha ochaziwe liqalisiwe. Njengoba ukwazi ukubona, iqukethe izinkambu ezimbili ezihambelana nenombolo yokuphikisana yalomsebenzi wezibalo.
Ensimini "Inombolo" khombisa inani lamanani okufanele likalwe.
Ensimini "Isiqu" khombisa inombolo "2", ngoba sidinga ukwenza ukucwazimula ngqo.
Ngemuva kwalokho chofoza inkinobho "Kulungile" endaweni engezansi yewindi.
- Njengoba ukwazi ukubona, ngokushesha emva kwalokhu umphumela wokuphindwe kabili uboniswa entweni ekhethwe ngaphambili yeshidi.
Futhi, ukuxazulula inkinga, esikhundleni senombolo ngendlela yokuphikisana, ungasebenzisa isixhumanisi esitokisini esikuyo.
- Ukuze wenze lokhu, sibiza iwindi lokuphikisana lomsebenzi ongenhla ngendlela efanayo naleyo esikwenze ngayo ngenhla. Ewindini elivulayo, enkundleni "Inombolo" khombisa isixhumanisi seseli lapho inani lamanani litholakala khona, okufanele likalwe. Lokhu kungenziwa ngokubeka nje ikhesa endle bese uchofoza kwesobunxele entweni ehambelana nayo eshidini. Ikheli lizovela ngokushesha efasiteleni.
Ensimini "Isiqu", njengokugcina, beka inombolo "2", bese uchofoza inkinobho "Kulungile".
- U-opharetha ucubungula imininingwane efakiwe bese ekhombisa umphumela wokubala esikrinini. Njengoba ukwazi ukubona, kulokhu, umphumela uba 36.
Bheka futhi: Indlela Yokukhulisa Amandla ku-Excel
Njengoba ukwazi ukubona, ku-Excel kunezindlela ezimbili zokuphindaphindana kwenombolo: usebenzisa uphawu "^" nokusebenzisa umsebenzi owakhelwe ngaphakathi. Zombili lezi zinketho zingasetshenziswa futhi ukukhulisa inombolo kunoma yiliphi elinye ibanga, kepha ukubala isikwele kuwo womabili amacala, kufanele ucacisele idigri "2". Ngayinye yalezi zindlela ingenza ukubala ngokuqondile kusuka kwinani elithile lezinombolo elicacisiwe, ngakho-ke ngokufaka isicelo kulezi zinhloso isixhumanisi esitokisini esikuyo. Ngokuvamile, lezi zinketho zicishe zilingane ekusebenzeni, ngakho-ke kunzima ukusho ukuthi iyiphi engcono. Lapha-ke yindaba yomkhuba nezinto eziza kuqala kumsebenzisi ngamunye, kepha imvamisa ifomula enophawu isasetshenziswa "^".
