Yadda ake amfani da Excel don bincika bayanai? Tambaya ce gama gari da muke yi wa kanmu lokacin da muke buƙatar amfani da wannan kayan aikin Microsoft mai ƙarfi don yin nazarin bayanai. Excel shiri ne mai amfani da yawa wanda ke ba mu damar tsarawa, ƙididdigewa da hangen nesa yadda ya kamata. A cikin wannan labarin, zamu bincika wasu mahimman ayyuka da fasalulluka na Excel waɗanda zasu taimaka muku bincika bayananku cikin sauƙi da inganci. Gano yadda ake samun mafi kyawun wannan kayan aikin kuma ku sami bayanai masu mahimmanci daga saitin bayananku.

Mataki-mataki ➡️ Yadda ake amfani da Excel don tantance bayanai?

• Hanyar 1: Bude Excel a kan kwamfutarka
• Hanyar 2: Ƙirƙiri sabon maƙunsar rubutu ta danna "Fayil" sannan "Sabo"
• Hanyar 3: Sake sunan maƙunsar bayanai don gano saitin bayanan da za ku tantance
• Hanyar 4: Shigar da bayanan cikin maƙunsar bayanai, tabbatar da cewa kowane shafi yana wakiltar rukuni kuma kowane jere yana wakiltar shigarwar bayanai
• Hanyar 5: Yi amfani da dabarar Excel don yin lissafi akan bayanai. Kuna iya ƙara, raguwa, ninka ko raba sel don samun sakamako
• Hanyar 6: Yana amfani da tacewa zuwa bayanan don tantance takamaiman yanki na saitin bayanai kawai. Kuna iya tace ta ƙima, rubutu ko kwanan wata
• Hanyar 7: Yi amfani da zane-zane don ganin bayanan ku. Kuna iya ƙirƙirar ginshiƙi na mashaya, zane-zane, ko sigogin layi don wakiltar bayanai dalla-dalla.
• Hanyar 8: Yi nazarin ƙididdiga ta amfani da ginanniyar ayyukan Excel. Kuna iya ƙididdige ma'ana, daidaitaccen karkata ko matsakaicin ƙimar ƙima na bayananku
• Hanyar 9: Ajiye naka Fayil na Excel don samun damar shiga a nan gaba. Danna "File" sannan "Ajiye"

Tambaya&A

Yadda ake amfani da Excel don bincika bayanai?

1. Yadda ake bude Excel akan kwamfuta ta?

1. Nemo gunkin Excel a kan tebur ko a cikin menu na farawa.

2. Danna alamar Excel sau biyu.

2. Yadda ake ƙirƙirar sabon maƙunsar rubutu?

1. Bude Excel akan kwamfutarka.

2. Danna kan 'File' tab a saman hagu na allo.

3. Zaɓi 'Sabo' daga menu mai saukewa.

4. Danna 'Blank Spreadsheet'.

3. Yadda ake shigar da bayanai a cikin maƙunsar bayanai na Excel?

1. Danna tantanin halitta inda kake son shigar da bayanai.

2. Buga bayanan cikin ma'aunin dabarar da ke saman allon.

3. Danna 'Enter' a kan madannai don tabbatar da bayanan da aka shigar.

4. Yadda ake yin lissafin asali a cikin Excel?

1. Zaɓi tantanin halitta inda kake son sakamakon lissafin ya bayyana.

2. Rubuta alamar daidai (=) a cikin mashaya dabara.

3. Shigar da dabara don lissafin da ake so (misali, "= A1 + B1" don ƙara dabi'u a cikin sel A1 da B1).

4. Danna 'Enter' akan madannai don samun sakamakon lissafin.

5. Yadda ake tsara bayanai a cikin Excel?

1. Zaɓi sel ɗin da kuke son tsarawa.

2. Danna-dama akan sel da aka zaɓa kuma zaɓi 'Format Cells' daga menu mai saukewa.

3. Zaɓi shafin 'Lambar' a cikin akwatin maganganu 'Format Cells'.

4. Zabi tsarin da ake so (misali lamba, kwanan wata, kaso, da sauransu) kuma danna 'Ok'.

6. Yadda ake warware bayanai a cikin Excel?

1. Zaɓi kewayon tantanin halitta abin da kuke son oda.

2. Danna 'Data' tab a saman allon.

3. Zaɓi 'Na'a' a cikin rukunin 'Sir & Filter'.

4. Ƙayyade ginshiƙan da kake son rarraba bayanai da shi kuma zaɓi nau'in tsari ( hawan ko saukowa).

5. Danna 'Ok' don warware bayanan gwargwadon abubuwan da kuke so.

7. Yadda ake tace bayanai a cikin Excel?

1. Zaɓi kewayon sel da kuke son tacewa.

2. Danna 'Data' tab a saman allon.

3. Zaba 'Filter' a cikin rukunin 'Sort and Filter'.

4. Danna kibiya a cikin taken shafi ta inda kake son tace bayanai kuma zaɓi ma'aunin tacewa.

5. Danna 'Ok' don amfani da tacewa kuma a nuna bayanan kawai wanda ya dace da ka'idodin da aka zaɓa.

8. Yadda ake ƙirƙirar ginshiƙi a cikin Excel?

1. Zaɓi bayanan da kuke son haɗawa a cikin ginshiƙi.

2. Danna shafin 'Insert' a saman allon.

3. Zaɓi nau'in ginshiƙi da kuke son ƙirƙira a sashin 'Charts'.

4. Danna 'Ok' don saka ginshiƙi a cikin maƙunsar rubutu.

9. Yadda ake ajiyewa da buɗe fayilolin Excel?

1. Don ajiye fayil:

   ku. Danna 'File' tab a saman hagu na allon.

   b. Zaɓi 'Ajiye As' daga menu mai saukewa.

   c. Zaɓi wurin da ake so da sunan fayil kuma danna 'Ajiye'.

2. Don buɗe fayil:

   ku. Danna 'File' tab a saman hagu na allon.

   b. Zaɓi 'Buɗe' daga menu mai saukewa.

   c. Kewaya zuwa wurin fayil ɗin kuma danna shi sau biyu don buɗe shi.

10. Yadda ake buga maƙunsar rubutu na Excel?

1. Danna 'File' tab a saman hagu na allon.

2. Zaɓi 'Print' daga menu mai saukewa.

3. Keɓance zaɓukan bugu kamar kewayon shafi da saitin shafi.

4. Danna 'Print' don buga maƙunsar rubutu.