10-sinf Informatika №10 Dekabr 22, 2022Dekabr 22, 2022 da chop etilgan InfoMaster tomonidan 10-sinf Informatika №10 ga fikr bildirilmagan. 73 12345678910111213141516171819202122232425 Tomonidan yaratilgan InfoMaster 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. -kompyuterda bajarilishi nazarda tutilgan barcha dasturiy mahsulotlar to‘plami.Ushbu ta’rif qaysi javobga mos? A) Operatsion tizim (ingl. Operatsion system) B) Utilitlar (ingl. Utility) C) Dasturiy ta’minot (ingl. Software) D) Amaliy dasturiy ta’minot (ingl. Application software – Apps) 2 / 25 2. EHM 1-avlodining kiritish-chiqarish qurilmasi qaysi javobda to’g’ri ko’rsatilgan? A) boshqaruv pulti, perfokarta. B) rangli, grafikli displey. C) videoterminal D) perfolenta, magnitli baraban. 3 / 25 3. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 20 B) 26 C) 18 D) 24 4 / 25 4. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) H12+H6 B) F12+I6 C) F12+H6 D) C5+G13 5 / 25 5. MS Excel 2019 dasturida satrlar soni nechta A) 18,576 B) 1 048 576 C) 15,576 D) 16,384 6 / 25 6. Ma’lumot yoki signallarni o‘zgartirishga qodir qurilma yoki dasturlar nima deb nomlanadi? A) Kodek B) Arxivator C) Konvertor D) Barcha javoblar to’g’ri 7 / 25 7. – Ethernet texnologiyasi asosida lokal kompyuter tarmog‘iga ulanishni ta’minlovchi qurilma. A) Tarmoq kartasi B) Videokarta C) Tezkor xotira D) Ovoz kartasi 8 / 25 8. Kompyuterda axborotni saqlashning necha turi mavjud? A) 1 B) 2 C) 4 D) 3 9 / 25 9. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 12 B) 6 C) 14 D) 10 10 / 25 10. Lokatsiya-bu? A) biror narsaning turgan joyini aniqlash. B) Kompyuter xotirasidagi faylni turgan joti C) Kompyuter xotirasidan ma’lumonlarni izlash D) dunyo vaqti hamda turgan o‘rinni aniqlashni ta’minlovchi harakatdagi sputnik tizimi. 11 / 25 11. 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 12 / 25 12. Quyidagi rasmda (4) nima deb nomlanadi? A) Uskunalar lentasi B) Menyular satri C) Formulalar satrida D) Sarlavhalar satri 13 / 25 13. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) E6+H$4 B) E6+H8 C) E6+$D$4 D) F6+D$4 14 / 25 14. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Katak B) Satr C) Ustun 15 / 25 15. MS Excel dasturida: C5 katakchadagi =$C$11+$I$6 formulaning H6 katakchadagi nusqasini toping. A) $C12+$I$6 B) $C13+$J$6 C) $C$11+$I$6 D) $C12+$I7 16 / 25 16. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) C10+G11 B) E15+H11 C) D17+G12 D) B10+E18 17 / 25 17. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) H9-E9 B) H9-I9 C) F9-E9 D) G9-E9 18 / 25 18. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) C6+D9 B) C6+C9 C) B6+B9 D) D6+C9 19 / 25 19. Tashqi qurilmalar (printer, skaner...) aosan qaysi portlarga ulanadi? A) DVI B) HDMI C) LAN D) USB 20 / 25 20. MS Excel dasturida A2;B6 diapazonda nechta katakcha bor? A) 12 B) 4 C) 2 D) 10 21 / 25 21. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Ustun B) Satr C) Katak 22 / 25 22. MS DOS muhiti qanaqa interfeysida ishlaydi? A) CLI B) GUI 23 / 25 23. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A12+I$16 B) $A12+$E25 C) E12+I$16 D) $A$3+I$16 24 / 25 24. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) $B6+J$5 B) F$2+J$5 C) $B6+J9 D) F$2+J9 25 / 25 25. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 10 B) 6 C) 12 D) 4 0% Author: InfoMaster 10-sinf Informatika