10-sinf o’quvchilari uchun ms excel 2010 da amallar va formulalar bobiga doir

10-sinf o’quvchilari uchun MS EXCEL 2010 da amallar va formulalar bobiga doir
TEST SAVOLLARI
1.Excelda A1=5, B3=4 bo’lsa, =A1*B3+B3^2 ning javobi nechaga teng?
A) 28 B) 36 C) 25 D) formulada xato bor

2. Excelda A1=5, B3=4 bo’lsa,E5 katakchаdagi =CУММ(4*A1;B3*A1; 9; 14) natijasi necha?

A) 15,75 B) 20 C) 63 D) formulada xato bor

3. Excelda A1=4, B3=3 bo’lsa, =B3^2+A1*B3 ning javobi nechaga teng?

A) 21 B)36 C) 25 D) Formulada xato bor

4.Excelda A1=3, B3=2 bo’lsa, =A1^B3 ning javobi nechaga teng?

A) 29 B) 9 C) 625 D) formulada xato bor
5. Excelda qanday funksiya yordamida kataklardagi ma’lumotlarni yaxlitlash mumkin?

1. 
   Округл B.СТЕПЕНЬ C. СУММ D. ЕСЛИ
   

6. =2*3/(4*5) formulaning qiymatini hisoblang.
A) 0,3 B) 0,45 C) 0,15 D) 7,5
7. Excelda katakchaga =5% degan formula kiritildi. Uning qiymatini ko‘rsating.
A) 5 B) 1 C) 0,5 D) 0,05
8.Excelda formula qaysi belgi bilan boshlanadi?
A) = B) : C) –> D) f:
9. D2 katakchadagi =a2*(1-b2)/c2 formula d5 katakchaga nusxalansa, u qanday ko‘rinishda bo‘ladi?
A) =a5*(1-b5)/c5 B) =a5*(1-b2)/c2 C) =a2*(1-b5)/c5 D) =a2*(1-b2)/c2
10. A1 ga –5; B1 ga =Esli(A1>0;a1;-a1) kiritilgan. B1 katakchada qanday qiymat paydo bo‘ladi?
A) -5 B) 5 C) –a1 D) a1
11.=koren(36) ning qiymatini toping.
A) 1 B) 3 C) 6 D) –36
12.=Stepen(3; 2) ning qiymati toping.
A) 6 B) 8 C) 9 D) 12
13.=Summ(2; 1; –3; 4) ning qiymatini toping.
A) 1 B) 2 C) 3 D) 4
14. Funksiya chaqirilganda uning nomi noto‘g‘ri yozilsa,
nima bo‘ladi?
A) uning qiymati o‘rniga #IMYA? degan yozuv paydo bo‘ladi
B) uning qiymati o‘rniga #OSHIBKA? degan yozuv paydo bo‘ladi
C) xato haqida ogohlantiruvchi xabar alohida darchada paydo bo‘ladi
D) funksiyalar haqidagi ko‘mak tizimi ishga tushadi
15. Excelda formulalarning qaysi turi mavjud emas?
A) matn B) sonli C) sana D) statistik
16. =5/2/(10/7) formulaning qiymatini hisoblang.
A) 3,5 B) 1,75 C) 1,6666 D) 2,25
17. =2^(3+1) formulaning qiymatini hisoblang.
A) 16 B) 9 C) 10 D) 8
18. =16^(1/4) formulaning qiymatini hisoblang.
A) 2 B) 4 C) 64 D) 1
19. =sin(a2)+5 formuladagi funksiya argumentini ko‘rsating.
A) a2 B) sin C) 5 D) ()
20. Yig‘indini hisoblovchi funksiyaning nomi qaysi javobda to‘g‘ri ko‘rsatilgan?
A) summa B) summ C) summa D) sum
21. =exp(0) ning qiymatini toping.
A) 0 B) 1 C) 10 D) 2,71
22. A1 ga 5; B1 ga =Esli(A1>0;a1;-a1) kiritilgan. B1 katakchada qanday qiymat paydo bo‘ladi?
A) -5 B) 5 C) –a1 D) a1
23.Log(16, 4)ning qiymatini toping.
A) 2 B) 4 C) 16 D) 64
24.log10(100) ning qiymatini toping.
A) 1 B) 10 C) 2 D) 1000
25. =log10(0,001) ning qiymatini toping.
A) 1 B) 0,01 C) -3 D) -1

TEST SAVOLLARIGA JAVOBLAR VARAQASI

savol	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25
Javob	B	C	A	B	A	A	D	A	A	B	C	C	D	A	D	B	A	A	C	B	B	B	A	C	C