Omunye wemisebenzi yokusebenza ngezibalo ezivame ukusetshenziselwa ubuchwepheshe kanye nezinye izibalo ukwakhiwa kwenombolo kumandla wesibili, okunye okubizwa ngokuthi isikwele esisodwa. Isibonelo, le ndlela ibala indawo yento noma isibalo. Ngeshwa, i-Excel ayinalo ithuluzi elihlukile elizobeka inombolo enikeziwe. Kodwa-ke, lo msebenzi ungenziwa ngokusebenzisa amathuluzi afanayo asetshenziselwa ukwakhiwa kwanoma yiliphi elinye izinga. Ake sithole ukuthi kufanele sisetshenziswe kanjani ukubala isikwele senombolo enikeziwe.
Inqubo ye-Squaring
Njengoba wazi, isikwele senombolo sibalwa ngokuyiphindaphinda ngokwayo. Lezi zimiso, ngokuqinisekile, zibeka ngaphansi kwalesi sibonakaliso ku-Excel. Kulolu hlelo, ungakha inamba esigcawini ngezindlela ezimbili: usebenzisa isibonakaliso sokuveza amafomula "^" futhi usebenzise umsebenzi IZIHLOKO. Cabanga nge-algorithm yokusebenzisa le ndlela ongayisebenzisa ukuze uhlole ukuthi ubani ongcono.
Indlela 1: ukulungiswa usebenzisa ifomula
Okokuqala, ake sicabangele indlela elula futhi ejwayelekile kakhulu yokwakhiwa kwezinga lesibili ku-Excel, okubandakanya ukusetshenziswa kwefomula nephawu "^". Kulesi simo, njengento okumele ibe yesikwele, ungasebenzisa inombolo noma ireferensi yeseli lapho inani elinikeziwe lezinombolo likhona.
Ifomu elijwayelekile lefomula ye-squaring kanje:
= n ^ 2
Kuye esikhundleni sakhe "n" udinga ukufaka inombolo ethize okufanele ibe yesikwele.
Ake sibone ukuthi lokhu kusebenza kanjani ngezibonelo ezithile. Okokuqala, sibala inombolo ezoba yingxenye yefomula.
- Khetha iseli kushidi lapho kubalwa khona ukubalwa. Sibeka uphawu lwakhe "=". Bese sibhala inani lezinombolo esizifuna ukwakha emagunyeni wesigcawu. Masibe inombolo 5. Okulandelayo, faka uphawu lwezinga. Kuyimpawu "^" ngaphandle izingcaphuno. Khona-ke kufanele sikhombise ukuthi yikuphi ukulungiswa okufanele kwenziwe. Njengoba isikwele siyizinga lesibili, sibeka inombolo "2" ngaphandle izingcaphuno. Ngenxa yalokho, kithi, sithole ifomula:
=5^2 - Ukuze ubonise imiphumela yezibalo esibukweni, chofoza inkinobho. Ngena kwikhibhodi. Njengoba ubona, uhlelo lubalwe kahle ukuthi inombolo 5 isikwele sizolingana 25.
Manje ake sibone ukuthi singabeka kanjani inani elitholakala kwenye iseli.
- Setha uphawu kufana (=) esitokisini lapho kubalwa inani elibalwe khona. Okulandelayo, chofoza kwisici sekhasi, iphi inombolo ofuna ukuyenza ibe yikwele. Ngemuva kwalokho kusukela kwekhibhodi sothayipha inkulumo "^2". Esikhathini sethu, sithole ifomula elandelayo:
= A2 ^ 2 - Ukubala umphumela, njengesikhathi sokugcina, chofoza inkinobho. Ngena. Isicelo sinquma futhi sibonisa inani lezinto ezikhethiwe zeshidi.
Indlela 2: usebenzisa umsebenzi we-POWER
Ungasebenzisa futhi umsebenzi we-Excel owakhelwe ngaphakathi ukuze udwebe inombolo. IZIHLOKO. Lo opharetha uwela esigabeni semisebenzi yezibalo futhi umsebenzi wakhe ukuphakamisa inani elithile lamanani kumandla akhethiwe. I-syntax yalo msebenzi ilandelayo:
= DEGREE (inombolo; degree)
Ukuphikisana "Inombolo" kungaba inombolo ethize noma isixhumanisi kwento yetshe lapho itholakala khona.
Ukuphikisana "Isiqu" ikhombisa izinga okufanele liphakanyiswe ngayo inombolo. Njengoba sibhekene nombuzo we-squaring, kithi-ke le mpikiswano izolingana 2.
Manje ake sibheke isibonelo esithile sendlela u-squaring owenziwa ngayo usebenzisa opharetha IZIHLOKO.
- Khetha iseli lapho umphumela wokubala uzoboniswa khona. Emva kwalokho chofoza kusithonjana "Faka umsebenzi". Itholakala ngakwesokunxele kwibha yefomula.
- Ifasitela iqala. Amakhosi omsebenzi. Senza ushintsho kuwo kusigaba "Isibalo". Ohlu oluvulwa, khetha inani "UKUKHULU". Bese uchofoza inkinobho. "Kulungile".
- Iwindi le-opharetha ocacisiwe lusiwe. Njengoba ubona, iqukethe amasimu amabili ahambelana nenombolo yezimpikiswano zalolu hlelo lwezibalo.
Ensimini "Inombolo" ucacise inani lezinombolo ukuthi libe ngu-squared.
Ensimini "Isiqu" ucacise inombolo "2", ngoba kudingeka senze ukwakhiwa ngokuqondile esigcawini.
Emva kwalokho, chofoza inkinobho. "Kulungile" phansi kwefasitela.
- Njengoba ubona, ngokushesha ngemva kwalokhu, umphumela we-squaring uboniswa esakhiweni esakhethiwe eshidi.
Futhi, ukuxazulula inkinga, esikhundleni senombolo, ngesimo sempikiswano, ungasebenzisa ireferensi yeseli lapho itholakala khona.
- Ukuze wenze lokhu, shayela ifasitela lokuphikisana lomsebenzi ongenhla ngendlela efanayo esenze ngayo ngenhla. Esikhathini sewindi lokuqalisa ensimini "Inombolo" ucacise isixhumanisi esitokisini lapho kutholakala khona inani lezinombolo, okumele kube ngu-squared. Lokhu kungenziwa ngokumane ubeke isikhombisi ensimini bese uchofoza inkinobho yegundane lesokunxele kwisici esilandelayo kushidi. Ikheli liboniswa ngokushesha efasiteleni.
Ensimini "Isiqu"Njengesikhathi sokugcina, faka inombolo "2"bese uchofoza inkinobho "Kulungile".
- Opharetha uhlela idatha engenisiwe futhi ubonisa umphumela wokubala esibukweni. Njengoba ungabona, kulokhu, umphumela uyalingana 36.
Bheka futhi: Ungakhulisa kanjani i-Excel
Njengoba ubona, ku-Excel kunezindlela ezimbili zokwenza inombolo: usebenzisa uphawu "^" futhi besebenzisa umsebenzi owakhiwe ngaphakathi. Zombili lezi zikhetho zingasetshenziswa ukwakha inombolo kunoma yiliphi elinye izinga, kodwa ukubala isikwele kuzo zombili izimo, udinga ukucacisa idijithi "2". Ngayinye yalezi zindlela zingenza izibalo, ngokuqondile ukusuka kunani elibalulwe ngamanani, ngakho-ke ngokufaka isicelo salokhu ngenhloso yesitokisi lapho itholakala khona. Ngokuvamile, lezi zinketho cishe zilingana nokusebenza, ngakho kunzima ukusho ukuthi ubani ongcono. Lapha, kunalokho kungumkhuba wemikhuba kanye nezinto eziza kuqala kumsebenzisi ngamunye, kodwa ifomula elinesimboli livame ukusetshenziswa kakhulu. "^".
