Uy » Mavzulatshitilgan testlar » Informatika mavzulashtirilgan » 10-sinf Informatika » 10-sinf Informatika №10 10-sinf Informatika 10-sinf Informatika №10 InfoMaster Dekabr 22, 2022 536 Ko'rishlar 1 izoh SaqlashSaqlanganOlib tashlandi 3 0 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. “Apple Computer” firmasining birinchi shaxsiy kompyuteri qachon yaratilgan? A) 1977-yilda B) 1971-yilda C) 1973-yilda D) 1976-yilda 2 / 25 2. A2 qog‘oz formatining o‘lchami (mm) qanday? A) 420×594 B) 594×841 C) 297×420 D) 148×210 3 / 25 3. Xotira kartasining (Memory Card) vazifasi qaysi javobda to’g’ri berilgan? A) kompyuter korpusidan tashqarida axborotni saqlash qurilmasi. B) O‘lchamlari kichik bo‘lgani uchun, xotira kartalari ko‘pincha smartfon, planshet, kamera kabi ko‘chma qurilmalarda qo‘shimcha axborotni saqlash vositasi sifatida ishlatiladi. C) Ushbu axborotni saqlash qurilmasi USB porti orqali ulanadi va qurilmalar orasida axborotlarni tezkor almashishini ta’minlaydi. D) ma’lumotlarni saqlash uchun maxsus registrlardan foydalaniladigan qurilma. 4 / 25 4. Quyidagi rasmda qurilma nomini toping. A) Kuller (sovitkich) B) Tizim bloki C) Ta’minot bloki D) Tezkor xotira 5 / 25 5. – cho‘ntak kompyuteri hamda mobil telefon vazifalarini umumlashtiruvchi qurilma. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) Notebook B) Monoblok C) Smartfon D) Kompyuter 6 / 25 6. Inglizchada “Operatsion system” so’zning ma’nosini toping. A) Operatsion tizim B) Tizimli dasturiy ta’minot C) Dasturiy ta’minot D) Amaliy dasturiy ta’minot 7 / 25 7. Audiofayllar formatlarini o‘zgartirish imkonini beruvchi dasturlar nima deb nomlanadi? A) Vediokonvertor B) Audiokonvertor 8 / 25 8. Microsoft Excel dasturida yaratilgan fayllar qanday kengaytmasiga ega? A) .xlsx B) .mp4 C) .docx D) .mp3 9 / 25 9. Windows OT uchun fayl tizimi ko’rsating. A) ISO-9660, UDF B) FAT32, NTFS C) ext3, ReiserFS 10 / 25 10. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 20 B) 24 C) 18 D) 26 11 / 25 11. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C12+$I$6 B) $C12+$I7 C) $C$11+$I$6 D) $C13+$J$6 12 / 25 12. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 12 B) 6 C) 10 D) 4 13 / 25 13. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) F12+H6 B) C5+G13 C) F12+I6 D) H12+H6 14 / 25 14. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A$3+I$16 B) E12+I$16 C) $A12+I$16 D) $A12+$E25 15 / 25 15. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarsa, bunday murojaatga ….deyiladi. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) nisbiy murojaat B) absolyut murojaat C) aralash murojaat 16 / 25 16. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 10 B) 12 C) 6 D) 14 17 / 25 17. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) F6+D$4 B) E6+H$4 C) E6+$D$4 D) E6+H8 18 / 25 18. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Ustun B) Katak C) Satr 19 / 25 19. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) B6+B9 B) C6+C9 C) D6+C9 D) C6+D9 20 / 25 20. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) E15+H11 B) D17+G12 C) C10+G11 D) B10+E18 21 / 25 21. MS Excel 2019 dasturida satrlar soni nechta A) 16,384 B) 1 048 576 C) 18,576 D) 15,576 22 / 25 22. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) H9-E9 B) G9-E9 C) H9-I9 D) F9-E9 23 / 25 23. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarmasa , 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 dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) F$2+J$5 B) $B6+J9 C) F$2+J9 D) $B6+J$5 25 / 25 25. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Satr B) Ustun C) Katak 0% Author: InfoMaster Foydali bo'lsa mamnunmiz
