Idan kana neman hanya mai sauƙi da sauri don ƙididdige ma'auni a cikin Excel, kun zo wurin da ya dace. A cikin wannan labarin, za mu nuna muku yadda ake yin Media Media a Excel ta hanya mai sauki da inganci. Ko kuna buƙatar ƙididdige matsakaicin lissafin lambobi ko kewayon kewayon kewayon ku, za mu jagorance ku mataki-mataki don ku iya ƙware wannan kayan aiki mai amfani. Ko kun kasance sababbi ga Excel ko kun riga kun ƙware, wannan jagorar zai taimaka muku yin lissafin cikin sauri da daidai.
- Mataki ta mataki ➡️ Yadda ake yin media a cikin Excel
Yadda ake yin Media a cikin Excel
- Bude Microsoft Excel a kan kwamfutarka.
- Zaɓi tantanin halitta inda kake son matsakaicin sakamako ya bayyana.
- Rubuta dabarar "= AVERAGE(" sai kuma sel da kuke son matsakaita. Misali, "= AVERAGE(A1:A10)" zai zama matsakaicin sel daga A1 zuwa A10.
- Danna Shigar don samun matsakaicin sel da aka zaɓa.
- Duba sakamakon kuma a tabbata daidai ne.
- ajiye fayil ɗin ku don kada a rasa sauye-sauyen da aka yi.
Tambaya&A
Yadda za a ƙirƙiri matsakaicin tsari a cikin Excel?
- Fara Excel kuma buɗe fayil ɗin da kake son aiki akai.
- Zaɓi tantanin halitta inda kake son matsakaicin sakamako ya bayyana.
- Rubuta =MAGASKIYA(
- Zaɓi kewayon sel da kuke son matsakaita.
- Rufe baka kuma latsa Shigar.
Yadda za a lissafta matsakaicin nauyi a cikin Excel?
- Bude fayil ɗin Excel ɗin ku kuma zaɓi tantanin halitta inda kuke son matsakaicin sakamako ya bayyana.
- Ya rubuta = KYAUTA (
- Zaɓi kewayon ƙimar da za ku sanya nauyin nauyi.
- Danna Shigar don samun sakamako.
Yadda ake amfani da aikin MEDIAN a cikin Excel?
- Bude maƙunsar ku a cikin Excel.
- Zaɓi tantanin halitta inda kake son sakamakon tsakiya ya bayyana.
- Rubuta =MADIYA(
- Zaɓi kewayon sel daga waɗanda kuke son samun matsakaicin.
- Danna Shigar don samun sakamako.
Yadda ake yin matsakaicin motsi a cikin Excel?
- Bude fayil ɗin Excel ɗin ku kuma zaɓi tantanin halitta inda kuke son matsakaicin sakamako mai motsi ya bayyana.
- Rubuta = MATSALAR MOTSA(
- Zaɓi kewayon bayanai wanda kake son ƙididdige matsakaicin motsi.
- Ƙayyade adadin lokutan da kuke son haɗawa a cikin lissafin.
- Danna Shigar don samun sakamako.
Yadda ake amfani da aikin FASHION a cikin Excel?
- Bude maƙunsar ku a cikin Excel.
- Zaɓi cell ɗin inda kake son fitowar sakamakon salon.
- Rubuta =MODE.MULT(
- Zaɓi kewayon sel daga waɗanda kuke son samun yanayin.
- Danna Shigar don samun sakamakon.
Yadda za a lissafta kewayon a cikin Excel?
- Bude maƙunsar ku a cikin Excel.
- Zaɓi tantanin halitta inda kake son sakamakon kewayon ya bayyana.
- Rubuta = MAX (
- Zaɓi kewayon sel da kuke son samun kewayon daga.
- Cire sakamakon aikin MAX daga sakamakon aikin MIN don samun kewayon.
Yadda ake yin matsakaici a cikin Excel tare da yanayi?
- Bude fayil ɗin Excel ɗin ku kuma zaɓi tantanin halitta inda kuke son matsakaicin sakamako ya bayyana.
- Rubuta = MATSAYI.IF(
- Zaɓi kewayon sel waɗanda za a tantance ta ma'auni.
- Rubuta ma'auni a cikin ƙididdiga biyu.
- Zaɓi kewayon sel waɗanda kuke so ku lissafta matsakaici akan su.
Yadda ake samun ma'anar lissafi a cikin Excel?
- Bude maƙunsar ku a cikin Excel.
- Zaɓi tantanin halitta inda kake so sakamakon lissafin ma'anar ya bayyana.
- Rubuta =MAGASKIYA(
- Zaɓi kewayon sel waɗanda kuke son samun ma'anar lissafi.
- Danna Shigar don samun sakamako.
Yadda ake yin matsakaita tare da kashi a cikin Excel?
- Bude maƙunsar ku a cikin Excel.
- Zaɓi tantanin halitta inda kake son matsakaicin sakamakon kashi ya bayyana.
- Rubuta =MAGASKIYA(
- Zaɓi kewayon sel waɗanda ke ɗauke da kaso.
- Latsa Shigar don samun sakamakon matsakaicin kashi.
Yadda za a lissafta ma'anar geometric a cikin Excel?
- Bude fayil ɗin Excel ɗin ku.
- Zaɓi tantanin halitta inda kake son sakamakon ma'anar geometric ya bayyana.
- Rubuta = GEOMETRICAVERAGE(
- Zaɓi kewayon sel waɗanda kuke son samun ma'anar lissafi.
- Danna Shigar don samun sakamako.
Ni Sebastián Vidal, injiniyan kwamfuta mai sha'awar fasaha da DIY. Bugu da ƙari, ni ne mahaliccin tecnobits.com, inda nake raba koyaswar don sa fasaha ta fi dacewa da fahimtar kowa ga kowa.