Mazkur uslubiy qo’llanmada Microsoft Office amaliy dasturi tarkibiga kiruvchi excel elektron jadvali imkoniyatlari, unda ishlashning zaruriy ma’lumotlari keltirilgan
Yüklə 0,8 Mb.
|
Foydalanilgan adabiyotlar ruyxati “Informatika”. Prof. N.V. Makarova taxriri ostida. Darslik. Moskva. “Finansi i statistika». 1997. -765 b. Informatika(praktikum po texnologii rabotы na komp’yutere). Prof. N.V. Makarova taxriri ostida. Ukuv kullanma. Moskva. «Finansы i statistika. 1997. Sattorov A. «Informatika asoslari». Kasb-xunar kollejlari uchun darslik. Toshkent. 2002. Informatika. (6-11 sinf ukuvchilari uchun darsliklar kompleksi). Moskva. «Finansi i statistika». 1998-99. 5. «Effektivnaya rabota na Excel-97». Moskva-1995g. 6. Spravka Excel-97. 7.Ziyonet.uz ta’lim portali materiallari. M U N D A R I J A ELEKTRON JADVALLAR YARATILISH TARIXI............................................................3 EXCEL DASTURINI ISHGA TUSHIRISH VA TUGATISH TARTIBI..............................3 EXCEL EKRANI KO’RINISHI.............................................................................................4 Ilovalar bo’limining asosiy elementlari.....................................................................................5 Hujjatlar bo’limining asosiy elementlari...................................................................................8 Bir joyda bo’lmagan kataklar guruhini ajratish.........................................................................9 Ishchi kitob varaqlari bilan ishlash............................................................................................9 Jadval kursorini ishchi varaq bo’ylab harakatlantirish............................................................10 KATAKLARGA MA’LUMOTLAR KIRITISh...................................................................10 Matnlarni kiritish.....................................................................................................................11 Sonli malumotlar kiritish........................................................................................................11 Formulalar...............................................................................................................................13 KATAKLARDAGI MALUMOTLAR BILAN IShLASh...................................................13 Katakdagi malumotni o’chirish(yo’kotish).............................................................................13 Katakdagi malumotni tahrirlash.............................................................................................13 Malumotlarni nusxalash va ko’chirish....................................................................................14 Olib(sudrab) o’tish orqali nusxa ko’chirish............................................................................15 Kataklarni avtomatik ravishda to’ldirish................................................................................15 Formulalarni nusxalash. Nisbiy va absolyut o’tkazishlar………………….…….................15 Malumotlar kiritishda chegaralanishlar ko’yish.....................................................................16 Avtomatik ravishda to’ldirish funkstiyasi..............................................................................16 Jadvaldagi barcha formulalarni ekranda bir yo’la ko’rish......................................................16 Kataklardagi boglanishlarni ko’rish........................................................................................17 FUNKSIYaLAR BILAN IShLASh......................................................................................17 Funksiya tushunchasi va uni jadvalda qo’llash.......................................................................17 Funksiyalar ustasi(master funkstiy) bilan ishlash...................................................................18 Ko’p ishlatiladigan funkstiyalar ro’yxati................................................................................18 MALUMOTLARNI FORMATLASh...................................................................................21 Ustun kengligini o’zgartirish...................................................................................................21 Satr balandligini o’zgartirish...................................................................................................21 Kataklardagi malumotlarni tekislash......................................................................................21 Shriftlar, ramkalar, ranglar bilan bezash................................................................................21 Kataklarni yashirish................................................................................................................22 EXCELda klaviatura orqali formatlash tugmalari..................................................................22 RO’YXATLAR BILAN IShLASh.......................................................................................22 Ro’yxat tushunchasi...............................................................................................................22 Ro’yxatni tartiblash................................................................................................................22 Jadvaldagi malumotlarni filtrlash...........................................................................................23 Jadvaldagi biror belgiga ko’ra bir necha yigindini hisoblash.................................................23 Ruyxatni malumotlar formasi yordamida qayta ishlash.........................................................24 DIAGRAMMALAR BILAN IShLASh...............................................................................26 Diagrammalar ustasi(Master diagramm) bilan ishlash...........................................................27 JADVALDAGI MALUMOTLARNI BOSMADAN(PRINTERDAN) ChIQARISh........27 Bosmadan oldin ko’rish.........................................................................................................27 Hujjatlarni bosmalash.............................................................................................................28 AMALIY MAShGULOTLAR.............................................................................................30 TAKRORLASH UCHUN SAVOLLAR.............................................................................32 FOYDALANILGAN ADABIYOTLAR RO’YXATI..………..............…………………36 Yüklə 0,8 Mb. Dostları ilə paylaş:
|