Uy » Mavzulatshitilgan testlar » Informatika mavzulashtirilgan » 10-sinf Informatika » 10-sinf Informatika №10 10-sinf Informatika 10-sinf Informatika №10 InfoMaster Dekabr 22, 2022 349 Ko'rishlar 1 izoh SaqlashSaqlanganOlib tashlandi 3 36 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. Birinchi mexanik mashinani kim yaratgan? A) Jon Uilyam Mokli va Jon Prosper Ekkert B) Vilgelm Shikkard C) Blez Paskal D) Ada Lavleys Bebbij 2 / 25 2. 4K UHD formatining tasvir proporsiyasini toping. A) 16:09 B) 4:03 C) 20:09 D) 14:09 3 / 25 3. HDD qisqartma so’zini kengaytmasini toping. A) Hard Disk Drive B) Happy Disk Drive C) Hard Disk Drier D) Hard Disk Draw 4 / 25 4. Quyidagi rasmda qurilma nomini toping. A) HDD – axborotni saqlash qurilmasi B) CPU – markaziy protsessor C) Ovoz kartasi D) Videokarta 5 / 25 5. GPS-BU? A) dunyo vaqti hamda turgan o‘rinni aniqlashni ta’minlovchi harakatdagi sputnik tizimi. B) biror narsaning turgan joyini aniqlash. C) Kompyuter xotirasidan ma’lumonlarni izlash D) Kompyuter xotirasidagi faylni turgan joti 6 / 25 6. Operatsion tizim-bu? A) – kompyuter ishlashi va uni boshqarish uchun mo‘ljallangan dasturlar majmui. B) – amaliy vazifalarni yechish uchun mo‘ljallanagan dasturlar majmui. C) – kompyuter ishga tushishi bilan uning xotirasiga yuklanadigan eng birinchi va asosiy dasturiy mahsulot. D) – kompyuterda bajarilishi nazarda tutilgan barcha dasturiy mahsulotlar to‘plami. 7 / 25 7. Audiofayllar formatlarini o‘zgartirish imkonini beruvchi dasturlar nima deb nomlanadi? A) Audiokonvertor B) Vediokonvertor 8 / 25 8. Mac operatsion tizimi uchun Excelning birinchi ko‘rinishi qachon ishlab chiqarilgan? A) 1987-yil B) 1985-yil C) 1993-yil D) 1982-yil 9 / 25 9. MS DOS tizimi…. A) bir masalali operatsion tizim B) grafik interfeysga ega operatsion tizim C) ko‘p masalali va ko‘p foydalanuvchili operatsion tizim 10 / 25 10. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) $B6+J$5 B) $B6+J9 C) F$2+J$5 D) F$2+J9 11 / 25 11. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarmasa , bunday murojaatga ….deyiladi. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) aralash murojaat B) absolyut murojaat C) nisbiy murojaat 12 / 25 12. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 10 B) 12 C) 6 D) 4 13 / 25 13. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A12+I$16 B) $A$3+I$16 C) E12+I$16 D) $A12+$E25 14 / 25 14. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Ustun B) Satr C) Katak 15 / 25 15. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) H9-E9 B) H9-I9 C) G9-E9 D) F9-E9 16 / 25 16. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) D6+C9 B) C6+C9 C) C6+D9 D) B6+B9 17 / 25 17. MS Excel dasturida A2;B6 diapazonda nechta katakcha bor? A) 12 B) 2 C) 10 D) 4 18 / 25 18. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) H12+H6 B) F12+H6 C) F12+I6 D) C5+G13 19 / 25 19. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 12 B) 14 C) 6 D) 10 20 / 25 20. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 26 B) 18 C) 24 D) 20 21 / 25 21. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C12+$I$6 B) $C13+$J$6 C) $C$11+$I$6 D) $C12+$I7 22 / 25 22. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Satr B) Katak C) Ustun 23 / 25 23. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarsa, bunday murojaatga ….deyiladi. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) absolyut murojaat B) nisbiy murojaat C) aralash murojaat 24 / 25 24. MS Excel 2019 dasturida satrlar soni nechta A) 16,384 B) 15,576 C) 1 048 576 D) 18,576 25 / 25 25. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) C10+G11 B) B10+E18 C) D17+G12 D) E15+H11 0% Author: InfoMaster Foydali bo'lsa mamnunmiz