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

Tugma
Vazifasi
F2	Katakni taxrirlash
Ctrl-B	Yarim kalin shrift urnatish
Ctrl-I	Kursiv shrift urnatish
Ctrl-U	Tagiga chizib yozish rejimini urnatish
Ctrl-L	Chap tomondan tekislash rejimini urnatish
Ctrl-R	Ung tomondan tekislash rejimini urnatish
Ctrl-E	Markazlash rejimini urnatish
Ctrl-J	Xam chap, xam ung tomondan tekislash rejimi
Ctrl-Z	Oldingi xarakatni bekor kilish
Ctrl-Y	Oldingi xarakatni kaytarish
Ctrl-X	Ajratilgan kismni bufer(chuntakka) olish
Ctrl-C	Ajratilgan kismni bufer(chuntakka) nusxalash
Ctrl-V	Buferdagi kismni kursor turgan joyga kuyish
Ctrl-A	Butun tekstni ajratish
Ctrl-F	Kerakli kismni kidirish
Ctrl-H	Kerakli kismni almashtirish
Ctrl-G	Tekstning kerakli kismiga utish
Ctrl-N	Yangi oyna ochish
Ctrl-O	Xotiradagi faylni ochish
Ctrl-P	Faylni bosmaga chikarish
Ctrl-S	Faylni xotirada saklash
Ctrl-D	Shriftlar oynasini chakirish
Ctr l- Shift - F	Yozuv shriftini tanlash
Ctrl – Shift - P	Yozuv ulchovini almashtirish
Ctrl – shift - D	Ikkilangan tagiga chizish rejmini o’rnatish
Ctrl – Shift - C	Formatni nusxalash
Ctrl – shift - V	Formatni qo’yish
Ctrl – shift – A	Ajratilgan kismdagi xarflarni bosh harflarga o’tkazish
Ctrl – shift - =	Yukori indeksga yozish rejimini o’rnatish
Ctrl - =	Kuyi indeksda yozish rejimini o’rnatish
Ctrl – shift -W	Bo’sh joylarsiz tagiga chizish rejimi
Ctrl - Enter	Bet ajratuvchi belgini qo’yish
Alt – ctrl – K	Satrlar orasidagi masofani 1 intervalga qo’yish
Alt – ctrl – Q	Satrlar orasidagi masofani 1,5 intervalga qo’yish
Alt – ctrl - M	Satrlar orasidagi masofani 2 intervalga qo’uyish
Alt – ctrl – I	Bosmaga tayyorlangan xujjatni saxifaga joylashishini ko’rish(predvaritelnыy prosmotr)

Foydalanilgan adabiyotlar ruyxati

1. 
   “Informatika”. Prof. N.V. Makarova taxriri ostida. Darslik. Moskva. “Finansi i statistika». 1997. -765 b.
   
2. 
   Informatika(praktikum po texnologii rabotы na komp’yutere). Prof. N.V. Makarova taxriri ostida. Ukuv kullanma. Moskva. «Finansы i statistika. 1997.
   
3. 
   Sattorov A. «Informatika asoslari». Kasb-xunar kollejlari uchun darslik. Toshkent. 2002.
   
4. 
   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