Yadda ake amfani da dabarun Excel

Sabuntawa ta ƙarshe: 06/01/2024
Marubuci: Sebastian Vidal

Yadda ake amfani da tsarin Excel Yana da mahimmancin fasaha ga kowane ƙwararrun da ke aiki tare da bayanai ko da yake Excel kayan aiki ne da aka yi amfani da su sosai, mutane da yawa ba sa amfani da damar da za su iya amfani da su a cikin wannan labarin, za mu shiryar da ku ta hanyar asali ayyuka zuwa mafi ci gaba ayyuka. Ta wannan hanyar za ku iya hanzarta aikinku kuma ku inganta daidaiton lissafin ku. Ba kome ba idan kun kasance sababbi ga Excel ko kun riga kun goga, akwai koyaushe sabon abu don koyo!

- ⁢ Mataki ta mataki ➡️ Yadda ake amfani da dabarun Excel

  • Bude Microsoft Excel a kan kwamfutarka.
  • Zaɓi cell inda kake so yi amfani da dabarar.
  • Rubuta alamar daidai (=) a cikin tantanin halitta da aka zaɓa.
  • Rubuta dabarar lissafi wanda kake son amfani dashi, kamar: =JIMAR(A1:A10) don ƙara kewayon sel.
  • Danna Shigar don ganin sakamakon dabara.
  • Domin gyara dabarar, danna sau biyu akan tantanin halitta tare da dabara.
Keɓaɓɓen abun ciki - Danna nan  Yadda ake canja wurin fayiloli akan rumbun kwamfutarka na waje

Tambaya da Amsa

Wadanne nau'ikan tsari ne na yau da kullun a cikin Excel?

  1. Ƙari: =JIMAR(A1:A10)
  2. Ragewa: = A1-B1
  3. Yawa: =A1*B1
  4. Rarraba: = A1/B1
  5. Matsakaici: ⁢ =MATAKA'I(A1:A10)

Yadda ake amfani da dabaru masu sauƙi a cikin Excel?

  1. Zaɓi tantanin halitta inda kake son sakamakon ya bayyana.
  2. Rubuta alamar daidaitawa (=) don fara dabara.
  3. Rubuta dabarar da ake so, misali: =A1+A2.
  4. Danna Shigar don samun sakamako.

Yadda za a yi amfani da ma'auni a cikin Excel?

  1. Zaɓi tantanin halitta inda kake son sakamakon ya bayyana.
  2. Rubuta alamar daidai (=) don fara tsarin.
  3. Rubuta dabara ta farko, sannan mai aiki (+, -, *, /), sannan sai dabara ta biyu. Misali: =A1+B1.
  4. Danna Shigar don samun sakamakon.

Yadda ake amfani da dabarun bincike a cikin Excel?

  1. Yi amfani da aikin VLOOKUP don duba ƙima a cikin ginshiƙin farko na tebur kuma dawo da ƙima a jere ɗaya a wani shafi.
  2. Rubuta dabarar tare da dalilai masu mahimmanci, misali: = VLOOKUP (A2, A1: B10, 2, KARYA).
  3. Danna Shigar domin samun sakamakon.
Keɓaɓɓen abun ciki - Danna nan  Yadda ake buɗe fayil ɗin PHOTOSLIBRARY

Yadda za a duba wani cell a cikin tsarin Excel?

  1. Rubuta alamar daidai (=) a cikin tantanin halitta inda kake son sakamakon ya bayyana.
  2. Rubuta dabarar kuma yi amfani da bayanin tantanin halitta da ake so. Misali: =A1+B1.
  3. Danna Shigar don samun sakamako.

Yadda ake amfani da tsarin kwanan wata a cikin Excel?

  1. Yi amfani da aikin DATE don shigar da takamaiman kwanan wata a cikin tantanin halitta.
  2. Rubuta dabarar ⁤ tare da shekara, wata da rana da ake so, misali: = RANAR (2022, 12, 31).
  3. Danna Shigar don samun sakamakon kwanan watan.

Yadda ake amfani da aikin IF a cikin Excel?

  1. Rubuta dabarar tare da tsari: =IF (sharadi, darajar_if_gaskiya, ⁢ darajar_if_ƙarya).
  2. Yana nuna yanayin da yakamata a kimanta da ƙimar da yakamata a nuna idan gaskiya ne ko ƙarya.
  3. Danna Shigar domin samun sakamakon.

Yadda ake amfani da dabara tare da kaso⁤ a cikin Excel?

  1. Yi amfani da dabara don ƙididdige kashi, misali: =A1*10%.
  2. Idan kana buƙatar ƙara ko rage kashi, yi amfani da dabarar da ake so tare da nuni ga tantanin halitta mai ɗauke da kashi, misali: = A1+A1*10%.
Keɓaɓɓen abun ciki - Danna nan  Ta yaya zan iya duba takardar shaidar haihuwata?

Yadda ake amfani da ayyukan lissafi a cikin Excel?

  1. Yi amfani da ADD, SUBTRACT, ⁢MULTIPLICATION⁤ da ayyukan DIVISION don aiwatar da ainihin lissafin lissafi.
  2. Rubuta dabarar tare da lambobi da ake so ko bayanan tantanin halitta, misali: =JIMAR(A1:A10).
  3. Danna Shigar don samun sakamakon.

Yadda za a ajiye daftarin aiki na al'ada a cikin Excel?

  1. Zaɓi tantanin halitta tare da dabarar al'ada.
  2. Kwafi tantanin halitta tare da dabarar al'ada: Ctrl + C.
  3. Manna dabarar cikin wasu sel inda kake son amfani da ita: Ctrl+V .