Belgilangan fayl nushasini klaviaturaning qaysi tugmalarini baravar bosish yordamida ko’chirib olish mumkin?

A) ЛОЖЬ B) ИСТИНА C) 1 D) 4

19. 
    Ms Excel dasturidagi A2 katakka kiritilgan sonning manfiy, musbat yoki nolga tengligini aniqlab, uni B2 katakka yozish uchun B2 katakka qanday formula kiritish lozim?
    

A) =ЕСЛИ(A2<0;“Manfiy”;A2>0;“Musbat”;A2=0;“Nolga teng”)

B) =ЕСЛИ(A2<0;“Manfiy”;ЕСЛИ(A2>0;“Musbat”;“Nolga teng”))

C) =ЕСЛИ(A2<0;“Manfiy”;ИЛИ(A2>0;“Musbat”;“Nolga teng”))

D) =ЕСЛИ(A2<0;“Manfiy”;“Musbat”; ИЛИ(A2=0;“Nolga teng”))

20. 
    Ms Excel 2003 dasturida yozilgan “=КОРЕНЬ(ABS(-36))*ЗНАК(28)+ОСТАТ(32;13)” formulaning qiymati nechaga teng?
    

A) 174 B) 18 C) 12 D) 31

21. 
    Ms Excel 2003 dasturida ushbu formula yozilgan. =ЕСЛИ(ИЛИ(A1>6;A2<4);3*B1+4*B2; 3*B1-4*B2). Agar A1 yacheykada 12, A2 yacheykada 6, B1 yacheykada 5 va B2 yacheykada 4 yozilgan bo‘lsa natija qanday bo‘ladi?
    

A) 1 B) 12 C) 31 D) 60

22. 
    Ms Excel 2003 dasturining A1 yacheykasida 3, B1 yacheykasida 8 soni turibdi. =ЕСЛИ(ИЛИ(A1>3;(A1- B1)<12);18; 24) formula yozilgan bo‘lsa natija qanday bo‘ladi?