Informatika fanidan test savollari (1-kurs 1-oraliq nazorat)

INFORMATIKA FANIDAN TEST SAVOLLARI
(1-KURS 1-ORALIQ NAZORAT)
1-VARIANT

1. 
   MS Excell 2010 dasturida fayli nomining kengaytmasi qanday ifodalanishi mumkin?
   

A) .xls B) .doc C) .rgn D) .xlsx

2. 
   MS Excell 2010 dasturining joriy “лист”ida nechta satr mavjud?
   

A) 65526 B) 65436 C) 65556 D)1048576

3. 
   MS Excell 2010 dasturining joriy “лист”ida nechta ustun mavjud?
   

A) 255 B) 253 C) 16348 D) 254

4. 
   MS Excell 2010 dasturida oxiqgi ustun nomi qanday nomlanadi?
   

A) Z B) A-Z C) XFD D) XYZ

5. 
   Excell 2010 da faylga avtomat nom berilganda qanday nom bilan saqlanadi?
   

A) Fayl1 B) Книга1 C) Книга D) Barcha javoblar to’g’ri

6. 
   MS Excell 2010 dasturida joriy “лист” dan boshqa “лист” kataklarida murojaat to’g’ri berilgan javobni ko’rsating.
   

A) Лист nomi//katak adresi B) Лист nomi / katak adresi
C) Лист nomi.katak adresi D) Лист nomi!katak adresi

7. 
   Excell dasturi qaysi kompaniya tomonidan ishlab chiqilgan?
   

A) LG B) Microsoft C) Samsung D) Asus

8. 
   Excell dasturi ishga tushirilganda u shartli qaysi nomi bilan hujjat hosil qilishni taklif etadi?
   

A) Книга1 B) Документ1 C) xls D) doc

9. 
   Qaysi javobda elektron jadvallar murojaat turlari berilgan?
   

A) nisbiy , absolut va aralash murojaat B) nisbiy va tezkor murojaat
C) teskari va absolyut murojaat D) to’g’ri javob berilmagan

10. 
    MS Excell 2010 dasturida C5:E8 maydon diapazonida necha katakcha qamrab olingan?
    

A) 40 B) 8 C) 12 D) 15

11. 
    Elektron jadvalda A1:E20 maydon diapazonida necha katakcha qamrab olingan??
    

A) 60 B) 80 C) 100 D) 200

12. 
    MS Excell 2010 dasturida A21=16, B16=4 bo’lsa, “=A21/B16-B16*B16” formulani qiymatini toping.
    

A) 12 B) -12 C) 0 D) 16

13. 
    MS Excell 2003 dasturida D2 katakchadagi “=$A1*B3” formulaning E3 katakchaga nusxasini toping.
    

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

14. 
    Microsoft Excell dasturining C4 yacheykasida =B2*$C$3 formula yozilgan. Shu formula D6 yacheykasiga ko’chirilsa, formula qanday ko’rinishda bo’ladi?
    

A) =E4*$5C B) =B4*$C$3 C) =B4*$D$5 D) =C4*$C$3

15. 
    MS Excell 2003 dasturida L11 katakchadagi “=D6*$C3” ko’paytmaning M14 katakchaga nusxasini toping.
    

A) =E6*$C3 B) =$D6*$C6 C) =E9*$C3 D) =E9*$C6

16. 
    MS Excell jadvalining asosiy elementi bu – …
    

A) jadval B) ustun C) satr D) yacheyka

17. 
    Elektron jadvalda ustunlar qanday belgilanadi?
    

A) ixtyoriy B) A, B, C,…, AA, …, C) 1, 2, 3, … D) o’ngdan chapga

18. 
    MS Excell 2010 dasturida absolyut murojaat qo’llanilgan formulani ko’rsating.
    

A) D16+$B$6 B) =DD16$+B6$ C) =D16+$B$6 D) =D16+B6

19. 
    MS Excell 2003 dasturida D2 katakchadagi “=$A1*B3” formulaning E4 katakchaga nusxasini toping.
    

A) =$B1*C4 B) =$A3*C5 C) =$A1*B3 D) =$A2*B4

20. 
    MS Excell da to’g’ri yo’zilgan formulani ko’rsating.
    

A) =AA1+4*BC5 B) =A1+4*B5 C) =AA1+5BC5 D) =AV1+4BR

21. 
    MS Excell dasturida A1=50; A2=A1-50; A3=A1+A2 bo’lsa, A3 yacheykadagi qiymatini aniqlang.
    

A) 0 B) 100 C) 50 D) 150

22. 
    MS Excell 2003 elektron jadvalida B3:E5 kataklar bloki tanlangan. Bu diapazonga nechta katak kiradi?
    

A) 9 ta B) 6 ta C) 12 ta D) 8 ta

23. 
    MS Excell dasturida absolyut murojaatlarni ifodalashda qanday belgi ishlatiladi?
    

A) # B) ! C) $ D) @

24. 
    Elektron jadvaldagi murojaat(ssylka) – bu:
    

A) satr nomeri va ustun nomeri
B) matematik operatorlar jamlanmasi, raqam, funktsiya
C) satr va ustunlarning kesishmasini aniqlaydigan yacheyka
D) yacheykalardagi formulani nusxalaganda undagi bor ma’lumotlar o’zgaradi

25. 
    MS Excell dasturida biror hujjat bilan ishlayotganda ikkinchi hujjatni ochish mumkinmi?
    

A) Ha B) Yo’q C) To’g’ri javob yo’q D) Joriy hujjatni yopgandan so’ng mumkin.