Uy » Mavzulatshitilgan testlar » Informatika mavzulashtirilgan » 10-sinf Informatika » 10-sinf Informatika №10 10-sinf Informatika 10-sinf Informatika №10 InfoMaster Dekabr 22, 2022 518 Ko'rishlar 1 izoh SaqlashSaqlanganOlib tashlandi 3 58 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. EHM 4-avlodi nechanchi yillarni o’z ichiga oladi? A) 1985-yildan hozirgi vaqtgacha B) 1978-yildan hozirgi vaqtgacha C) 1975-yildan hozirgi vaqtgacha D) 1960-yildan hozirgi vaqtgacha 2 / 25 2. SVGA formatining tasvir proporsiyasini toping. A) 4:03 B) 16:09 C) 20:09 D) 14:09 3 / 25 3. Doimiy xotira qurilmasining ingliz tilidagi qisqartmasi qanday? A) ROM B) HDD C) Cacher D) RAM 4 / 25 4. Kompyuterning qaysi qurilmasini “kompyuterning miyasi” ham deb ataladi? A) Qattq disk B) Protsessor C) Tezkor xotira D) Videokarta 5 / 25 5. GPS-BU? A) biror narsaning turgan joyini aniqlash. B) Kompyuter xotirasidan ma’lumonlarni izlash C) Kompyuter xotirasidagi faylni turgan joti D) dunyo vaqti hamda turgan o‘rinni aniqlashni ta’minlovchi harakatdagi sputnik tizimi. 6 / 25 6. – amaliy vazifalarni yechish uchun mo‘ljallanagan dasturlar majmui. Ushbu ta’rif qaysi javobga mos? A) Dasturiy ta’minot (ingl. Software) B) Amaliy dasturiy ta’minot (ingl. Application software – Apps) C) Utilitlar (ingl. Utility) D) Tizimli dasturiy ta’minot (ingl. System software) 7 / 25 7. Bugungi kunda eng keng tarqalgan arxivator dasturlarini toping. A) AAC, ACELP.live, AIF, AU, MP3, Ogg Vorbis B) WinRAR va 7-Zip C) AAC, OGG, FLAC, APE D) DivX, AVI, Cinepak 8 / 25 8. Quyidagi rasmda (6) nima deb nomlanadi? A) Holatlar satrida B) Ishchi maydon C) Ishchi kitob varaqlarida D) Sarlavhalar satri 9 / 25 9. UNIX muhiti qanaqa interfeysida ishlaydi? A) CLI B) GUI 10 / 25 10. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 6 B) 4 C) 10 D) 12 11 / 25 11. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C12+$I7 B) $C$11+$I$6 C) $C13+$J$6 D) $C12+$I$6 12 / 25 12. 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 13 / 25 13. MS Excel dasturida A2;B6 diapazonda nechta katakcha bor? A) 12 B) 2 C) 10 D) 4 14 / 25 14. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) $B6+J9 B) F$2+J$5 C) F$2+J9 D) $B6+J$5 15 / 25 15. 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 16 / 25 16. MS Excel 2019 dasturida satrlar soni nechta A) 16,384 B) 1 048 576 C) 18,576 D) 15,576 17 / 25 17. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Katak B) Ustun C) Satr 18 / 25 18. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) H9-E9 B) H9-I9 C) F9-E9 D) G9-E9 19 / 25 19. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) C5+G13 B) F12+I6 C) H12+H6 D) F12+H6 20 / 25 20. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) C6+C9 B) C6+D9 C) D6+C9 D) B6+B9 21 / 25 21. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) C10+G11 B) D17+G12 C) B10+E18 D) E15+H11 22 / 25 22. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Satr B) Ustun C) Katak 23 / 25 23. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) E6+$D$4 B) E6+H8 C) F6+D$4 D) E6+H$4 24 / 25 24. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 6 B) 12 C) 10 D) 14 25 / 25 25. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A$3+I$16 B) $A12+I$16 C) E12+I$16 D) $A12+$E25 0% Author: InfoMaster Foydali bo'lsa mamnunmiz
