Indlela Yokwenza Isikwele Inombolo ku-Excel

Ukulinganisa inombolo kusipredishithi kungase kubonakale kuyinselele, kodwa nge-Microsoft Excel, lo msebenzi ulula kakhulu. Kulesi sihloko, sizofaka ngqo indlela yokwenza. Kungakhathaliseki ukuthi usebenza inkinga yezibalo noma udinga ukubala izindawo ngamasethi amakhulu edatha, lesi sifundo sizokufundisa Indlela Yokwenza Isikwele Inombolo ku-Excel ngendlela elula futhi esheshayo. Sizokukhombisa ukuthi ungasebenzisa kanjani amafomula akhona nokuthi ungawadala kanjani awakho ukuze afanele izidingo zakho ezithile. Masiqhubekele phambili ndawonye kulolu hambo lokufunda lwe-Excel.

Isinyathelo ngesinyathelo ➡️ Indlela Yokufaka Isikwele Inombolo ku-Excel,

• Vula ishidi lakho lokusebenza ku-Excel: Isinyathelo sokuqala ukuya Indlela Yokwenza Isikwele Inombolo ku-Excel ukuvula uhlelo lwe-Excel bese ukhetha ishidi lapho ufuna ukwenza khona isibalo.
• Khetha iseli lapho ofuna ukufaka khona inombolo eyisikwele: Uma ishidi lokusebenzela selivuliwe, khetha iseli lapho ohlele ukufaka khona inombolo ofuna ukuyiskwele.
• Faka u-opharetha «=»: Ngaphambi kokubhala noma iyiphi ifomula ku-Excel, kufanele njalo uqale ngo-opharetha u-“="”.
• Bhala inombolo ofuna ukuyiskwele: Ngokushesha ngemva kuka-opharetha "=", thayipha inombolo ofuna ukuyiskwele. Isibonelo, uma ufuna ukufaka isikwele kunombolo 5, ifomula kuze kube manje izoba "=5."
• Sebenzisa i-opharetha ethi «^»: Lo opharetha uyadingeka Indlela Yokwenza Isikwele Inombolo ku-Excel. Itholakala phezulu kukhibhodi yakho, kukhiye ofanayo nowenombolo 6. Ukuze usikwele inombolo ku-Excel, kufanele wengeze lo opharetha kufomula yakho ngemva kwenombolo.
• Engeza inombolo 2 ekupheleni kwefomula yakho: Ukuze uqedele ifomula futhi usikwele inombolo, kufanele wengeze inombolo "2" ngemva kuka-opharetha "^". Ngokuqhubeka nesibonelo sangaphambilini, ifomula izoba "=5^2".
• Shaya ukhiye wokungena: Ngemva kokuqeda ifomula, cindezela ukhiye u-Enter kukhibhodi yakho. Ngale ndlela, i-Excel izobala umphumela futhi ibonise inombolo eyisikwele kuseli ekhethiwe.

Q&A

1. Ngingayenza kanjani isikwele inombolo ku-Excel?

Ukuze usikwele inombolo ku-Excel, kufanele ulandele lezi zinyathelo:

1. Khetha iseli lapho ofuna ukuthi umphumela uvele khona.
2. Bhala =n^2, lapho u-"n" kuyinombolo ofuna ukuyiskwele.
3. Chofoza u-Enter.

2. Ngingasikwebela kanjani uchungechunge lwezinombolo ku-Excel?

Uma ufuna ukufaka isikwele uchungechunge lwezinombolo ku-Excel, ungakwenza ngale ndlela elandelayo:

1. Khetha iseli lapho ofuna ukuthi umphumela wokuqala uvele khona.
2. Bhala =A1^2, uma okuthi "A1" kuyiseli lapho inombolo yokuqala yochungechunge itholakala khona.
3. Chofoza u-Enter.
4. Hudulela ifomula phansi ukuze uyisebenzise kuzo zonke ezinye izinombolo.

3. Ungawusebenzisa kanjani umsebenzi WAMANDLA ukuze usikwele inombolo ku-Excel?

Ukuze usebenzise umsebenzi we-POWER ku-Excel, kufanele ulandele lezi zinyathelo:

1. Khetha iseli lapho ofuna ukuthi umphumela uvele khona.
2. Bhala = AMANDLA(n;2) lapho u-"n" kuyinombolo ofuna ukuyiskwele.
3. Ekugcineni, cindezela inkinobho ethi Enter ukuze uthole umphumela.

4. Ingabe ikhona indlela yokwenza izinombolo zesikwele ku-Excel?

Yebo, kunendlela yokwenza izinombolo zesikwele ku-Excel. Kulula njengokubhala «=n^2», lapho okuthi "n" kuyinombolo okufanele iphindwe kabili futhi i-"^" imele ukusebenza kwezibalo kwesikwele.

5. Ngingayifaka kanjani inombolo eyisikwele kuseli efanayo ku-Excel?

Ungafaka inombolo eyisikwele kuseli efanayo ngendlela elandelayo:

1. Chofoza iseli enenombolo ofuna ukuyiskwele.
2. Bhala =RC[0]^2 kubha yefomula.
3. Cindezela inkinobho ethi Enter.

6. Ngingaziskwele kanjani izinombolo ngaphandle kokusebenzisa umsebenzi WAMANDLA ku-Excel?

Ungaskwele izinombolo ku-Excel ngaphandle komsebenzi WAMANDLA. Vele ulandele lezi zinyathelo:

1. Khetha iseli lapho ungathanda ukuthi umphumela utholakale khona.
2. Bhala =n^2 kubha yefomula, lapho u-"n" kuyinombolo ofuna ukuyiskwele.
3. Ekugcineni, cindezela inkinobho ethi Enter.

7. Ngingasikwebela kanjani uhla lwamaseli ku-Excel?

Ukuze usikwele ububanzi bamaseli ku-Excel, landela lezi zinyathelo:

1. Khetha iseli lapho ofuna ukuthi umphumela wokuqala uvele khona.
2. Bhala =A1^2 (no-"A1" eyiseli yokuqala ebangeni).
3. Chofoza u-Enter.
4. Hudulela ifomula phansi ukuze uyisebenzise kuwo wonke amaseli ebangeni.

8. Ngingakwazi ukusebenzisa i-Excel ukubala impande eyisikwele ephambene yenombolo?

Yebo, ukuze ubale impande eyisikwele ephambene yenombolo ku-Excel, kufanele ulandele lezi zinyathelo:

1. Khetha iseli lapho ofuna ukuthola khona impendulo.
2. Bhala =IMPANDE(n), lapho u-"n" kuyinombolo ofuna ukuthola umsuka wayo.
3. Cindezela inkinobho ethi Enter.

9. Ngingasithola kanjani isikwele senombolo futhi ngisiveze kuseli ehlukile ku-Excel?

Ukuze uthole isikwele senombolo futhi ubonise umphumela kuseli ehlukile, landela lezi zinyathelo:

1. Khetha iseli lapho ofuna ukuthi umphumela uvele khona.
2. Bhala =n^2 (lapho u-"n" kuyiseli eliqukethe inombolo ofuna ukuyifaka isikwele).
3. Chofoza u-Enter.

10. Ngingayenza kanjani isikwele inombolo kuseli le-Excel ngisebenzisa i-macro?

Ukuze usikwele inombolo kuseli le-Excel usebenzisa i-macro, landela lezi zinyathelo:

1. Cindezela u-Alt + F11 ukuze uvule Isihleli se-VBA.
2. Chofoza okuthi Faka > Imojula.
3. Bhala imakhro efaka isikwele inombolo kuseli. Ngokwesibonelo: Ibanga("A1").Inani = Ibanga("A1").Inani ^ 2.
4. Cindezela u-F5 ukuze usebenzise i-macro.