Informatika-8

Informatika-8.
1. Elekton jadval nomi keltirilgan javobni aniqlang.

A) MS Word B) Internet Explorer C) Bloknot

D) MS Excel

2. MS excelda hosil qilingan hujjat fayli kengaytmasini aniqlang.

A) .doc B) . rtf C) .xls D) . arj

3. Birinchi elektron jadval nomi keltirilgan javobni aniqlang.

A) MS Excel B) Simphoniy C) Visicalc

D) SuperCalc

4. MS Excel dasturining dastlabki naqli qachon ishlab chiqilgan?

A) 1985 B) 1994 C) 1995 D) 2003

5. Excelda formula yozish uchun avval qaysi belgi yoziladi?

A) $ belgisi B) # belgisi C) = belgisi D) ! belgisi

6. Elektron jadvalada A1:B3 katakchalar bloki belgilangan. Unda nechta katakcha bor?

A) 4 B) 6 C) 5 D) 3

7. Elektron jadvalda ustunlar qanday nomlanadi?

A) A, B, C, …, Z, AA, …

B) 1, 2, 3, … C) ixtiyoriy D) o`ngdan chapga

8. Elektron jadvalda satr tartib raqami oldiga qo`yilgan ”$” belgisi nimani anglatadi?

A) pul formatini B) nisbiy murojaatni C) absolyut murojaatni D) formula boshlanishini

9. Elektron jadvalda kiritilayotgan son katakcha kengligiga sig`masa, u holda katakchada qanday belgi hosil bo`ladi?

A) ”#######” B) #ИМЯ? C) #ЗНАЧ! D) !!!!!

10. Elektron jadvalada B8:D12 katakchalar bloki belgilangan. Unda nechta katakcha bor?

A) 18 B) 21 C) 15 D) 24

11. Excelda (A1:B3; A7:B4) blokda nechta katakcha bor?

A) 4 B) 8 C) 9 D) 14

12. Quyidagilardan qaysi biri MS Excelda katakcha nomi bo`lishi mumkin?

A) AZ5 B) ISM C) MS D) barchasi

13. Quyidagilardan qaysi biri MS Excelda katakcha nomi bo`lishi mumkin?

A) AZ5 B) Nom C) Excel D) barchasi

14. Elektron jadvalda murojaat — bu:

A) ustun va satr tartib raqami B) matemtik amallar, sonlar va formulalar majmui

C) EJ ning ustun va satrlari kesishgan joy

D) katakcha adresini ko`rsatish usuli

15. Excelda absolyut murojaat qaysi javobda to`gri ko`rsatilgan?

A) =$BMA$5 B) =$AZ$5 C) =$A$5

D) B va C javoblar to`g`ri

16. Excelda D2 katakchadagi “=$A1*B$3” formulaning E3 katakchaga nusxasini toping.

A) =$A1*B$3 B) =$B1*C4 C) =$A2*C$3

D) =$A2*B$4

17. Excelda F4 katakchadagi “=$A1*B3” formulaning G5 katakchaga nusxasi toping.

A) =$A1*B3 B) =$B1*C4 C) =$A2*C4

D) =$A2*B4

18. Excelda Absolyut murojaat qaysi javobda to`g`ri berilgan?

A) =$MB$5 B) =$ZA$5 C) =$AT$1

D) hammasida

19. Excelda B9 katakchadagi “=$A1*B$3” formulaning C10 katakchaga nusxasini toping.

A) =$A1*B$3 B) =$B1*C4 C) =$A2*C$3

D) =$A2*B$4

20. Excelda A13 katakchadagi “=$A2*B$3” formulaning B14 katakchaga nusxasini toping.

A) =$A2*B$3 B) =$B2*C4 C) =$A3*C$3

D) =$A3*B$4

21. Rim raqamlarida 2008 soni qanday yoziladi?

A) MM00VIII B)MMVIII C) LLVIII D) CCVIII

12. Ayirishni bajaring: 1010_2­ - 101₂

A) 909₂ B) 101₂ C) 11₂ D) 110₂

23. O`nlik sanoq sistemasidagi 15 sonini ikkilik sanoq sistemasida yozing.

A)1011₂ B) 1111₂ C) 1101₂ D) 1001₂