Ngezibalo eziqhubekayo kumathebula e-Excel, umsebenzisi ngokushesha noma kamuva uzobhekana nesidingo sokukweleta izinombolo ezithile. Inqubo efanayo ivame ukwenziwa ekuxazululeni izinkinga ezihlukahlukene. - kusukela kuzibalo ezilula kuye kwizibalo zobunjiniyela eziyinkimbinkimbi. Kodwa-ke, naphezu kokusetshenziswa okubalulekile kwalo msebenzi, i-Excel ayinayo ifomula ehlukile ongasikwele ngayo izinombolo kumaseli. Ukuze wenze lokhu, udinga ukufunda indlela yokusebenzisa ifomula evamile, eyenzelwe ukuphakamisa izinombolo ngazinye noma amanani ayinkimbinkimbi edijithali emandleni ahlukahlukene.

Umgomo wokubala isikwele senombolo

Ngaphambi kokuthi uthole ukuthi ungakhuphula kanjani amanani ezinombolo ngendlela efanele emandleni esibili nge-Excel, udinga ukukhumbula ukuthi lokhu kusebenza kwezibalo kusebenza kanjani. Isikwele senombolo inombolo ethile ephindaphindwa ngokwayo.. Ukwenza lesi senzo sezibalo usebenzisa i-Excel, ungasebenzisa eyodwa yezindlela ezimbili ezifakazelwe:

• ukusetshenziswa kwezibalo umsebenzi AMANDLA;
• ukusetshenziswa kwefomula lapho uphawu lwe-eksponenti “^” luboniswa phakathi kwamanani.

Indlela ngayinye kumele icatshangelwe ngokuningiliziwe ekusebenzeni.

Ifomula yokubala

Indlela elula yokubala isikwele sedijithi noma inombolo ethile iwukusebenzisa ifomula enophawu lwedigri. Ukubukeka kwefomula: =n^2. N yinoma iyiphi idijithi noma inani lezinombolo elizophindaphindwa ngokwalo ukuze liphindwe. Kulokhu, inani lale agumenti lingacaciswa ngezixhumanisi zamaseli, noma ngenkulumo ethile yezinombolo.

Ukuze uqonde ukuthi ungasebenzisa kanjani ifomula ngendlela efanele ukuze uthole umphumela oyifunayo, kubalulekile ukucabangela izibonelo ezi-2 ezisebenzayo. Inketho ebonisa inani elithile lenombolo kufomula:

1. Khetha iseli lapho umphumela wokubala uzoboniswa khona. Imake nge-LMB.
2. Bhala ifomula yaleli seli emugqeni wamahhala eduze kophawu "fx". Isibonelo sefomula elula kakhulu: =2^2.
3. Ungabhala ifomula kuseli ekhethiwe.

4. Ngemva kwalokho, kufanele ucindezele u-“Enter” ukuze umphumela wokubala ngomsebenzi uvele kuseli ephawuliwe.

Inketho ebonisa izixhumanisi zeseli, inombolo okufanele iphakanyiswe emandleni esibili:

1. Bhala kusengaphambili inombolo 2 kuseli engavunyelwe, isibonelo B

2. Khetha ngokucindezela i-LMB iseli lapho ofuna ukuveza khona umphumela wokubala.
3. Bhala uhlamvu lokuqala "=", emva kwalokho - izixhumanisi zeseli. Kufanele zigqame ngokuzenzakalelayo ngokuluhlaza okwesibhakabhaka.
4. Okulandelayo, udinga ukufaka uphawu “^”, inombolo yedigri.
5. Isenzo sokugcina ukucindezela inkinobho ethi "Enter" ukuze uthole umphumela oyifunayo.

Kubalulekile! Ifomula evezwe ngenhla ingeyomhlaba wonke. Ingasetshenziselwa ukuphakamisa amanani ezinombolo emandleni ahlukahlukene. Ukwenza lokhu, vele ufake inombolo engemuva kophawu “^” ufake oludingekayo.

Umsebenzi WAMANDLA kanye nokusebenza kwawo

Indlela yesibili, ebhekwa njengeyinkimbinkimbi kakhulu mayelana nokufaka inombolo ethile, ngokusebenzisa umsebenzi WAMANDLA. Iyadingeka ukuze ukhuphule amanani ezinombolo ahlukahlukene kumaseli wethebula le-Excel emandleni adingekayo. Ukubonakala kwayo yonke ifomula yezibalo ehlotshaniswa nale opharetha: = AMANDLA(inombolo edingekayo, amandla). Incazelo:

1. Idigri impikiswano yesibili yomsebenzi. Lisho izinga elithile ukuze kubalwe okwengeziwe umphumela kusukela kudijithi yokuqala noma inani lenombolo. Uma udinga ukuphrinta isikwele senombolo, udinga ukubhala inombolo 2 kule ndawo.
2. Inombolo ingxabano yokuqala yomsebenzi. Imele inani lezinombolo elifiswayo lapho kuzosetshenziswa khona inqubo yezibalo ze-squaring. Ingabhalwa njengesixhumanisi seseli nenombolo noma idijithi ethile.

Inqubo yokukhuphula inombolo emandleni esibili ngokusebenzisa umsebenzi WAMANDLA:

1. Khetha iseli yethebula lapho umphumela uzovezwa khona ngemva kokubala.
2. Chofoza uphawu ukuze ungeze umsebenzi - "fx".
3. Iwindi elithi “Function Wizard” kufanele livele ngaphambi komsebenzisi. Lapha udinga ukuvula isigaba esivele sikhona, khetha u-“Mathematics” ohlwini oluvulayo.

4. Kuhlu oluhlongozwayo lwabasebenzisi, udinga ukukhetha "DEGREE". Qinisekisa ukukhetha ngokucindezela inkinobho ethi "OK".
5. Okulandelayo, udinga ukusetha izimpikiswano ezimbili zokusebenza. Esigabeni samahhala "Inombolo" udinga ukufaka inombolo noma inani elizokhushulwa emandleni. Esigabeni samahhala "Iziqu" kufanele ucacise idigri edingekayo (uma lokhu kuyi-squaring - 2).
6. Isinyathelo sokugcina ukuqedela ukubala ngokucindezela inkinobho ethi OK. Uma konke kwenziwa ngendlela efanele, inani elenziwe ngomumo lizovela kuseli elikhethwe kusengaphambili.

Indlela yokukhulisa inombolo emandleni usebenzisa izixhumanisi zamaseli:

1. Kwiseli ehlukile, faka inombolo ezophinda iphindwe.
2. Okulandelayo, faka umsebenzi kwelinye iseli ngokusebenzisa “Iseluleki Somsebenzi”. Khetha "Izibalo" ohlwini, chofoza umsebenzi "DEGREE".
3. Ewindini elivulayo, lapho izimpikiswano zomsebenzi kufanele zicaciswe, kufanele ufake amanye amanani, ngokungafani nendlela yokuqala. Esigabeni samahhala "Inombolo" kufanele ucacise izixhumanisi zeseli lapho inani lenombolo eliphakanyiswe emandleni litholakala khona. Inombolo 2 ifakwe endaweni yesibili yamahhala.

4. Kusele ukucindezela inkinobho ethi "KULUNGILE" futhi uthole umphumela ophelile kuseli elimakiwe.

Akufanele sikhohlwe ukuthi umsebenzi WAMANDLA ujwayelekile, ufanelekile ukuphakamisa izinombolo emandleni ahlukahlukene.

Isiphetho

Ngokwezibalo ezisemthethweni, phakathi kokunye ukusebenza kwezibalo, abasebenzisi abasebenza kumaspredishithi e-Excel bayisikwele samanani ezinombolo ahlukahlukene kaningi kakhulu kunokuba benza ezinye izinqubo ezivela kuleli qembu. Kodwa-ke, ngenxa yokuthi awukho umsebenzi ohlukile walesi senzo ohlelweni, ungasebenzisa ifomula ehlukile lapho kufakwa khona inombolo edingekayo, noma ungasebenzisa opharetha we-POWER ohlukile, otholakala ongakhetha kuwo Umsebenzi Wizard.