Uyifumana njani ipesenti kwi-Excel?

Uhlaziyo lokugqibela: 12/01/2024
umbhali: Sebastian Vidal

Ukuba usebenza ne-Excel kwaye ufuna fumana iipesentiYehova, ufikile endaweni elungileyo! Kweli nqaku siza kukubonisa ngendlela elula nethe ngqo indlela yokwenza lo msebenzi ngokukhawuleza nangempumelelo. Uyifumana njani ipesenti kwi-Excel? Ngumbuzo oqhelekileyo kwabo bafunda ukusebenzisa esi sixhobo, kodwa ungakhathazeki, ngeengcebiso zethu uya kuba yingcali kulo mbandela ngokukhawuleza. Funda ukuze ufunde yonke into oyifunayo malunga nale nkqubo iluncedo kwi-Excel.

-Inyathelo ngenyathelo ➡️ Uzifumana njani iipesenti kwi-Excel?

  • Vula iMicrosoft Excel: Ukuqala ukuthatha iipesenti kwi-Excel, kufuneka uqale uvule inkqubo kwikhompyuter yakho.
  • Faka idatha yakho: Xa i-Excel ivuliwe, faka idatha yamanani oyifunayo ukubala ipesenti. Umzekelo, ukuba ufuna ukubala ipesenti yokukhula kwentengiso, kuya kufuneka ufake iintengiso ukusuka kumaxesha ahlukeneyo.
  • Khetha iseli apho ufuna ukubonisa khona ipesenti: Nqakraza kwiseli apho ufuna isiphumo sobalo lwepesenti sivele.
  • Bhala ifomula: Bhala ifomula ukubala ipesenti. Ifomyula esisiseko yokubala ipesenti ngu "=(part/total)*100", apho "part" linani ofuna ukubala kulo ipesenti kunye "totali" linani lilonke ethathwa kulo ipesenti.
  • Cofa u-Enter: Nje ukuba ubhale ifomula, cofa iqhosha elithi "Enter" le-Excel ukwenza ubalo kwaye ubonise umphumo kwiseli ekhethiweyo.
  • Fometha isiphumo: Ukuba uyafuna, unokufomatha isiphumo njengepesenti ukwenza kube lula ukufunda. Ukwenza oku, cofa ekunene kwiseli enesiphumo, khetha u- "Fomatha iiseli" kwaye ukhethe ukhetho lwepesenti.
Umxholo okhethekileyo- Cofa Apha  Uyibeka njani ividiyo kwisimo se-WhatsApp

Q&A

1. Indlela yokubala ipesenti kwi-Excel?

  1. Chwetheza inani ofuna ukubala ipesenti yalo kwiseli ye-Excel.
  2. Chwetheza ipesenti ofuna ukuyibala kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula =inani_iseli* (ipesenti_yeseli/100) kwaye cinezela Ngena.

2. Ungayifumana njani ipesenti yetotali kwi-Excel?

  1. Bhala inani lilonke kwiseli ye-Excel.
  2. Chwetheza ipesenti ofuna ukuyibala kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula = (isele_ iyonke*ipesenti_yeseli)/100 kwaye cinezela Ngena.

3. Uyibonisa njani ipesenti kwiseli ye-Excel?

  1. Chwetheza inani ofuna ukubala ipesenti yalo kwiseli ye-Excel.
  2. Chwetheza ipesenti ofuna ukuyibala kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula =inani_iseli* (ipesenti_yeseli/100) kwaye cinezela Ngena.
Umxholo okhethekileyo- Cofa Apha  Ukususa njani ukuthanda kuFacebook

4. Ibalwa njani ipesenti eyongezelekayo kwi-Excel?

  1. Chwetheza inani ofuna ukubala ipesenti yalo kwiseli ye-Excel.
  2. Bhala inani lilonke kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula =inani_iseli/iseli_ iyonke kwaye cinezela Ngena.

5. Indlela yokubala ukunyuka kwepesenti kwi-Excel?

  1. Bhala inombolo yokuqala kwi-Excel cell.
  2. Bhala inani lokugqibela kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula =(end_number_cell-start_number_cell)/start_number_cell*100 kwaye cinezela Ngena.

6. Uyenza njani ipesenti yegrafu kwi-Excel?

  1. Khetha idatha ofuna ukuyifaka kwigrafu.
  2. Cofa kwindawo ethi "Faka" kwi-Excel.
  3. Khetha uhlobo lwegrafu ofuna ukulusebenzisa kwimenyu yohlayo.
  4. Igrafu iya kuveliswa ngokuzenzekelayo ngeepesenti ezibaliweyo.

7. Ubalwa njani umahluko wepesenti kwi-Excel?

  1. Bhala inombolo yokuqala kwi-Excel cell.
  2. Bhala inani lokugqibela kwenye iseli ye-Excel.
  3. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  4. Bhala ifomula =(end_number_cell-start_number_cell)/start_number_cell*100 kwaye cinezela Ngena.
Umxholo okhethekileyo- Cofa Apha  Indlela yokwenza imali kwiphepha likaFacebook

8. Uyisebenzisa njani ifomathi yepesenti kwi-Excel?

  1. Khetha iseli okanye uluhlu ofuna ukufaka ukufomatha kuyo.
  2. Cofa ithebhu "Ekhaya" kwi-Excel.
  3. Cofa iqhosha elithi "%", okanye ukhethe u-"Percentage" kwimenyu yohlayo yohlobo lwenani.

9. Uwusebenzisa njani umsebenzi we-PERCENTAGE kwi-Excel?

  1. Chwetheza amanani ofuna ukuwasebenzisa kwiiseli ze-Excel.
  2. Beka ikhesa kwiseli apho ufuna isiphumo sivele khona.
  3. Bhala ifomula =PERCENTAGE(inani, inani_lilonke) kwaye cinezela Ngena.

10. Indlela yokubala iipesenti kwitafile yepivot kwi-Excel?

  1. Yenza itafile yepivot enedatha ofuna ukuyihlalutya.
  2. Tsala indawo equlethe amanani kwindawo ethi "Amaxabiso" kwitafile yepivot.
  3. Cofa kwindawo yexabiso kwitheyibhile yepivot kwaye ukhethe "Useto lweNdawo yeXabiso."
  4. Khetha "Bonisa amaxabiso njenge" kwaye ukhethe "% yetotali enkulu" okanye nayiphi na ipesenti ukhetho olufunayo.