Indlela yokwekwere inani kwi-Excel

Ukulinganisa inani kwispredishithi kunokubonakala kungumngeni, kodwa ngeMicrosoft Excel, lo msebenzi ulula kakhulu. Kweli nqaku, siza kugubungela ngqo indlela yokwenza oko. Nokuba usebenza kwingxaki yezibalo okanye ufuna ukubala iindawo kwiiseti ezinkulu zedatha, esi sifundo siya kukufundisa. Indlela yokwekwere inani kwi-Excel ngendlela elula nekhawulezayo. Siza kukubonisa indlela yokusebenzisa iifomula ezikhoyo kunye nendlela yokwenza eyakho ukuze ilingane neemfuno zakho. Masiqhubele phambili kunye kolu hambo lokufunda lwe-Excel.

Inyathelo ngenyathelo ➡️ Ulibeka njani inani kwi-Excel,

• Vula iphepha lakho lomsebenzi kwi-Excel: Inyathelo lokuqala ukuya Indlela yokwekwere inani kwi-Excel kukuvula inkqubo yeExcel kwaye ukhethe iphepha lomsebenzi apho ufuna ukwenza khona ubalo.
• Khetha iseli apho ufuna ukufaka khona inani eliphindwe kabini: Lakuba livuliwe iphepha lomsebenzi, khetha iseli apho uceba ukufaka inombolo ofuna ukuyisquare.
• Ngenisa umsebenzisi «=»: Phambi kokuba ubhale nayiphi na ifomula kwi-Excel, kufuneka usoloko uqala ngo-“="” umsebenzisi.
• Bhala inani ofuna ukulikwere: Kwangoko emva kokuba "="" umsebenzisi, chwetheza inombolo ofuna ukuyisquare. Umzekelo, ukuba ufuna ukuphinda-phinda inani lesi-5, ifomula ukuza kuthi ga ngoku izakuba ngu "=5."
• Sebenzisa «^» umsebenzisi: Lo mqhubi uyafuneka Indlela yokwekwere inani kwi-Excel. Ibekwe phezulu kwibhodi yezitshixo yakho, kwiqhosha elifanayo njengenombolo 6. Ukukwereta inani kwi-Excel, kufuneka udibanise lo msebenzisi kwifomula yakho emva kwenombolo.
• Yongeza inani lesi-2 ekupheleni kwefomula yakho: Ukugqiba ifomyula kunye nesikweri senombolo, kufuneka wongeze inani "2" emva komqhubi "^". Ukuqhubela phambili nomzekelo wangaphambili, ifomula iya kuba "=5^2".
• Cofa iqhosha lokungena: Emva kokugqiba ifomula, cofa iqhosha elithi Faka kwikhibhodi yakho. Ngale ndlela, i-Excel iya kubala isiphumo kwaye ibonise inani eliphindwe kabini kwiseli ekhethiweyo.

Q&A

1. Ndingaliphinda njani inani kwi-Excel?

Ukukwereta inani kwi-Excel, kufuneka ulandele la manyathelo:

1. Khetha iseli apho ufuna isiphumo sivele khona.
2. Bhala =n^2, apho u-"n" linani ofuna ukusquaretha.
3. Cofa iqhosha elithi Faka.

2. Ndingenza njani isikwere uthotho lwamanani kwi-Excel?

Ukuba ufuna ukwenza isikwere uthotho lwamanani kwi-Excel, ungayenza ngolu hlobo lulandelayo:

1. Khetha iseli apho ufuna isiphumo sokuqala sivele khona.
2. Bhala =A1^2, ukuba "A1" yiseli apho inani lokuqala loluhlu lukhoyo.
3. Cofa iqhosha elithi Faka.
4. Tsala ifomula ezantsi ukuze uyisebenzise kwamanye amanani.

3. Uwusebenzisa njani umsebenzi WAMANDLA ukusquare inani kwi-Excel?

Ukusebenzisa umsebenzi WAMANDLA kwi-Excel, kufuneka ulandele la manyathelo:

1. Khetha iseli apho ufuna isiphumo sivele khona.
2. Bhala = AMANDLA(n;2) apho u-"n" linani ofuna ukusquare.
3. Ekugqibeleni, cofa iqhosha elithi Faka ukuze ufumane isiphumo.

4. Ingaba ikhona indlela yokuya kumanani asisikwere kwi-Excel?

Ewe, kukho indlela yokuya kumanani asisikwere kwi-Excel. Ilula njengokubhala «=n^2», apho u-"n" linani kufuneka liphindwe kabini kwaye "^" imele usebenziso lwemathematika lwesiquaring.

5. Ndingalibeka njani inani eliphindwe kabini kwiseli enye kwi-Excel?

Ungabeka inani eliphindwe kabini kwiseli enye ngolu hlobo lulandelayo:

1. Cofa kwiseli enenombolo ofuna ukuyisquare.
2. Bhala =RC[0]^2 kwibha yefomula.
3. Cofa iqhosha elithi Faka.

6. Ndingawasquare njani amanani ngaphandle kokusebenzisa umsebenzi WAMANDLA kwi-Excel?

Ungasquare amanani kwi-Excel ngaphandle komsebenzi WAMANDLA. Landela la manyathelo ngokulula:

1. Khetha iseli apho ungathanda ukuba isiphumo sibe khona.
2. Bhala =n^2 kwibha yefomula, apho "n" linani ofuna ukuliphinda kabini.
3. Ekugqibeleni, cofa iqhosha elithi Enter.

7. Ndingaluphinda njani uluhlu lweeseli kwi-Excel?

Ukukwereta uluhlu lweeseli kwi-Excel, landela la manyathelo:

1. Khetha iseli apho ufuna isiphumo sokuqala sivele khona.
2. Bhala =A1^2 (nge "A1" ibe yiseli yokuqala kuluhlu).
3. Cofa iqhosha elithi Faka.
4. Tsala ifomula ezantsi ukuze uyisebenzise kwezinye iiseli kuluhlu.

8. Ndingasebenzisa i-Excel ukubala i-inverse root yesikweri yenani?

Ewe, ukubala ingcambu eguquliweyo yesikwere senani kwi-Excel, kufuneka ulandele la manyathelo:

1. Khetha iseli apho ufuna ukufumana khona impendulo.
2. Bhala =Ingcambu(n), apho "n" linani ofuna ukufumana ingcambu yalo.
3. Cofa iqhosha elithi Faka.

9. Ndingasifumana njani isikwere senani ndize ndilibonise kwiseli eyahlukileyo kwi-Excel?

Ukufumana isikwere senani kwaye ubonise isiphumo kwiseli eyahlukileyo, landela la manyathelo:

1. Khetha iseli apho ufuna isiphumo sivele khona.
2. Bhala =n^2 (apho "n" yiseli equlathe inani ofuna ukulikwere).
3. Cofa u-Enter.

10. Ndingaliphinda njani inani kwi-Excel cell ndisebenzisa imacro?

Ukukwereta inani kwiseli ye-Excel usebenzisa i-macro, landela la manyathelo:

1. Cinezela Alt + F11 ukuvula iVBA Editor.
2. Cofa Faka > Imodyuli.
3. Bhala imakhro ephinda-phinda inani kwiseli. Umzekelo: Uluhlu("A1").Ixabiso = Uluhlu("A1").Ixabiso ^ 2.
4. Cofa u-F5 ukuqhuba imakro.