Kodi mudafunikapo kuwerengera kuchotsera kapena kutsika mu Excel? Kapena mwina chotsani kuchuluka kwa chiwerengero kuti muwerenge misonkho kapena ma komisheni? M’nkhani ino tidzakuphunzitsani cómo restar el porcentaje en Excel m'njira yosavuta komanso yachangu. ⁢Kuphunzira momwe mungachitire izi kukuthandizani ⁤kufulumizitsa ⁤ntchito yanu mu spreadsheet ndikupeza zotsatira zolondola. Ziribe kanthu ngati ndinu woyamba kapena wogwiritsa ntchito kwambiri, kudziwa bwino njirayi kudzakuthandizani kwambiri pantchito zanu zatsiku ndi tsiku. Chifukwa chake tiyeni tilowe mudziko lodabwitsa la mafomula mu Excel!

- Pang'onopang'ono ➡️ Momwe mungachotsere kuchuluka mu Excel

Momwe mungachotsere peresenti mu Excel

• Tsegulani Microsoft Excel pa kompyuta yanu.
• Lowetsani deta mu Excel spreadsheet. Mwachitsanzo, mutha kukhala ndi mtengo woyambira komanso kuchuluka komwe mukufuna kuchotsa.
• Sankhani selo kumene mukufuna kuti zotsatira za kuchotsa ziwonekere.
• Lembani fomula mu cell yosankhidwa. Njira yochotsera peresenti mu Excel ndiye mtengo woyamba wochulukitsidwa ndi (1 kuchotsera peresenti). Gwiritsani ntchito chizindikiro cha nyenyezi ‍ (*) kuchulukitsa ndi chizindikiro chaperesenti (%) kuti mufotokoze kuchuluka kwake.
• Dinani Lowani kuti apeze zotsatira.

Mafunso ndi Mayankho

Momwe mungachotsere peresenti mu Excel

1. Momwe mungachotsere kuchuluka kwa nambala mu Excel?

1. Sankhani selo komwe mukufuna kuti zotsatira ziwonekere.
2. Lembani ⁤chizindikiro chofanana (=) chotsatiridwa ndi nambala yomwe mukufuna kuchotsapo.
3. Kenako lembani chizindikiro chochotsera (-) ndi kuchuluka komwe mukufuna kuchotsa.
4. Dinani Enter.
Mwachitsanzo: = 100-20%

2. Momwe mungawerengere kuchotsera mu Excel?

1. Sankhani selo kumene mukufuna kuti zotsatira ziwonekere.
2. ⁢ Lembani chizindikiro chofanana (=) chotsatiridwa ndi mtengo woyambirira.
3. Kenako lembani ⁢chizindikiro chochotsera (-) ⁣ndi kuchuluka kwa kuchotsera.
4. ⁢Dinani Enter.
Mwachitsanzo: = 150-15%

3. Momwe mungachotsere gawo kuchokera mu cell mu Excel ndikuwonetsa zotsatira mu selo lina?

1. Sankhani selo komwe mukufuna kuti zotsatira ziwonekere.
2. Lembani chilinganizo chomwe chimachotsa kuchuluka kwa selo loyambirira.
3. Dinani Enter.
Mwachitsanzo: mu cell A1 lembani =A2-10%

4. Momwe mungachotsere 20% pa nambala mu Excel?

1. Sankhani selo komwe mukufuna kuti zotsatira ziwonekere.
2. Lembani chizindikiro chofanana (=) ndikutsatiridwa ndi nambala yomwe mukufuna kuchotsapo 20%.
3. Kenako lembani⁤ chizindikiro chochotsera (-) ndi peresenti (20%).
4. Dinani Lowani.
Mwachitsanzo: = 200-20%

5. Mungapeze bwanji mtengo mutachotsera mu Excel?

1. Sankhani selo kumene mukufuna kuti zotsatira ziwonekere.
2. Lembani⁤ chizindikiro chofanana (=) chotsatiridwa ndi mtengo woyambirira.
3. Kenako lembani chizindikiro chochotsera (-) ndi kuchotsera.
4. Dinani Lowani.
Mwachitsanzo: = 80-10%

6. Momwe mungachotsere kuchuluka kwa kuchuluka mu Excel?

1. Sankhani selo kumene mukufuna kuti zotsatira ziwonekere.
2. Lembani chizindikiro chofanana (=) chotsatiridwa ndi chiwonkhetso.
3. Kenako lembani chizindikiro chochotsera (-) ⁢ndi kuchuluka komwe mukufuna kuchotsa.
4. Dinani Lowani.
Mwachitsanzo: = 500-25%

7. Kodi mungachotse bwanji kuchuluka kwa magawo mu Excel?

1. Sankhani selo⁢ komwe mukufuna kuti zotsatira ziwonekere.
2. Gwiritsani ntchito njira yoyenera kuchotsa maperesenti ochulukirachulukira.
3. Dinani Lowani.
Mwachitsanzo: = 100-20% -10%

8. Momwe mungachotsere 15% mu Excel?

1. Sankhani selo komwe mukufuna kuti zotsatira ziwonekere.
2. Lembani chizindikiro chofanana (=) ndikutsatiridwa ndi nambala yomwe mukufuna kuchotsamo 15%.
3. Kenako lembani minus sign (-) ndi maperesenti (15%).
4.⁤ Presiona Enter.
Mwachitsanzo: = 120-15%

9. Kodi mungawerengere bwanji VAT mu Excel?

1. Sankhani selo komwe mukufuna kuti zotsatira ziwonekere.
2. Lembani chizindikiro chofanana (=) chotsatiridwa ndi mtengo wopanda VAT.
3. Kenako lembani chizindikiro chochulutsa (*) ndi kuchuluka kwa VAT (mwachitsanzo 0.21 pa 21% VAT).
4. Dinani Lowani.
Mwachitsanzo: =100*0.21

10. Momwe mungachotsere kuchuluka kwa kuchuluka mu Excel ndikuwonetsa zotsatira ngati maperesenti?

1. Sankhani ⁢selo lomwe mukufuna kuti zotsatira ziwonekere⁤.
2. Lembani fomula yomwe imachotsa kuchuluka kwa selo loyambirira ndikulichulukitsa ndi 100.
3. Dinani Lowani.
Mwachitsanzo: mu cell A1 lembani =(A2-10%)*100