1) Excel fayllarining standart kengaytmasi qanday? a) docx b) .xlsx c) pptx d) pdf 2) Excelda kataklardagi ma’lumotlarni avtomatik qo‘shish uchun qaysi formula ishlatiladi? a) =SUM(A1:A5) b) =ADD(A1:A5) c) =TOTAL(A1:A5) d) =PLUS(A1:A5) 3) Excel jadvalidagi har bir alohida katak qanday nomlanadi? a) Blok b) Ustun c) yacheyka d) satr 4) Excelda yangi jadval (sheet) qo‘shish uchun qaysi tugma ishlatiladi? a) Ctrl + N b) Insert → New Sheet c) "+" belgisi (pastda, jadval nomlari yonida) d) Shift + S 5) Excelda qanday qilib katakning matnini boshqa katakka ko‘chirish mumkin? a) Katakni tanlab, Ctrl + C → boshqa katakka Ctrl + V b) Katakni tanlab, Delete tugmasini bosish c) Katakni tanlab, Enter tugmasini bosish d) Katakni tanlab, Ctrl + S bosish 6) Autosum funksiyasi nima qiladi? a) Sonlarni avtomatik sanaydi b) Sonlarni avtomatik qo‘shadi c) Sonlarni o‘chiradi d) Sonlarni nusxalaydi 7) Excelda sonlarning eng katta qiymatini topish uchun qaysi formula ishlatiladi? a) =MIN(A1:A10) b) =LARGE(A1:A10,1) c) =MAX(A1:A10) d) =BIGGEST(A1:A10) 8) Excelda o‘rtacha qiymatni hisoblash uchun qaysi formula ishlatiladi? a) =MEAN(A1:A10) b) =MEDIAN(A1:A10) c) =AVERAGE(A1:A10) d) =MID(A1:A10) 9) Excelda darajaga ko‘tarish uchun qaysi funksiya ishlatiladi? a) =EXP(A1,3) b) =POWER(A1,3) c) =RAISE(A1,3) d) =POW(A1,3) 10) Excelda butun sonning moduli (mutlaq qiymati) qaysi formula bilan topiladi? a) =ABS(A1) b) =MOD(A1) c) =INT(A1) d) =ROUND(A1) 11) Excelda diapazondagi eng katta va eng kichik sonlar orasidagi farqni hisoblash uchun qaysi formula ishlatiladi? a) =RANGE(A1:A10) b) =MAX(A1:A10) - MIN(A1:A10) c) =GAP(A1:A10) d) D) =DIFF(A1:A10) 12) Excelda sonning kvadrat ildizini topish uchun qaysi formula ishlatiladi? a) =ROOT(A1) b) =SQRT(A1) c) =SQUARE(A1) d) =POWER(A1,2)

Excel testi.

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?