Mazkur uslubiy qo’llanmada Microsoft Office amaliy dasturi tarkibiga kiruvchi excel elektron jadvali imkoniyatlari, unda ishlashning zaruriy ma’lumotlari keltirilgan

AMALIY MAShGULOT 2


Natijaviy funkstiyalarni qo’llash

1. 
   EXCEL dasturini ishga tushiring(Pusk –programmo’-Microsoft excel) va oldin yaratilgan kitob.xls ishchi kitobni ekranga chaqiring.
   
2. 
   Malumotlar ishchi varagini faollashtiring.
   
3. 
   A ustundagi birinchi bush katakni faollashtiring, bizning misolda A1:A10 kataklar sonlar bilan tulik, demak A11 katakni faollashtirish kerak.
   
4. 
   Standart uskunalar panelidan Avtosumma tugmasida chap tugmani cherting.
   
5. 
   EXCEL A11 katagiga SUMM funkstiyasini kuyib, A1:A10 kataklar kiymatlari yigindisini xisoblaganini tekshiring. ENTER tugmasini bosing.
   
6. 
   A ustunda keyingi bush katakni faollashtiring, bizning misolda bu A12 katak.
   
7. 
   Standart uskunalar panelidan Vstavka funkstii tugmasini cherting.
   
8. 
   Kategorii ruyxatidan Statisticheskie punktini tanlang.
   
9. 
   Funkstii ruyxatidan SRZNACh funkstiyasini tanlang va Ok tugmasini cherting.
   
10. 
    SRZNACh funkstiyasi argumentida kerakli kataklar majmuasi turganiga etibor kiling. Majmuada summa turgan katak xam kirgan bulishi mumkin. Sudrash usuli bilan kerakli, yani A1:A10 kataklar majmuasini ajrating va ENTER tugmasini bosing.
    
11. 
    Yukoridagi 6-10 punktlardagi xarakatlardan foydalanib, A13 katakda A1:A10 kataklardagi eng kichik sonni(MIN), A14 katakda eng katta sonni(MAX), majmuadagi kataklar sonini(SChET) xisoblang.
    
12. 
    Ekrandagi faylni xotirada saklang.
    

AMALIY MASHG’ULOT 3

Prays-varaqni tayorlash va formatlash

1.Excel dasturini ishga tushiring va book.xls ishchi kitobini oching.
2. Chertish yuli bilan ishlatilmagan ishchi varagini oching eki Vstavka-list buyrug’idan foydalaning. Yangi varak erligida ikki marta cherting va unga preyskurant deb nom bering.
3. A1 katakda preyskurant suzini kiriting.
4. A2 katagiga Dollar kursi suzini kiriting, V2 katagiga 1 dollar q matnini, S2 katagiga esa xozirgi dollar kursi ni kiriting.
5. A3 katakka Tovar nomi, V3 katakka narxi(dollarda) suzi, S3 kataakda "Narxi(sumda)" matnlarini kiriting.
6. A ustunning keyingi kataklarida preykurantga kirishi mumkin bulgan tovarlar nomini kiriting.
7. V ustunning mos kataklarida tovarlarning dollardagi narxlarini ezib chiking.
8. S4 katagida kuyidagi formulani kiriting: =B4*$C$2. Ushbu formula orkali tovarning sumlardagi narxini kiriting .
9. Avtotuldirish usuli bilan A va V ustunlar tuldirilgan kataklariga mos S ustun kataklariga S4 katakdan nusxa oling. Bunda chikkan narxlar tugri ekaniga etibor kiling.
10. S2 katagidagi Dollar kursini uzgartiring. Bunda S ustun kataklaridagi sumlar kiymatini uzgarganiga etibor kiling.
11. Sudrash usuli bilan A1:S1 kataklarini ajrating va Format yacheyki buyrug’ini bering. Vыravnivanie bulimidan gorizontal buyicha po stentru punktini oling va Obedinenie yacheyki bulimida bayrokcha urnating.
12. Shrift punktida 14 ulchovini urnating va Nachertanie punktidan polujirno’y variantini tanlang. Ok tugmasini cherting.
13. V2 katagini ajrating va ung tugmani cherting. Kontekst menyudan format yacheyki buyrug’ini tanlang. Gorizontal buyicha Po pravomu krayu variantini olib Ok tugmasini cherting.
14. S2 katagini ajratib, ung tugma orkali kontekst menyuni chakiring va Format yacheyki buyrug’ini tanlang. Gorizontal buyicha Po levomu krayu variantini olib Ok tugmasini cherting.