Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS...
Transcript of Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS...
![Page 1: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/1.jpg)
Mesimi - 6
![Page 2: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/2.jpg)
Çfare eshte MS Excel? Microsoft Excel eshte
program i paketes Office.
MS Excel perdoret per:
Organizimin e te dhenave ne rreshta dhe kollona
Perllogaritjen e te dhenave
Formimin e grafikeve etj..
![Page 3: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/3.jpg)
Hapja e Programit Excel Rruga standarte per te
hapur MS Excel 2010 eshte: Klikojme ne Butonin
Start
Ne menune Start zgjedhim All Programs
Nga lista e programeve te instaluar zgjedhim Microsoft Office
Me pas zgjedhim Microsoft Excel 2010
![Page 4: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/4.jpg)
Komponentet kryesore te MS Excel Komponentet kryesore
te editorit te MS Excel jane:
Title Bar
Ribbon
Quick Access Toolbar
Formula Bar
Worksheet
Workbook
![Page 5: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/5.jpg)
Title Bar – Shiriti i Emrit Tregon emrin e skedarit, programit dhe butonat
Minimize, Maximize/Restore dhe Close .
![Page 6: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/6.jpg)
Ribbon Eshte nje shufer qe permban shumicen e komandave te
MS Excel te organizuara ne grupe te ndryshme.
Ribbon shfaq komandat e Tab-it (skedes) te zgjedhur. Ne rastin e meposhtem kemi komandat e Tab-it Home.
![Page 7: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/7.jpg)
Quick Access Toolbar Eshte nje shufer qe permban komandat me te
perdorura, te cilat mund te aksesohen (perdoren) shume shpejt.
![Page 8: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/8.jpg)
Formula Bar Eshte nje shufer qe perbehet nga tre pjese:
1-) Name Box
2-) Insert Function
3-) Formula Bar
![Page 9: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/9.jpg)
Name Box Tregon adresen e
qelizes aktive.
Qeliza aktive eshte qeliza e zgjedhur.
![Page 10: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/10.jpg)
Insert Function Sherben per te
futur automatikisht funksionet qe ka MS Excel-i.
![Page 11: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/11.jpg)
Formula Bar Sherben per te shkruajtur formulat brenda qelizave,
ose per te pare formulat qe jane ne qelizen aktive.
![Page 12: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/12.jpg)
Formula Bar Ne rastin kur qeliza aktive permban formule vete
qeliza tregon rezultatin e formules nderkohe qe ne Formula Bar shfaqet formula qe jep kete rezultat.
![Page 13: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/13.jpg)
Formula Bar Ne rastinkur qeliza aktive permban tekst qeliza dhe
formula bar shfaqin te njetin informacion.
![Page 14: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/14.jpg)
Worksheet Quajme nje
faqe te nje skedari te pregatitur nga MS Excel.
![Page 15: Hyrje ne MS Excel 2010 - · PDF fileHapja e Programit Excel Rruga standarte per te hapur MS Excel 2010 eshte: Klikojme ne Butonin Start Ne menune Start zgjedhim All Programs](https://reader031.fdocument.pub/reader031/viewer/2022021418/5a88f9467f8b9a001c8ed05e/html5/thumbnails/15.jpg)
Workbook Quajme nje
skedar te pregatitur nga MS Excel.