Uwakhipha kanjani amaseli ku-Google AmaSpredishithi

Isibuyekezo sokugcina: 14/02/2024
Umbhali: USebastian Vidal

Sawubona Tecnobits! Ingabe usukulungele ukususa amaseli ku-Google AmaSpredishithi futhi ujabulise wonke umuntu ngamakhono akho esipredishithi? 💻💪 Ungaphuthelwa ukuthi uwakhipha kanjani amaseli AmaSpredishithi e-Google futhi uphumelele ekuhlaziyeni kwakho idatha.

1. Ngingawasusa kanjani amaseli ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha amaseli ofuna ukuwakhipha: Chofoza iseli lapho ofuna ukubona khona umphumela wokukhipha, bese ukhetha amaseli ofuna ukuwakhipha.
  3. Bhala ifomula yokususa: Kubha yefomula, thayipha =KHIPHA(iseli1, iseli2), lapho okuthi "cell1" kanye "cell2" kungamaseli ofuna ukuwakhipha. Isibonelo, uma ubufuna ukususa iseli A1 kuseli B1, ubungathayipha =KHIPHA(A1, B1).
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.

2. Ngenzenjani uma ngifuna ukususa ububanzi bamaseli ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokukhipha: Chofoza kuseli lapho ufuna khona ukuthi umphumela wokukhipha uvele.
  3. Bhala ifomula yokukhipha enobubanzi bamaseli: Kubha yefomula, thayipha =SUM(cell_range1) – SUM(cell_range2), lapho okuthi “cell_range1” kanye “cell_range2” kuwububanzi beseli ofuna ukubukhipha. Isibonelo, uma ufuna ukususa ububanzi A1:A10 kububanzi B1:B10, ungabhala =USUM(A1:A10) – I-SUM(B1:B10).
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.
Okuqukethwe okukhethekile - Chofoza Lapha  Ungalikopisha kanjani lonke ikhasi ku-Google Amadokhumenti

3. Ingabe kungenzeka ukususa amaseli ngokwemibandela ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokukhipha okunemibandela: Chofoza iseli lapho ufuna ukuthi kuvele khona umphumela wokukhipha onemibandela.
  3. Bhala ifomula yokukhipha enemibandela: Kubha yefomula, thayipha =KHIPHA yebo, elandelwa amapharamitha wesimo. Isibonelo, uma ufuna ukususa iseli kuphela uma inani likhulu kuno-10, ungabhala =SI(A1>10;RESTA(A1,B1);0).
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha okunemibandela kuseli ekhethiwe.

4. Ithini ifomula yokususa amaphesenti ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokususwa kwephesenti: Chofoza iseli lapho ufuna ukuthi kuvele khona umphumela wokukhipha iphesenti.
  3. Bhala ifomula yokususa iphesenti: Kubha yefomula, thayipha ifomula ukuze ubale iphesenti. Isibonelo, uma ubufuna ukususa u-10% kuseli A1, ubungathayipha =A1*0.9 (uma iphesenti liwukususa) noma =A1*(1-0.1).
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha iphesenti kuseli ekhethiwe.

5. Ngingakwazi yini ukususa amaseli kumashidi ahlukene ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokukhipha: Chofoza kuseli lapho ufuna khona ukuthi umphumela wokukhipha uvele.
  3. Bhala ifomula yokukhipha ngezinkomba zamashidi ahlukene: Kubha yefomula, bhala ifomula ngezinkomba zamashidi ahlukene. Isibonelo, uma ubufuna ukususa iseli A1 ku-Sheet1 kuseli B1 ku-Sheet2, ubungathayipha. =Ishidi1!A1 – Ishidi2!B1.
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.
Okuqukethwe okukhethekile - Chofoza Lapha  Usibeka kanjani isithombe esisobala ku-Google Amaslayidi

6. Ngingakwazi yini ukususa amaseli ahlanganiswe nombhalo ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokukhipha namaseli ahlanganiswe nombhalo: Chofoza kuseli lapho ufuna khona ukuthi umphumela wokukhipha uvele.
  3. Bhala ifomula yokukhipha ngamaseli ahlanganiswe nombhalo: Kubha yefomula, thayipha ifomula usebenzisa umsebenzi =SUBSTITUTE(SUBSTI TOTAL) ukuhlunga umbhalo nokwenza ukususa. Isibonelo, uma ufuna ukususa inani kuseli A1 elinengxube yombhalo nezinombolo kuseli B1, ungathayipha =SUBSTITUTE(A1, «umbhalo», «»),KHIPHA(B1).
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.

7. Ngingawasusa kanjani amaseli anamadesimali ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha iseli lapho ofuna ukubona khona umphumela wokukhipha ngamadesimali: Chofoza kuseli lapho ufuna khona ukuthi umphumela wokukhipha uvele.
  3. Bhala ifomula yokususa ngamadesimali: Kubha yefomula, thayipha ifomula usebenzisa u-opharetha "-" ukuze ukhiphe amaseli. Isibonelo, uma ubufuna ukususa u-2.5 kuseli A1, ubungathayipha =A1-2.5.
  4. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.
Okuqukethwe okukhethekile - Chofoza Lapha  Ungakucela kanjani ukufinyelela ku-Google Bhizinisi Lami

8. Ngingakwazi yini ukususa amaseli ku-Google AmaSpredishithi ngisebenzisa izinqamuleli zekhibhodi?

  1. Vula i-Google Sheets: Vula isiphequluli sakho sewebhu futhi ufinyelele i-Google AmaSpredishithi.
  2. Khetha amaseli ofuna ukuwakhipha: Chofoza iseli lapho ofuna ukubona khona umphumela wokukhipha, bese ukhetha amaseli ofuna ukuwakhipha.
  3. Cindezela uphawu olulinganayo (=): Lesi isinqamuleli sokuqala ukubhala ifomula ku-Google AmaSpredishithi.
  4. Bhala ifomula yokususa: Ubhala =KHIPHA(iseli1, iseli2), lapho okuthi "cell1" kanye "cell2" kungamaseli ofuna ukuwakhipha. Isibonelo, uma ubufuna ukususa iseli A1 kuseli B1, ubungathayipha =KHIPHA(A1, B1).
  5. Cindezela u-Enter: Uma usuthayiphile ifomula, cindezela u-Enter ukuze ubone umphumela wokukhipha kuseli ekhethiwe.

9. Ungakwazi yini ukusebenzisa ukufometha okunemibandela emiphumeleni yokukhipha ku-Google AmaSpredishithi?

  1. Vula i-Google Sheets: Vula

    Sizobonana maduze, Tecnobits! Khumbula njalo ukususa amaseli ku-Google AmaSpredishithi ukuze ugcine idatha yakho ihlelekile. Sifunda maduze! Uwakhipha kanjani amaseli ku-Google AmaSpredishithi