Uy » Mavzulatshitilgan testlar » Informatika mavzulashtirilgan » 10-sinf Informatika » 10-sinf Informatika №10 10-sinf Informatika 10-sinf Informatika №10 InfoMaster Dekabr 22, 2022 566 Ko'rishlar 1 izoh SaqlashSaqlanganOlib tashlandi 3 2 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. Mexanik mashinalar – bu? A) arifmetik hisoblarni bajaruvchi qurilmalar. B) axborotni qayta ishlash va hisoblashga mo‘ljallangan usul va vositalar majmui. C) mexanik ravishda, qo‘l kuchi yordamida harakatga keltiriladigan mashinalar. D) ishga tushirish va natija olish elektron hamda mexanik ravishda amalga oshiriladigan mashinalar. 2 / 25 2. 4K UHD formatining tasvir proporsiyasini toping. A) 16:09 B) 4:03 C) 14:09 D) 20:09 3 / 25 3. HDD qanday qurilma? A) Portativ qattiq disk B) USB flash xotira C) Mustahkam disk D) Qattiq disk 4 / 25 4. – arifmetik va mantiqiy amallarni bajaruvchi, xotira qurilmasi bilan bog‘lanuvchi, qurilmalar ishini boshqaruvchi qurilma. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) Protsessor B) Tezkor xotira C) Ta’minot bloki D) Tizimli plata 5 / 25 5. Smartfonlarda quyidagi dasturiy ta’minotlardan qaysilari o‘rnatiladi? A) iOS, Android, plam OS 5, Word B) iOS, Wondows phone, Android, Lunix, Excel C) Word, Wondows phone, Android D) iOS, Wondows phone, Android 6 / 25 6. Dasturiy ta’minot-bu? A) – kompyuter ishlashi va uni boshqarish uchun mo‘ljallangan dasturlar majmui. B) – kompyuterda bajarilishi nazarda tutilgan barcha dasturiy mahsulotlar to‘plami. C) – kompyuter ishga tushishi bilan uning xotirasiga yuklanadigan eng birinchi va asosiy dasturiy mahsulot. D) – amaliy vazifalarni yechish uchun mo‘ljallanagan dasturlar majmui. 7 / 25 7. Har xil tur va formatdagi multimediyani uzluksiz ijro etish uchun Windowsning x86 va x64 versiyalarida o‘rnatilgan kodeklar to‘plami. Ta’rif berilgan javobni toping. A) K-Lite Codec Pack B) Media Player Codec Pack 8 / 25 8. MS-DOS operatsion tizimida foydalaniladigan jadval protsessori nomini toping. A) MS Excel B) “Lotus 1-2-3” C) “Multiplan” D) Visual Basic 9 / 25 9. UNIX –? A) grafik interfeysga ega operatsion tizim B) ko‘p masalali va ko‘p foydalanuvchili operatsion tizim C) bir masalali operatsion tizim 10 / 25 10. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) E6+$D$4 B) F6+D$4 C) E6+H$4 D) E6+H8 11 / 25 11. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) D17+G12 B) B10+E18 C) C10+G11 D) E15+H11 12 / 25 12. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 4 B) 12 C) 10 D) 6 13 / 25 13. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Satr B) Katak C) Ustun 14 / 25 14. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A12+I$16 B) E12+I$16 C) $A12+$E25 D) $A$3+I$16 15 / 25 15. 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 16 / 25 16. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C$11+$I$6 B) $C13+$J$6 C) $C12+$I7 D) $C12+$I$6 17 / 25 17. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Satr B) Ustun C) Katak 18 / 25 18. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 26 B) 18 C) 20 D) 24 19 / 25 19. 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) aralash murojaat C) nisbiy murojaat 20 / 25 20. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) G9-E9 B) H9-E9 C) H9-I9 D) F9-E9 21 / 25 21. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 6 B) 10 C) 14 D) 12 22 / 25 22. MS Excel dasturida A2;B6 diapazonda nechta katakcha bor? A) 4 B) 2 C) 10 D) 12 23 / 25 23. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) F12+H6 B) H12+H6 C) F12+I6 D) C5+G13 24 / 25 24. MS Excel 2019 dasturida satrlar soni nechta A) 18,576 B) 15,576 C) 16,384 D) 1 048 576 25 / 25 25. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarsa, bunday murojaatga ….deyiladi. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) aralash murojaat B) nisbiy murojaat C) absolyut murojaat 0% Author: InfoMaster Foydali bo'lsa mamnunmiz
