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
MS Excel 2003 dasturida Al=12, B3=24 bo‘lsa, “= A1 * B3 + B3^2” natijani toping. A) 854 B) 754 *C) 864 D) 624
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
MS Excel 2003 dasturida (A1:B3;A2;B4) maydon diapazonida nechta katakcha qamrab olingan? A) 4 B) 8 C) 12 *D) 7
MS Excel 2003 dasturida E9:B6 maydon diapazonida necha katakcha qamrab olingan? A) 20 *B) 16 C)12 D)15
MS Excel 2003 dasturida A21=16, B16=-4 bo‘lsa “=A21/B16*B16” formulaning qiymatini toping. A) 12 B)-12 C)-16 *D)16
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
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
Microsoft Excel jadvallaridagi katakchalarga (ularning adresini o‘zgartirmagan holda) absolyut murojaat qilish uchun qaysi belgidan foydalaniladi?
A) = B) # *C) $ D)!
Ms Excel dasturida formula qaysi belgi bilan boshlanadi?
A) funksiya nomi *B) = C) () D) +
Ms Excel dasturida A3 katakchaga yozilgan =И(-2>0;2-4>3) funksiya qanday qiymat qaytaradi?
