=СЦЕПИТЬ(ЛЕВСИМВ(А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)DA4614 B) C37514 C) 1D4614 D) 1224614
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
Do'stlaringiz bilan baham: |