A)2 B)3 C)4 D)yo’q
12. MS Excel 2003 dasturida berilgan formulaning natijasini aniqlang
=ЦЕЛОЕ(-6,985)+МАКС(15;30;3)
A) 25 B) 23 C) 22 D )24
13. MS Excel 2003 dasturida A1=sinf so’zi kiritilgan, quyidagi formulaning natijasini toping. =CPЗHAЧ(KOPEH(16);ДЛСТР(“A1”))
A) 6 B) 3 C) 4 D) 5
14. MS Excell 2003 daturida berilgan =ИЛИ(СТЕПЕН(3;4)>80;MAС(15;10;30)<30) formulaning natijasini aniqlang.
А) ЛОЖЬ В) 0 С) ИСТИНА D) 1
15. MS Excel. Al=7, A2=-7, Bl=-19, В2=4, C1=Informatika, C2=Universitet,
D1 =ABS($A1+B1) + Длстрь(C1) berilgan. Agar D1 katakni D2 katakka nusxalansa, D1 va D2 kataklarida hosil bo'ladigan sonlar yig'indisini toping.
A)45 B)34 C)37 D) 42
16. MS Excelda =OCTAT(2019;9)+OCTAT(15;3)+OCTAT(2018;3)
A)1 B)4 С)5 D)3
17. A1=5; A2=4; A3=6; B1=4; B2=7; B3=2 bo’lsa formulaning natijasi 21 bo’lichi uchun ? va ?? belgilarning o’rniga qo’yish mumkin bo’lgan funksiyalar to’g’ri berilgan javobni aniqlang.
Do'stlaringiz bilan baham: |