10-sinf Informatika №10 Dekabr 22, 2022Dekabr 22, 2022 da chop etilgan InfoMaster tomonidan 10-sinf Informatika №10 ga fikr bildirilmagan. 8 12345678910111213141516171819202122232425 10-sinf Informatika №10 II BOB. ELEKTRON JADVALLAR 11-dars. ELEKTRON JADVALNING ELEMENTLARI 1 / 25 1. Birinchi mexanik mashinani kim yaratgan? A) Blez Paskal B) Vilgelm Shikkard C) Ada Lavleys Bebbij D) Jon Uilyam Mokli va Jon Prosper Ekkert 2 / 25 2. HD formatining tasvir proporsiyasini toping. A) 14:09 B) 4:03 C) 16:09 D) 20:09 3 / 25 3. HDD qanday qurilma? A) USB flash xotira B) Qattiq disk C) Portativ qattiq disk D) Mustahkam disk 4 / 25 4. Quyidagi rasmda qurilma nomini toping. A) Tezkor xotira B) Ta’minot bloki C) Tizim bloki D) Kuller (sovitkich) 5 / 25 5. Lokatsiya-bu? A) Kompyuter xotirasidan ma’lumonlarni izlash B) biror narsaning turgan joyini aniqlash. C) dunyo vaqti hamda turgan o‘rinni aniqlashni ta’minlovchi harakatdagi sputnik tizimi. D) Kompyuter xotirasidagi faylni turgan joti 6 / 25 6. Dasturiy ta’minot qanday turlarga bo’linadi? A) Tizimli, amaliy, uskunaviy, utilitlar B) Tizimli, qo’shimcha, uskunaviy C) Tizimli, amaliy, uskunaviy, qo’shimcha D) Tizimli, amaliy, uskunaviy 7 / 25 7. Ma’lumot yoki signallarni o‘zgartirishga qodir qurilma yoki dasturlar nima deb nomlanadi? A) Barcha javoblar to’g’ri B) Kodek C) Konvertor D) Arxivator 8 / 25 8. Quyidagi rasmda (4) nima deb nomlanadi? A) Uskunalar lentasi B) Formulalar satrida C) Menyular satri D) Sarlavhalar satri 9 / 25 9. Yo‘l boshlovchini ishga tushirish uchun qaysi klavishlar birgalikda bosiladi? A) “ALT + W” B) “ALT + E” C) “Windows + E” D) “Windows + W” 10 / 25 10. MS Excel dasturida: B2 katakchadagi =A1+D9 formulaning C11 katakchadagi nusqasini toping. A) D17+G12 B) B10+E18 C) E15+H11 D) C10+G11 11 / 25 11. MS Excel dasturida B1:D8 diapazonda nechta katakcha bor? A) 20 B) 26 C) 24 D) 18 12 / 25 12. MS Excel 2019 dasturida satrlar soni nechta A) 15,576 B) 16,384 C) 1 048 576 D) 18,576 13 / 25 13. MS Excel dasturida: C10 katakchadagi =$A3+E$16 formulaning G19 katakchadagi nusqasini toping. A) $A12+$E25 B) $A12+I$16 C) $A$3+I$16 D) E12+I$16 14 / 25 14. MS Excel dasturida A3:C6 diapazonda nechta katakcha bor? A) 10 B) 6 C) 14 D) 12 15 / 25 15. 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 16 / 25 16. Formuladan nusxa ko‘chirilganda, undagi katak manzili o‘zgarmasa , bunday murojaatga ….deyiladi. Nuqtalar o’rniga to’g’ri javobni qo’ying. A) nisbiy murojaat B) aralash murojaat C) absolyut murojaat 17 / 25 17. Elektron jadvalning harf bilan nomlangan vertikal ustuni nima deb nomlanadi? A) Satr B) Katak C) Ustun 18 / 25 18. MS Excel dasturida A2:B6 diapazonda nechta katakcha bor? A) 6 B) 4 C) 10 D) 12 19 / 25 19. Elektron jadvalning son bilan nomlangan gorizontal qatori nima deb nomlanadi? A) Katak B) Satr C) Ustun 20 / 25 20. MS Excel dasturida: B4 katakchadagi =A2+$D$4 formulaning F8 katakchadagi nusqasini toping. A) E6+H$4 B) F6+D$4 C) E6+$D$4 D) E6+H8 21 / 25 21. 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 22 / 25 22. MS Excel dasturida: C3 katakchadagi =D2+D5 formulaning B7 katakchadagi nusqasini toping. A) B6+B9 B) C6+D9 C) D6+C9 D) C6+C9 23 / 25 23. MS Excel dasturida: D11 katakchadagi =E7-B7 formulaning G13 katakchadagi nusqasini toping. A) F9-E9 B) H9-E9 C) H9-I9 D) G9-E9 24 / 25 24. MS Excel dasturida: C6 katakchadagi =D8+F2 formulaning E10 katakchadagi nusqasini toping. A) F12+H6 B) H12+H6 C) F12+I6 D) C5+G13 25 / 25 25. MS Excel dasturida: A4 katakchadagi =$B2+F5 formulaning E8 katakchadagi nusqasini toping. A) $B6+J9 B) $B6+J$5 C) F$2+J$5 D) F$2+J9 0% Author: InfoMaster 10-sinf Informatika