Uy » Mavzulatshitilgan testlar » Informatika mavzulashtirilgan » 10-sinf Informatika » 10-sinf Informatika №10 10-sinf Informatika 10-sinf Informatika №10 InfoMaster Dekabr 22, 2022 602 Ko'rishlar 1 izoh SaqlashSaqlanganOlib tashlandi 3 3 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. Birinchi shaxsiy kompyuter qayerda yaratilgan? A) AQSHda B) Italiyada C) Fransiyada D) Ispaniyada 2 / 25 2. Tashqi qurilmalar (printer, skaner...) aosan qaysi portlarga ulanadi? A) DVI B) USB C) HDMI D) LAN 3 / 25 3. Kompyuterda axborotni saqlashning qanday turlarini bilasiz? A) Axborotni saqlash qurilmalari; B) Xotira komponenti; C) Barcha javoblar to’g’ri D) Tashqi saqlash qurilmalari; 4 / 25 4. Quyidagi rasmda qurilma nomini toping. A) Videokarta B) CPU – markaziy protsessor C) HDD – axborotni saqlash qurilmasi D) Ovoz kartasi 5 / 25 5. Smartfonlarda quyidagi dasturiy ta’minotlardan qaysilari o‘rnatiladi? A) iOS, Android, plam OS 5, Word B) iOS, Wondows phone, Android C) Word, Wondows phone, Android D) iOS, Wondows phone, Android, Lunix, Excel 6 / 25 6. Masalalar boshqaruvini ishga tushirish ketma-ketligi qaysi javobda to’g’ri ko’rsatilgan? A) “Shift + Ctrl + Esc” B) “Alt + Ctrl + Esc” C) “Shift + Ctrl + Enter” D) “Shift + Alt + Esc” 7 / 25 7. Ma’lumotlarni siqish uchun mo‘ljallangan dasturlar qanday nomlanadi? A) Kodek B) Konvertor C) Arxivator D) Barcha javoblar to’g’ri 8 / 25 8. Microsoft Excel dasturida yaratilgan fayllar qanday kengaytmasiga ega? A) .docx B) .xlsx C) .mp4 D) .mp3 9 / 25 9. Mac OS (Makintosh operatsion tizimi) –…? A) grafik interfeysga ega operatsion tizim B) bir masalali operatsion tizim C) ko‘p masalali va ko‘p foydalanuvchili operatsion tizim 10 / 25 10. MS Excel 2019 dasturida satrlar soni nechta A) 15,576 B) 1 048 576 C) 16,384 D) 18,576 11 / 25 11. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) B10+E18 B) E15+H11 C) D17+G12 D) C10+G11 12 / 25 12. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 4 B) 6 C) 10 D) 12 13 / 25 13. MS Excel dasturida A2;B6 diapazonda nechta katakcha bor? A) 12 B) 10 C) 2 D) 4 14 / 25 14. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A12+I$16 B) $A12+$E25 C) $A$3+I$16 D) E12+I$16 15 / 25 15. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) C5+G13 B) H12+H6 C) F12+H6 D) F12+I6 16 / 25 16. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Ustun B) Satr C) Katak 17 / 25 17. 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 18 / 25 18. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C$11+$I$6 B) $C12+$I$6 C) $C13+$J$6 D) $C12+$I7 19 / 25 19. 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) aralash murojaat C) absolyut murojaat 20 / 25 20. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) F$2+J$5 B) $B6+J$5 C) $B6+J9 D) F$2+J9 21 / 25 21. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) C6+D9 B) B6+B9 C) C6+C9 D) D6+C9 22 / 25 22. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 14 B) 10 C) 12 D) 6 23 / 25 23. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Satr B) Ustun C) Katak 24 / 25 24. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) F9-E9 B) H9-E9 C) H9-I9 D) G9-E9 25 / 25 25. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 26 B) 20 C) 18 D) 24 0% Author: InfoMaster Foydali bo'lsa mamnunmiz