8 sinf I variant ehm ning to‘rtinchi avlodlarida asosiy element nimadan iborat?

=СЦЕПИТЬ(ЛЕВСИМВ(А2;3);ЗАМЕНИТЬ(В2;4;3;ПРАВСИМВ(ЛЕВСИМВ(Е2;3);2)))

funksiya natijasini aniqlang.

A) Bolyorov     B)Boltayor      C)Bolday      D) Boltayev

13. 0,1,2,3 raqamlaridan iborat bo‘lgan sanoq sistemasi bu…

A) o‘nlik sanoq sistemasi

B) to‘rtlik sanoq sistemasi

C) beshlik sanoq sistemasi

D) ikkilik sanoq sistemasi

14. Amalni bajaring: D13514 - BBD14

A)DA46₁₄ B) C375₁₄ C) 1D46₁₄ D) 12246₁₄

15. F4 yacheykani “=$A1*B3” formula bilan G5 yacheykaga ko‘chiring. Unda nima hosil bo‘ladi?

A) $A3*C4 B) $A2*C5 C) $A2*C4 D) $A$2*C6

16. Elektron jadvalda =СУММ(D2:D4) formulaning qiymati 16 ga teng. Agar =СРЗНАЧ(D1:D4) formulaning qiymati 5 ga teng bo‘lsa D1 katakning qiymati nechaga teng?

A) 4 B) 5 C) 11 D) 21

17. Elektron jadvalda B3 katakka =C$2+$D3+2 formula yozilgan. C3 katakchadagi formulasini toping.

A) =D$1+$E2+2 B) =D$2+$D3+2 C) =D$2+$E2+2 D) =D$2+$D2+2