Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Savollari

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

Excel faylining kengaytmasi nima?

a)

.doc

b)

.xls

c)

.ppt

d)

.txt

2.

Excelda formulalar qanday boshlanadi?

a)

+

b)

-

c)

=

d)

Formula

3.

Excelda qaysi funktsiya eng katta qiymatni topadi?

a)

MIN

b)

AVERAGE

c)

MAX

d)

SUM

4.

Excelda qaysi tugma orqali katakchalarni birlashtirish mumkin?

a)

Merge & Center

b)

Bold

c)

Wrap Text

d)

Sort

5.

Excelda "VLOOKUP" funktsiyasi nima qiladi?

a)

O‘rtacha qiymatni hisoblaydi

b)

Ma'lum qiymatni izlaydi

c)

Eng katta qiymatni topadi

d)

Ko'rsatmalar jadvalini yaratadi

6.

Excelda qaysi qisqa tugmalar orqali katakchaning tarkibini tahrirlash mumkin?

a)

Ctrl + P

b)

F2

c)

Ctrl + Z

d)

Alt + Enter

7.

Excelda bir xil katakchalarga o‘xshash ma'lumotlarni qaysi buyruq bilan topish mumkin?

a)

Filter

b)

Find

c)

Sort

d)

Clear

8.

Excelda "SUM" funktsiyasi nima qiladi?

a)

Satrlarni tartiblash

b)

Sonlarni yig'adi

c)

Ma'lumotlarni filtrlash

d)

Matnni o'zgartirish

9.

Excelda qaysi qisqa tugmalar bilan faylni saqlash mumkin?

a)

Ctrl + A

b)

Ctrl + C

c)

Ctrl + S

d)

Ctrl + P

10.

Excelda qaysi buyruq katakchalarni hisoblaydi?

a)

COUNT

b)

IF

c)

LEN

d)

LEFT

11.

Excelda bir xil qiymatlar ustunini avtomatik tarzda qanday ko'rish mumkin?

a)

Conditional Formatting

b)

Insert Chart

c)

Data Validation

d)

Text to Columns

12.

Excelda qaysi formula to'g'ri ifodani hisoblaydi: =A1+A2*A3?

a)

(A1 + A2) * A3

b)

A1 + (A2 * A3)

c)

(A1 + A2) * (A2 + A3)

d)

A1 * (A2 + A3)

13.

Excelda diagramma (chart) yaratish uchun qaysi buyruqdan foydalaniladi?

a)

Insert -> Table

b)

Insert -> Chart

c)

Data -> Sort

d)

View -> Page Layout

14.

Excelda qanday qilib katakchadagi yozuvni aylantirish mumkin?

a)

Text Wrap

b)

Text Orientation

c)

Text Format

d)

Text Highlight

15.

Excelda qaysi formula ma'lumotlar o'rtasidagi o'rtacha qiymatni hisoblaydi?

a)

COUNT

b)

MAX

c)

MIN

d)

AVERAGE

16.

Excelda biror sonning foizini qanday hisoblash mumkin?

a)

SUM(A1:A10)

b)

A110%

c)

A1/100

d)

A12

17.

Excelda satrlarni to'g'ri tartiblash uchun qaysi buyruqdan foydalaniladi?

a)

Insert -> Sort

b)

Data -> Sort

c)

File -> Save

d)

Home -> Paste

18.

Excelda "Freeze Panes" nima uchun ishlatiladi?

a)

Katakchalarni birlashtirish

b)

Ustun va satrlarni muzlatish

c)

Diagramma qo'shish

d)

Jadvalni saqlash

19.

Excelda ma'lumotlarni filtrlash uchun qaysi buyruq ishlatiladi?

a)

Data -> Filter

b)

Data -> Sort

c)

Insert -> Filter

d)

View -> Filter

20.

Excelda qaysi formula eng kichik qiymatni topadi?

a)

MAX

b)

MIN

c)

COUNT

d)

AVERAGE

21.

Excelda "Pivot Table" nima uchun ishlatiladi?

a)

Diagramma yaratish

b)

Katakchalarni birlashtirish

c)

Jadvaldagi ma'lumotlarni tahlil qilish

d)

Ma'lumotlarni tartiblash

22.

Excelda "AutoFill" funksiyasi nima uchun ishlatiladi?

a)

Katakchalarni bo'yash

b)

Matnlarni avtomatik tugatish

c)

Jadvalni nusxalash

d)

Ma'lumotlarni tez to'ldirish

23.

Excelda "IF" funksiyasi nima uchun ishlatiladi?

a)

Katakchalardagi sonlarni qo‘shish

b)

Shartli hisoblashlar

c)

Diagramma yaratish

d)

Ma'lumotlarni filtrlash

24.

Excelda qaysi buyruq orqali ustunlarni birlashtirish mumkin?

a)

Merge & Center

b)

Text to Columns

c)

Filter

d)

Wrap Text

25.

Excelda katakcha ichidagi qiymatlarni formatlash uchun qaysi buyruq ishlatiladi?

a)

Format Cells

b)

Filter

c)

Sort

d)

Insert Chart

Similar Resources on Wayground

Termodinamika va yorug'lik

30 questions

Termodinamika va yorug'lik

quiz

Worksheet

•

University

3-mavzu 4-kurs

20 questions

3-mavzu 4-kurs

quiz

Worksheet

•

University

Test booster

20 questions

Test booster

quiz

Worksheet

•

University

Hadis matnlari

20 questions

Hadis matnlari

quiz

Worksheet

•

University