10-sinf o’quvchilari uchun ms excel 2010 da amallar va formulalar bobiga doir
Download 18.59 Kb.
|
10-sinf I-chorak test
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? Округл 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
Download 18.59 Kb. Do'stlaringiz bilan baham: |
Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling
ma'muriyatiga murojaat qiling