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

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.