Informatika attestatsiya №5

Informatika fanidan attestatsiya savollari №5

MS Excel dasturidan ko'proq testlar.

Ustoz Durbek Chinmirzayevga rahmat aytamiz albatta!

Ismi familiyangizni kriting!

1 / 40

1. 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'

2 / 40

2. Power Pointning qaysi talqini taqdimotni videofayl ko'rinishida saqlash imkoniyatiga ega?

A) Power Point 2007

B) Barcha talqinlarida mumkin.

C) Power Point 2010

D) Power Point 2003

3 / 40

3. Berilgan dastur necha marta takrorlanadi.

for i in range(102):
print(i, end=';')

A) 101

B) 102

C) cheksiz

D) 100

4 / 40

4. MS Wordda jadvalning ajratilgan satri klaviatura orqali qanday o'chiriladi?

A) BACKSPACE klavishini bosish orqali

B) ENTER klavishini bosish orqali

C) ALT+DELETE klavishlar kombinatsiyasini bosish orqali

D) DELETE klavishini bosish orqali

5 / 40

5. Pythonda alohida faylda yozilgan bo‘lib, turli dasturlarda qo‘llanilishi mumkin bo‘lgan kodlar majmui nima?

A) bilmadim

B) modullar

C) operatorlar

D) funksiyalar

6 / 40

6. Amerika qit'asida yashagan astek, mayya qabilalarida sonlar alifbosi nechta belgini o'z ichiga olgan?

A) 12 ta

B) 20 ta

C) 60 ta

D) 5 ta

7 / 40

7. Ma’lumotlarni (odatda faylni) tarmoqdagi yoki Internetdagi boshqa kompyuterlar va serverlardan o’z kompyuteriga yuklab olish nima deb ataladi?

A) Send

B) Upload

C) Unload

D) Download

8 / 40

8. MS Excel 2003 dasturida D2 katakchadagi “=$A1*B$3” formulaning H8 katakchaga nusxasini toping.

A) =$F5*C3

B) =$A6*G$3

C) =$A7*G$3

D) =$A7*F$3

9 / 40

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

A) Telnet

B) elektron pochta adresi

C) multimedia fayli

D) web-sahifa adresi

10 / 40

10. 1988-yilda ishga tushib ko‘pgina kompyuterlarni zararlagan «Morissa» nomli virus qaysi turga mansub?

A) boot virdslari

B) fayl viruslari

C) tarmoq virusi

D) makroviruslar

11 / 40

11. CMS platformalar necha guruhga bo’linadi va ular qaysilar

A) ochiq, yopiq, aralash kodli

B) faqat ochiq kodli (bepul tarqatiladigan)

C) ochiq kodli (bepul tarqatiladigan), yopiq kodli (tijorat maqsadida tarqatiladigan)

D) faqat yopiq kodli (tijorat maqsadida tarqatiladigan)

12 / 40

12. MS Excelda A1=5 B1=6 avtoto’ldirish bajarilgandan so’ng BA1=...?

A) 69

B) 38

C) 47

D) 57

13 / 40

13. Yopiq kodli CMS platformalari ... kiradi.

A) Shopify, 1С-Битрикс, CS-cart, DataLife Engine, BigCommerce , Shop-Script

B) Shopify, 1С-Битрикс, CS-cart, Adobe, BigCommerce , Shop-Script.

C) Shopify, 1С-Битрикс, CS-cart, DataLife Engine, BigCommerce , Write

D) 1С-Битрикс, CS-cart, DataLife Engine, BigCommerce , Shop-Script, MSQL

14 / 40

14. 2 lik sanoq sistemasida 6 ta nol qatnashgan eng katta to’rt xonali 16 likda sonni ko’rsating.

A) 92CF

B) 81FF

C) 80CC

D) 81DF

15 / 40

15. 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 – 5 ball, Soli – 4 ball

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

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

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

16 / 40

16. Excelda quyidagi funksiya natijasini aniqlang: = или ( 25 –корень (36) = 1; целое(81/3)>-1)

A) 1

B) 1

17 / 40

17. MS Excel Al = -5, B1=6, B2=4 bo’lsin. Quyidagi formula natijasi -24 bolishi uchun A2 katakka kiritish zarur bo’gan qiymatni aniqlang: =ЕСЛИ(ИЛИ(A1+B2>=A2*B1; A1*B1 >0); A1*B2-B1-A2; A1*B1+B2+A2)

A) 2

B) 3

C) 1

D) 4

18 / 40

18. 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)/3

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

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

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

19 / 40

19. Elektron jadvalda =СРЗНАЧ(C2:C5) formulasining qiymati 3 ga teng. Agar C5 katakning qiymati 5 bo'lsa, quyidagi formulaning qiymatini toping: =СУММ(C2:C4)

A) 2

B) 5

C) 10

D) 7

20 / 40

20. ПОДСТАВИТЬ("Informatika"; "a"; "matem") fuksiyaning natijasi qanday?

A) Informatemtika

B) Informatemtikmatem

C) Informmatemtikamatem

D) Informmatemtikmatem

21 / 40

21. A1=4, B1=5, C2=6, B2= A1*B1+C2 B2 ni nusxasini B3 yacheykasiga olinsa, B3 yachykadagi hosil bo'lgan sonni topingchi

A) 30

B) 20

C) 4

22 / 40

22. MS Excel. A1=-6; A2=-1; B1=6; B2=3 bo’lsin. Natijа -1 bo‘ladigan formulani aniqlang

A) = ЕСЛИ(А1<В1; A2; B2)

B) = ЕСЛИ(А1>В1; B2; A2)

C) = ЕСЛИ(А1>В1; A2; B2)

D) = ЕСЛИ(А1<В1; B2; A2)

23 / 40

23. MS Excel. Berilgan: G1=0, H1=5, I1=−1, J1=2, K1=3. L1 katakka =H1+$I1-$G$1+J$1 formula kiritilgan va shu katak M1, N1, O1, P1 kataklarga nusxalangan. =M1+P1 formulaning qiymatini aniqlang.

A) 11

B) 13

C) 23

D) 12

24 / 40

24. A2 katakchadagi “=A1+$B$4” formulaning F17 katakchaga nusxasi qaysi javobda to‘g‘ri berilgan?

A) =D16+$G$19

B) = F16+$B$4

C) = F16+$G$19

D) = D16+$B$4

25 / 40

25. MS Excel Al = -5, B1=6, B2=4 bo’lsin. Quyidagi formula natijasi -24 bolishi uchun A2 katakka kiritish zarur bo’gan qiymatni aniqlang: =ЕСЛИ(ИЛИ(A1+B2>=A2*B1; A1*B1 >0); A1*B2-B1-A2; A1*B1+B2+A2)

A) 2

B) 4

C) 3

D) 1

26 / 40

26. Agar A1 katakga 1, B1 katakga =A1*3 formula va C1 katakga =7*ABS(A1-B1) formula kiritilgan bo‘lsa C1 katak bo’yicha hisob natijasini aniqlang

A) 8

B) 28

C) 14

D) 4

27 / 40

27. =ЛЕВСИМВ(895;1)*ПСТР(982;2;1) funksiyaning natijasi qanday?

A) 81

B) 16

C) 64

28 / 40

28. MS Excel. A1=50; A2=A1-50; A3=A1+A2 ho'lsin A3 katakdagi qiymatni aniqlang

A) 150

B) 100

C) 50

29 / 40

29. MS Excel. A1=19, B1=38, C1=3, A2=76, B2=95, C2=Avtomexanik berilgan bo’lsa, =ПСТР(C2;5+СЧЁТЕСЛИ(A1:B2;”>75”) ;C1) Formula natijasini toping.

A) xan

B) mex

C) Avto

D) exa

30 / 40

30. MS Excel. Qo'shni bo'lmagan kataklar guruhini tanlashda qaysi klavishni bosib turgan holda sichqoncha chap tugmasi bosiladi?

A) Alt

B) Enter

C) Ctrl

D) Shift

31 / 40

31. MS Excel. Agar A1= -5 va B1= 7 bo‘lsa, u holda quyidagi formulaning qiymatini aniqlang: =СРЗНАЧ(ЗНАК(A1); ЦЕЛОЕ(B1/A1); КОРЕНЬ(ABS(A1*B1- 1)))

A) -3

B) -2

C) 1

D) 6

32 / 40

32. Qaysi qatorda elektron jadvalning kataklar bloki to‘g‘ri belgilangan?

A) A21,D34

B) B6:F11

C) 2

D) E12;G24

33 / 40

33. 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) 5

B) 3

C) 6

D) 9

34 / 40

34. Excel dagi ifodaning natijasini aniqlang. =СЦЕПИТЬ(ПСТР("olimpiada";5;3);"n";ПРАВСИМВ("kino";2))

A) piannino

B) panno

C) pianno

D) piano

35 / 40

35. MS Excel 2003 dasturida “=ОСТАТ(45; 7) + ОСТАТ(15; 3) + ОСТАТ(16; 3)” formulani qiymatini toping.

A) 3

B) 4

C) 1

D) 2

36 / 40

36. H2 katakchada = M10 * E $ 6 /J7 formulasi mavjud. Agar u D9 katakka ko'chirilgan bo'lsa, shu katakdagi formulani aniqlang?

A) = I17 * A $ 6 / F12

B) = I7 * B $ 6 / F14

C) = I17 * A $ 6 / F14

D) = I27 * B $ 6 / F14

37 / 40

37. MS Excel 2003 dasturida A1 katakda 8, A2 katakda 7, A3 katakda 6 qiymati berilgan bo'lsa, =ПРОИЗВЕД(А1:АЗ) formula bo'yicha A4 katakda qanday natija hosil bo'ladi?

A) 336

B) 337

C) 45

D) 338

38 / 40

38. MS Excel: A1=78, B1=156, C1=4, A2=312, B2=390, C2=Agrotexnika berilgan bo’lsa, =ПСТР(C2;1+СЧЁТЕСЛИ(A1:B2; ”>156”); C1) formula qiymatini toping

A) otex

B) exni

C) rote

D) Agrot

39 / 40

39. Ms Excelda dasturning H9 yacheykasiga =C7*$F17 formula yozilgan.Shu formulani J14 katakchasiga ko’chirilsa, formula qanday ko’rinishda bo’ladi?

A) =E12*$F21

B) =E15*$F21

C) =E12*$F22

D) =E11*$F22

40 / 40

40. Excel da A1=7, B1=14, C1=3, A2=28, B2=35, C2=Informatika berilgan bo'lsa,=ПСТP(С2;1 + СЧЁТЕСЛИ(А1 : В2; ">27"); С1) formula qiymatini toping

A) Info

B) nfo

C) rma

D) for

0%

Informatika attestatsiya №5

Ismi familiyangizni kriting!

Author: InfoMaster

Matematika attestatsiya №2

Texnologiya attestatsiya №1

Informatika fanidan attestatsiya savollari №18

Informatika fanidan attestatsiya savollari №17

Informatika fanidan attestatsiya savollari №16

Informatika fanidan attestatsiya savollari №15

Javob qoldiring

Elementlarni Solishtiring