{"id":669,"date":"2023-10-02T03:34:37","date_gmt":"2023-10-02T03:34:37","guid":{"rendered":"https:\/\/dars-ishlanma.uz\/?p=669"},"modified":"2023-10-04T15:15:21","modified_gmt":"2023-10-04T15:15:21","slug":"test-10-sinf-i-chorak","status":"publish","type":"post","link":"https:\/\/dars-ishlanma.uz\/ru\/test-10-sinf-i-chorak\/","title":{"rendered":"\u0422\u0435\u0441\u0442 10 \u043a\u043b\u0430\u0441\u0441 I \u0447\u0435\u0442\u0432\u0435\u0440\u0442\u044c"},"content":{"rendered":"<p><strong>1. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadvalga biror rasm, diagramma kabi obyektlarni joylashtirishga mo\u2018ljallangan;<\/strong><\/p>\n\n\n\n<p>a) \u0413\u043b\u0430\u0432\u043d\u0430\u044f; b) \u0412\u0441\u0442\u0430\u0432\u043a\u0430; c) \u0420\u0430\u0437\u043c\u0435\u0442\u043a\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b; d) \u0424\u043e\u0440\u043c\u0443\u043b\u044b.<\/p>\n\n\n\n<p><strong>2. MS Excel 2010 da ishlash jaroyonida turli xatolar yuzaga kelishi mumkin. Shuning uchun ko\u2018p uchraydigan xatolar maxsus ko\u2019rinishda tavsiflanadi. Agar katakchada #\u0417\u041d\u0410\u0427! ko\u2019rinish tavsiflangan bo\u2019lsa u qanday xatolikni anglatadi?<\/strong><\/p>\n\n\n\n<p>a) hisoblash formulasida 0 ga bo\u2018lish holati mavjud; b) ma\u2019lumot katakka sig\u2018magan; c) formulada mumkin bo\u2018lmagan ifodalar qatnashmoqda; d) Excel formuladagi o\u2018zgaruvchining nomini aniqlay olmadi<\/p>\n\n\n\n<p><strong>3. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadvallardagi ma\u2019lumotlarni kiritishga va tahrirlashga mo\u2018ljallangan;<\/strong><\/p>\n\n\n\n<p>a)\u0413\u043b\u0430\u0432\u043d\u0430\u044f; b) \u0412\u0441\u0442\u0430\u0432\u043a\u0430; c) \u0420\u0430\u0437\u043c\u0435\u0442\u043a\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b; d) \u0424\u043e\u0440\u043c\u0443\u043b\u044b.<\/p>\n\n\n\n<p><strong>4. MS Excel 2010 da ishlash jaroyonida turli xatolar yuzaga kelishi mumkin. Shuning uchun ko\u2018p uchraydigan xatolar maxsus ko\u2019rinishda tavsiflanadi. Agar katakchada #\u0418\u041c\u042f? ko\u2019rinish tavsiflangan bo\u2019lsa u qanday xatolikni anglatadi?<\/strong><\/p>\n\n\n\n<p>a) hisoblash formulasida 0 ga bo\u2018lish holati mavjud; b) ma\u2019lumot katakka sig\u2018magan; c) formulada mumkin bo\u2018lmagan ifodalar qatnashmoqda; &nbsp;d) Excel formuladagi o\u2018zgaruvchining nomini aniqlay olmadi<\/p>\n\n\n\n<p><strong>5. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadvallardagi hisoblashlarni amalga oshiruvchi har xil formulalardan foydalanish uchun mo\u2018ljallangan;<\/strong><\/p>\n\n\n\n<p>a) \u0413\u043b\u0430\u0432\u043d\u0430\u044f; b) \u0412\u0441\u0442\u0430\u0432\u043a\u0430; c) \u0420\u0430\u0437\u043c\u0435\u0442\u043a\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b; d)\u0424\u043e\u0440\u043c\u0443\u043b\u044b<\/p>\n\n\n\n<p><strong>6. MS Excel 2010 da ishlash jaroyonida turli xatolar yuzaga kelishi mumkin. Shuning uchun ko\u2018p uchraydigan xatolar maxsus ko\u2019rinishda tavsiflanadi. Agar katakchada #\u0414\u0415\u041b\/0 ko\u2019rinish tavsiflangan bo\u2019lsa u qanday xatolikni anglatadi?<\/strong><\/p>\n\n\n\n<p>a) hisoblash formulasida 0 ga bo\u2018lish holati mavjud; b) ma\u2019lumot katakka sig\u2018magan; c) formulada mumkin bo\u2018lmagan ifodalar qatnashmoqda; d) Excel formuladagi o\u2018zgaruvchining nomini aniqlay olmadi<\/p>\n\n\n\n<p><strong>7. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadval varaqlarini bosmaga chiqarish uchin sahifalarning chegaralari va boshqa parametrlarini belgilash uchun mo\u2018ljallangan;<\/strong><\/p>\n\n\n\n<p>a) \u0413\u043b\u0430\u0432\u043d\u0430\u044f; b) \u0412\u0441\u0442\u0430\u0432\u043a\u0430; c) \u0420\u0430\u0437\u043c\u0435\u0442\u043a\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b; d) \u0424\u043e\u0440\u043c\u0443\u043b\u044b<\/p>\n\n\n\n<p><strong>8. MS Excel 2010 da ishlash jaroyonida turli xatolar yuzaga kelishi mumkin. Shuning uchun ko\u2018p uchraydigan xatolar maxsus ko\u2019rinishda tavsiflanadi. Agar katakchada ###### ko\u2019rinish tavsiflangan bo\u2019lsa u qanday xatolikni anglatadi?<\/strong><\/p>\n\n\n\n<p>a) hisoblash formulasida 0 ga bo\u2018lish holati mavjud; b) ma\u2019lumot katakka sig\u2018magan; c) formulada mumkin bo\u2018lmagan ifodalar qatnashmoqda; d) Excel formuladagi o\u2018zgaruvchining nomini aniqlay olmadi.<\/p>\n\n\n\n<p><strong>9. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadvallarning ustun va satrlaridagi ma\u2019lumotlarni filtrlash, saralash, nusxalarini ko\u2019paytirish, keraksizlarini yo\u2019qotish, tashqi axboratlarni kiritish uchun mo\u2019ljallangan?<\/strong><\/p>\n\n\n\n<p>a) \u0414\u0430\u043d\u043d\u044b\u0435; b) \u0420\u0435\u0446\u0435\u043d\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435; c) \u0412\u0438\u0434; d) \u0412\u0441\u0442\u0430\u0432\u043a\u0430.<\/p>\n\n\n\n<p><strong>10. Elektron jadvalning birlamchi vazifasi nimadan iborat?<\/strong><\/p>\n\n\n\n<p>a) Ma\u2019lumotlarni jadval ko\u2019rinishida tasvirlash hamda ularni qayta ishlash; b) Ma\u2019lumotlar omborini boshqarish; c) Hisob kitobni avtomatlashtirish; d) Jadval yaratish;<\/p>\n\n\n\n<p><strong>11. MS Excel 2010 tasmaning qaysi bo\u2018lagi jadvallarni ekranda turlicha namoyish qilishga moslashtirish uchu mo\u2019ljallangan?<\/strong><\/p>\n\n\n\n<p>a) \u0414\u0430\u043d\u043d\u044b\u0435; b) \u0420\u0435\u0446\u0435\u043d\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435; c) \u0412\u0438\u0434; d) \u0420\u0430\u0437\u043c\u0435\u0442\u043a\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b.<\/p>\n\n\n\n<p><strong>12<\/strong>. <strong>Excell elektron jadvalining matnli turdagi funksiyalariga misollar keltiring?<\/strong><\/p>\n\n\n\n<p>a) \u0418, \u0418\u041b\u0418, \u0415\u0421\u041b\u0418; b) ABS, \u0417\u041d\u0410\u041a, \u041a\u041e\u0420\u0415\u041d\u042c;c) \u041c\u0410\u041a\u0421, \u041c\u0418\u041d, \u0421\u0420\u0417\u041d\u0410\u0427; d) \u0414\u041b\u0421\u0422\u0420, \u0417\u0410\u041c\u0415\u041d\u0418\u0422\u042c, \u041b\u0415\u0412\u0421\u0418\u041c\u0412.<\/p>\n\n\n\n<p><strong>13. MS Excel 2010 tasmaning qaysi bo\u2018lagi matn xatolarini tuzatish va hujjatlarni tahrirlash uchun mo\u2019ljallangan?<\/strong><\/p>\n\n\n\n<p>a) \u0413\u043b\u0430\u0432\u043d\u0430\u044f; b) \u0414\u0430\u043d\u043d\u044b\u0435; c) \u0420\u0435\u0446\u0435\u043d\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435; d) \u0412\u0438\u0434;<\/p>\n\n\n\n<p><strong>14<\/strong>. <strong>Excell elektron jadvalining mantiqiy turdagi funksiyalariga misollar keltiring?<\/strong><\/p>\n\n\n\n<p>a) \u0418, \u0418\u041b\u0418, \u0415\u0421\u041b\u0418; b) ABS, \u0417\u041d\u0410\u041a, \u041a\u041e\u0420\u0415\u041d\u042c;c) \u041c\u0410\u041a\u0421, \u041c\u0418\u041d, \u0421\u0420\u0417\u041d\u0410\u0427; d) \u0414\u041b\u0421\u0422\u0420, \u0417\u0410\u041c\u0415\u041d\u0418\u0422\u042c, \u041b\u0415\u0412\u0421\u0418\u041c\u0412.<\/p>\n\n\n\n<p><strong>15. MS Excel 2010 ning standart varag\u2018ida harflar orqali belgilanuvchi nechta ustun mavjud.<\/strong><\/p>\n\n\n\n<p>a) 17358 ta; b) 16348 ta; c) 6358 ta; d) 18348 ta.<\/p>\n\n\n\n<p><strong>16.<\/strong> <strong>Excell elektron jadvalining matematik turdagi funksiyalariga misollar keltiring?<\/strong><\/p>\n\n\n\n<p>a) \u0418, \u0418\u041b\u0418, \u0415\u0421\u041b\u0418; b) ABS, \u0417\u041d\u0410\u041a, \u041a\u041e\u0420\u0415\u041d\u042c;c) \u041c\u0410\u041a\u0421, \u041c\u0418\u041d, \u0421\u0420\u0417\u041d\u0410\u0427; d) \u0414\u041b\u0421\u0422\u0420, \u0417\u0410\u041c\u0415\u041d\u0418\u0422\u042c, \u041b\u0415\u0412\u0421\u0418\u041c\u0412.<\/p>\n\n\n\n<p><strong>17.<\/strong> <strong>Murojaat<\/strong><strong> <\/strong><strong>nima<\/strong><strong>?<\/strong><\/p>\n\n\n\n<p>a) Formula yozishda ishlatilayotgan katakcha, satr, ustun yoki katakchalar blokining adresi. b) Matematik amallarni bajarish; c) Katakchalar, satr, ustun yoki katakchalar blokinidan nusxa ko\u2019chirish; d) Ma\u2019lumotlani ko\u2019chirib o\u2019tkazish.<\/p>\n\n\n\n<p><strong>18. MS Excel 2010 ning standart varag\u2018ida raqamlar orqali ifodalanuvchi nectar satr mavjud.<\/strong><\/p>\n\n\n\n<p>a) 1 148&nbsp;576 ta; b) 1 048 576 ta; c) 1 047&nbsp;576 ta; d) 2 048&nbsp;576 ta.<\/p>\n\n\n\n<p><strong>19. Elektron jadvallarda qanday murojaatlar qo&#8217;llaniladi.<\/strong><\/p>\n\n\n\n<p>a) Ma\u2019ntiqiy va nisbiy; b) Mantiqiy va mahalliy; c) Nisbiy va absolyut d) Mahalliy va nisbiy.<\/p>\n\n\n\n<p><strong>20. Elektron jadvallar &#8211; ustun va satrlarning birlashmasidan iborat jadval bo&#8217;lib, satr va ustun kesishmasi nima deb ataladi.<\/strong><\/p>\n\n\n\n<p>a) Murojaat; b) Jadval maydoni; c) Adres; d) Katakcha yoki yacheyka.<\/p>\n\n\n\n<p><strong>21. Har bir katakcha ustun va satrning tartibidan kelib chiqqan holda o&#8217;zining \u2026 ga ega bo&#8217;ladi.<\/strong><\/p>\n\n\n\n<p>a) Adresi; b) Joyi; c) Natijasi; d) O\u2019rni.<\/p>\n\n\n\n<p><strong>22. Excel jadvalini ishga tushirishni necha xil usulda amalga oshirish mumkin?<\/strong><\/p>\n\n\n\n<p>a) 2 xil usulda; b) 3 xil usulda; c) Faqaat bir xil yo\u2019l bilan; d) To\u2019g\u2019ri javob berilmagan.<\/p>\n\n\n\n<p><strong>23. Excel elektron jadvalida tayyorlangan hujjat faylining kengaytmasi qanday?<\/strong><\/p>\n\n\n\n<p>a) DOC; b) BMP; c) XLS; d) MDB<\/p>\n\n\n\n<p><strong>24. Elektron jadvalning asosiy vazifasi nimadan iborat?<\/strong><\/p>\n\n\n\n<p>a) Ma\u2019lumotlarni jadval ko\u2019rinishida tasvirlash hamda ularni qayta ishlash; b) Hisob kitobni avtomatlashtirish; c) Jadval yaratish; d) Ma\u2019lumotlar omborini boshqarish<\/p>\n\n\n\n<p><strong>25. Excel elektron jadvalini ish stolidan ishga tushirish uchun qaysi yorliqdan foydalaniladi?<\/strong><\/p>\n\n\n\n<p>a) <img loading=\"lazy\" decoding=\"async\" width=\"18\" height=\"18\" class=\"wp-image-681\" style=\"width: 18px;\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/10\/w.png\" alt=\"\">; b) <img loading=\"lazy\" decoding=\"async\" width=\"18\" height=\"18\" class=\"wp-image-682\" style=\"width: 18px;\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/10\/pp.png\" alt=\"\">; c) <img loading=\"lazy\" decoding=\"async\" width=\"18\" height=\"18\" class=\"wp-image-683\" style=\"width: 18px;\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/10\/xls.png\" alt=\"\">; d) <img loading=\"lazy\" decoding=\"async\" width=\"18\" height=\"18\" class=\"wp-image-684\" style=\"width: 18px;\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/10\/access.png\" alt=\"\"> &nbsp;<\/p>\n\n\n\n<!-- Yandex.RTB R-A-2562262-5 -->\n<div id=\"yandex_rtb_R-A-2562262-5\"><\/div>\n<script>window.yaContextCb.push(()=>{\n\tYa.Context.AdvManager.render({\n\t\t\"blockId\": \"R-A-2562262-5\",\n\t\t\"renderTo\": \"yandex_rtb_R-A-2562262-5\"\n\t})\n})\n<\/script>","protected":false},"excerpt":{"rendered":"<p>O\u2018rta ta\u2019lim muassasalarining 10-sinflari va o\u2018rta maxsus, kasb-hunar ta\u2019limi muassasalari uchun 2017 yilda yrailgan darslik asosida tuzilgan test savollari (BSB va nazorat ishlari uchun)<\/p>","protected":false},"author":1,"featured_media":674,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[188,187,189,183,190,162,184,185,186],"class_list":["post-669","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-test-savollari","tag-188","tag-187","tag-elektron-jadval","tag-ms-excell-2010","tag-190","tag-162","tag-184","tag-185","tag-186"],"_links":{"self":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/comments?post=669"}],"version-history":[{"count":9,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/669\/revisions"}],"predecessor-version":[{"id":701,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/669\/revisions\/701"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media\/674"}],"wp:attachment":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media?parent=669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/categories?post=669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/tags?post=669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}