10-sinf Informatika №10 Dekabr 22, 2022Dekabr 22, 2022 da chop etilgan InfoMaster tomonidan 10-sinf Informatika №10 ga fikr bildirilmagan. 492 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. Hisoblash vositalari – bu? A) axborotni qayta ishlash va hisoblashga mo‘ljallangan usul va vositalar majmui. B) ishga tushirish va natija olish elektron hamda mexanik ravishda amalga oshiriladigan mashinalar. C) arifmetik hisoblarni bajaruvchi qurilmalar. D) mexanik ravishda, qo‘l kuchi yordamida harakatga keltiriladigan mashinalar. 2 / 25 2. HD formatining tasvir proporsiyasini toping. A) 4:03 B) 20:09 C) 16:09 D) 14:09 3 / 25 3. Axborotni saqlash qurilmalari qanday turlarini bilasiz? A) Qattiq disk, Mustahkam disk, Portativ qattiq disk B) CD disk, DVD disk, HD DVD disk, Blu-ray disk C) USB flash xotira, Xotira kartasi D) Barcha javoblar to’g’ri 4 / 25 4. Quyidagi rasmda qurilma nomini toping. A) Tizim bloki B) Tezkor xotira C) Kuller (sovitkich) D) Ta’minot bloki 5 / 25 5. Lokatsiya-bu? A) dunyo vaqti hamda turgan o‘rinni aniqlashni ta’minlovchi harakatdagi sputnik tizimi. B) Kompyuter xotirasidan ma’lumonlarni izlash C) Kompyuter xotirasidagi faylni turgan joti D) biror narsaning turgan joyini aniqlash. 6 / 25 6. Inglizchada “System software” so’zning ma’nosini toping. A) Dasturiy ta’minot B) Amaliy dasturiy ta’minot C) Operatsion tizim D) Tizimli dasturiy ta’minot 7 / 25 7. Audiokonvertor dasturlariga misol keltiring. A) AIMP, MediaHuman Audio Converter B) Movavi Video Editor Video Suite, Any Video Converter 8 / 25 8. Quyidagi rasmda (4) nima deb nomlanadi? A) Sarlavhalar satri B) Menyular satri C) Uskunalar lentasi D) Formulalar satrida 9 / 25 9. Mac OS (Makintosh operatsion tizimi) –…? A) ko‘p masalali va ko‘p foydalanuvchili operatsion tizim B) grafik interfeysga ega operatsion tizim C) bir masalali operatsion tizim 10 / 25 10. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 14 B) 12 C) 10 D) 6 11 / 25 11. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Katak B) Ustun C) Satr 12 / 25 12. 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+$I$6 D) $C12+$I7 13 / 25 13. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) $B6+J9 B) F$2+J$5 C) $B6+J$5 D) F$2+J9 14 / 25 14. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) E6+$D$4 B) E6+H8 C) E6+H$4 D) F6+D$4 15 / 25 15. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) B10+E18 B) E15+H11 C) C10+G11 D) D17+G12 16 / 25 16. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) H12+H6 B) C5+G13 C) F12+I6 D) F12+H6 17 / 25 17. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 12 B) 4 C) 6 D) 10 18 / 25 18. MS Excel 2019 dasturida satrlar soni nechta A) 1 048 576 B) 15,576 C) 18,576 D) 16,384 19 / 25 19. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 18 B) 20 C) 24 D) 26 20 / 25 20. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Katak B) Satr C) Ustun 21 / 25 21. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) B6+B9 B) C6+D9 C) C6+C9 D) D6+C9 22 / 25 22. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) F9-E9 B) H9-E9 C) H9-I9 D) G9-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) aralash murojaat B) nisbiy murojaat C) absolyut murojaat 24 / 25 24. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) E12+I$16 B) $A$3+I$16 C) $A12+$E25 D) $A12+I$16 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) absolyut murojaat C) nisbiy murojaat 0% Author: InfoMaster 10-sinf Informatika