Informatika attestatsiya №7

Informatika fanidan attestatsiya savollari №7

Test muallifi: Durbek Chinmirzayev

DIQQAT! Endi siz o'z bilmingizni sinab ko'rish bilan birga sertifikatga ham ega bo'lishingiz mumkin.

Sertifikat olish uchun barcha ma'lumotlarni to'g'ri kriting!

Testda 76% va undan yuqori natija oling va sertifikatni yuklab oling.

1 / 40

1. MS Excel A1=6, B1=12, C1=3, A2=24, B2=30, C2=Informatika berilgan bo'lsa, =ПСТР(C2;1+СЧЁТЕСЛИ(A1:B2; ">11");C1)
formula qiymatini toping.

A) for

B) mat

C) orm

D) Info

2 / 40

2. for i in range(10,0,-1):

print(i, end=';') . Dastur natijasini toping?

A) 10 9 8 7 6 5 4 3 2 1;

B) '10';'9';'8';'7';'6';'5';'4';'3';'2';'1';

C) 10;9;8;7;6;5;4;3;2;1;

D) '10' '9' '8' '7' '6' '5' '4' '3' '2' '1'

3 / 40

3. http://www.mysite.ru/page.htm nima?

A) Telnet

B) elektron pochta adresi

C) multimedia fayli

D) web-sahifa adresi

4 / 40

4. MS Excelda ma'lumotlar karakchaga sig'masa qanday belgi paydo bo'ladi?

A) ДЕЛ/O

B) To’g’ri javob yo’q.

C) #NAME?

D) #####

5 / 40

5. Ali, Vali va Soli imtihonda 3 xil ball olishdi: 3 yoki 4 yoki 5. Faqat bittasi yolg‘onligi ma’lum: “Ali 5 ball olmagan”, “Vali 4 ball olmagan”, “Soli 4 ball olgan”. Agar Ali 4 ball olmagani ma’lum bo‘lsa, u holda o‘quvchilar olgan ballarni aniqlang.

A) Ali – 3 ball, Vali – 4 ball, Soli – 5 ball

B) Ali – 3 ball, Vali – 5 ball, Soli – 4 ball

C) Ali – 5 ball, Vali – 3 ball, Soli – 4 ball

D) Ali – 5 ball, Vali – 4 ball, Soli – 3 ball

6 / 40

6. PowerPointda F5 tugmasining vazifasi?

A) Takdimotni boshka fayl bilan boglash

B) Takdimotni uchirish

C) Takdimotni boshidan boshlash

D) Takdimotni aktiv slayddan boshlash

7 / 40

7. Excel A1=1, C1=A1+5, A2=A1+B2, B2=MIN(a1;c1), c2=b2*b1 berilgan A2:C2 blok asosida gistogramma tuzilgan.A2 katakka mos gistogramma qismi B2 va C2 katakka mos gistogramma qismlarning har biridan 2 marta uzun. Shulardan kelib chiqib B1 karakdagi qiymatni aniqlang va quyidagi formulaning natijasini hisoblang: = 3*корень(в1)*а1+6*с2

A) 3

B) 6

C) 5

D) 9

8 / 40

8. A1, B1 va C1 kataklariga mos ravishda 42, 45 va 25 sonlari kiritilgan D1 katakga C1, B1, A1 katakdagi sonlar yig‘indisi o‘rta arifmetigini yozish qaysi formula bilan bajariladi

A) = СРЗНАЧ(A1:C1)

B) = СУММ(42+45+25)/3

C) =(A1:C1)/3

D) = СРЗНАЧ(A1+B1+C1)/3

9 / 40

9. Scratch-dagi buyruqlar bloklari rangli toifalarga bo'linadi. Bunday toifalar nechta?

A) 10

B) 7

C) 15

D) 20

10 / 40

10. Yuqoridagi blok qanday vazifani bildiradi?

A) Agar sprayt belgilangan rangga tegsa True, aks holda, Falseqiymatni qaytaradi

B) Sprayt sichqoncha ko‘rsatkichi yoki sahna chegaralarigatekkanida biror bir hodisa ro‘y beradi

C) Skript bajarilishini to‘xtatib turadi

D) Spraytgacha yoki sichqonchaning ko‘rsatkichi (kursori)gachabo‘lgan masofani qaytaradi

11 / 40

11. Turli multimedia fayllarini ijro etish uchun yillar davomida sinovdan o‘tgan yordamchi dastur. Foydalanuvchilarga interfeysni o‘zgartirish imkonini beruvchi bir nechta qobiqlari mavjud. Ma’lumotlarni optik disklarga yozish vositasi mavjud

A) Mediaplayer

B) AIMP

C) Winamp

D) KMPlayer

12 / 40

12. Photoshopda tezkor ajratish uskunasi bilan birga joylashgan sehrli tayoqchani tanlash uchun klaviaturadan qaysi tugmalar birgalikda bosiladi ?

A) Ctrl+E

B) Shift+X

C) Alt+W

D) Ctrl+W

13 / 40

13. PowerPoint nechanchi versiyasida taqdimotga YouTubedan videolarni joylashtirish imkoniyati paydo bo‘lgan

A) 2010

B) 2019

C) 2013

D) 2016

14 / 40

14. 1992-yilda birinchi Microsoft Office paketiga kirgan dasturlarni belgilang:

A) Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Outlook

B) Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint

C) Microsoft Word, Microsoft Access, Outlook

D) Windows, Linux, MacOS

15 / 40

15. Bog’da 77 dona daraxt mavjud. Shundan 25 tasi olma, 22 tasi nok, 15 tasi olcha va 16 tasi o’rik. Bog’bon hisobni qaysi sanoq sistemasida yuritgan?

A) 10

B) 16

C) 9

D) 11

16 / 40

16. Inson axborotni nechchi foizini his qilish, ta`m va hid orqali qabul qilar ekan?

A) 1%

B) 87%

C) 3%

D) 9%

17 / 40

17. Natija qanday bo'ladi?

A) False True

B) True True

C) False False

D) True False

18 / 40

18. Natijani aniqlang

A) attestatsiya

B) Oliy toifa

C) Syntax error

D) 61

19 / 40

19. Foydalanish talablari asosida ma’lumotning yashirinligi, yaxlitligi va foydalanuvchanligini ta’minlash .... deyiladi

A) Axborotni muhofazalash

B) Ma’lumotni ochish

C) Axborot xavfsizligi

D) Identifikatsiya

20 / 40

20. Internet muhiti bu -......

A) Virtual olam

B) Gruming

C) Ijtimoiy tarmoq

D) Fishing

21 / 40

21. Jadvaldagi qaysi satr va qaysi ustunda tartiblangan ro’yxatning tartib raqamlarining yig’indisi 7-sanoq sistemasida 103 ga teng bo’ladi

A) Ikkinchi qator uchinchi ustun

B) Ikkinchi qator ikkinchi ustun

C) birinchii qator ikkinchi ustun

D) birinchii qator uchinchi ustun

22 / 40

22. ASCII kengaytmasi?

A) American Standart Code for Integrated

B) American Standart Code Interchange

C) American Standart Code for Information Internchange

D) American Standart Code Information Interchange

23 / 40

23. MS PowerPoint taqdimotlariga internetdan shablon yuklab olish uchun qaysi saytga murojaat qilamiz?

A) www.powerpointbase.com

B) www.powerpointbase.org

C) www.powerpoint.com

D) www.mspowerpointbase.com

24 / 40

24. Tahdid va shantaj qilish maqsadida voyaga yetmaganlar bilan Internet orqali о‘rnatiladigan aloqa

A) Bouling

B) Bulling

C) Fishing

D) Gruming

25 / 40

25. HTML da jadvaldagi toq ustundagi rim raqamida berilgan sonlar yig’indisi nechaga teng?

A) 34

B) 24

C) 33

D) 15

26 / 40

26. Grafik muharirlar yozilgan dasturlar qatorini aniqlang

A) Adobe Reader, Visio, Netpaint

B) Klavtren, Solo, Stamina, Paint

C) Bloknot, Microsoft Word

D) Paint, Tux Paint, Paint.NET, Photoshop

27 / 40

27. Scratch dasturida barcha buyruqlarni bajaruvchi, algoritm ijrochisi va ssenariy bo‘yicha sahnada harakatlanuvchi obyekt qanday nomlanadi?

A) mushukcha

B) sprayt

C) skript

D) sahna

28 / 40

28. Foydali ma`lumot: ABCDEFGHIJKLMNOPQRSTUVWXYZ

A) 50

B) 49

C) 32

D) 52

29 / 40

29. Qaysi satr va ustunda kichik va tartiblangan rim raqamalari "i, ii,iii" raqamalridan boshlangan?

A) 2-qator, 2-ustun

B) 1-qator, 3-ustun

C) 1-qator, 1-ustun

D) 1-qator, 2-ustun

30 / 40

30. Tasodifan yoki xusumatli harakatlar natijasida begona shaxsga axborotning mazmuni ruxsatsiz oshkor etilish .... deyiladi

A) Axborot xavfsizligi

B) Axborotni muhofazalash

C) Xoinlik

D) Ma’lumotni ochish

31 / 40

31. Dastur kodi

A) for num in range(6,-5,-4): print(num, end=";")

B) for num in range(4,-5,-1): print(num, end=";")

C) for num in range(5,-6,-2): print(num, end=";")

D) for num in range(5,-5,-3): print(num, end=";")

32 / 40

32. Quyidagi brend nomlari to’g’ri keltirilgan qatorni ko’rsating.

A) Linked In, Pinterest, Youtube, Motorola, Twitter

B) Nike, Skype, QuickTime, Telegram, WordPress

C) Nike, Skype, QBasic, Telegram, WordPress

D) Nike, Skype, QuickTime, Telegram, Volkswagen

33 / 40

33. ((A ∨ B) & (⏋A)) => B rost qiymatlar soni nechta?

A) 3 ta

B) 2 ta

C) 4 ta

D) 1 ta

34 / 40

34. MS PowerPoint dasturi nechanch yilda va qaysi firmaning kompyuterlari uchun ishlab chiqarilgan?

A) 1990-yilda Microsoft kompyuterlari uchun

B) 1989-yilda Microsoft kompyuterlari uchun

C) 1987-yilda Apple Macintosh kompyuterlari uchu

D) 1988-yilda Apple Macintosh kompyuterlari uchun

35 / 40

35. Quyidagi brend nomlari to’g’ri keltirilgan qatorni ko’rsating.

A) Good+, Internet Explorer, Volkswagen, Life’s Good, Instagram

B) Walt Disney, Apple, Bluetooth, Cable News Network, Facebook

C) Google+, Internet Explorer, Honda, Life’s Good, Instagram

D) Google+, Internet Explorer, Volkswagen, Life’s Good, Instagram

36 / 40

36. O'quvchilar nechchi baho olishgan

A) Ali – 3 ball, Vali – 4 ball, Soli – 5 ball

B) Ali – 3 ball, Vali – 5 ball, Soli – 4 ball

C) Ali – 4 ball, Vali – 5 ball, Soli – 3 ball

D) Ali – 5 ball, Vali – 4 ball, Soli – 3 ball

37 / 40

37. Audio va videofayllarni tez va oson yaratish hamda tahrirlash imkoniyatiga ega onlayn veb-sayt

A) Video Cutter (http://online-video-cutter.com/)

B) 123Apps (https://123apps.com/)

C) Free Audio Recorder (http://www.freeaudiorecorder.net)

D) Audio Joiner (http://audio-joiner.com/)

38 / 40

38. Hardware nima?

A) Yumshoq qism yoki dasturiy ta`minot

B) Qattiq qism yoki texnik ta`minot

C) Hamma javoblar to`g`ri

D) Aqliy ta`minot yoki intellekt

39 / 40

39. Natijani aniqlang

A) 16

B) 15

C) 14

D) 13

40 / 40

40. MS Excel. A1:A6 va B2:B6 bloklardagi 5 xonali sonlardan eng kichigining chapdan 2-raqamini aniqlaydigan formulani ko‘rsating.

A) ABS((A1:A6; B2:B6); 2;1)

B) 2

C) ПСТР(МAX(A1:A6; B2:B6); 2;1)

D) ПСТР(МИН(A1;A6; B2;B6); 2;1

0%

Informatika attestatsiya №7

Sertifikat olish uchun barcha ma'lumotlarni to'g'ri kriting!

Author: InfoMaster

Fransuz tili attestatsiya №1

Tarix attestatsiya №5

Informatika fanidan attestatsiya savollari №18

Informatika fanidan attestatsiya savollari №17

Informatika fanidan attestatsiya savollari №16

Informatika fanidan attestatsiya savollari №15

Javob qoldiring

Elementlarni Solishtiring