"Книга 1" *B "Документ

A) 63 B) 50 C) 32 *D) 47

5. 
   MS Excel 2003 dasturida A21=-16, B16=4 bo‘lsa “=A21/B16-B16*B16” formulaning natijasini toping. A) 16 B) -12 *C) -20 D) 12
   
6. 
   MS Excel 2003 dasturida Al=12, B3=24 bo‘lsa, “= A1 * B3 + B3^2” natijani toping. A) 854 B) 754 *C) 864 D) 624
   
7. 
   MS Excel 2003 dasturida satr qo‘shish amali to‘g‘ri yozilgan qatorni ko‘rsating.
   

A) Правка menyusidan Строки buyrug‘i B) Данные menyusidan Строки buyrug‘i
*C) Вставка menyusidan Строки buyrug‘i D) Формат menyusidan Строки buyrug‘i

8. 
   MS Excel 2003 dasturida (A1:B3;A2;B4) maydon diapazonida nechta katakcha qamrab olingan? A) 4 B) 8 C) 12 *D) 7
   
9. 
   MS Excel 2003 dasturida E9:B6 maydon diapazonida necha katakcha qamrab olingan? A) 20 *B) 16 C)12 D)15
   
10. 
    MS Excel 2003 dasturida A21=16, B16=-4 bo‘lsa “=A21/B16*B16” formulaning qiymatini toping. A) 12 B)-12 C)-16 *D)16
    
11. 
    MS Excel 2003 dasturida D2 katakchadagi “=$A1*B3”formulaning E3 katakchaga nusxasini toping.
    

A) =$B1*C4 *B)=$A2*C4 C)=$A1*B3 D)=$A2*B4

12. 
    MS Excel 2003 dasturida D12= 4, E12= 6 bo‘lsa, F15 katakchadagi “=СУММ(4*E12;D12*2;5:10)” natijasi nechaga teng bo‘lishini aniqlang.
    

A) 63 B)47 C)50 *D)32

13. 
    Microsoft Excelning A1 yacheykasida 3, B1 yacheykasida 8 soni turibdi.
    

=Если(И(A1>3;(A1+B1)<12);18;24) formula yozilgan yacheykada qanday natija hosil bo‘ladi? *A) 24 B)18 C)21 D)12

14. 
    Microsoft Excel jadvallaridagi katakchalarga (ularning adresini o‘zgartirmagan holda) absolyut murojaat qilish uchun qaysi belgidan foydalaniladi?
    

A) = B) # *C) $ D)!

15. 
    Ms Excel dasturida formula qaysi belgi bilan boshlanadi?
    

A) funksiya nomi *B) = C) () D) +

16. 
    Ms Excel dasturida A3 katakchaga yozilgan =И(-2>0;2-4>3) funksiya qanday qiymat qaytaradi?