Boshsahifa

125# Excel dasturida Лист1dan Лист2ga to’g’ri bog’lanishni tanlang.

1. 
   =Лист2-A1
   
2. 
   =Лист2:A1
   
3. 
   =Лист2!A1
   
4. 
   =Лист2/A1
   

126# Excel dasturida keltirilgan to’g’ri formulalarni tanlang.

1. 
   =A1+B1^2
   
2. 
   =A1(B1+D1)
   
3. 
   =Лист2:A1+Лист1:A1
   
4. 
   =A1:B1
   
5. 
   =Лист2!A1+Лист1!A1
   
6. 
   =A1*B1+C1/D1
   
7. 
   =(A1+B1+C1)/D1
   
8. 
   =(A1+B1+C1):D1
   

127# Excel dasturida =[Книга2]Лист1!$A$1+[Книга3]Лист1!$A$1 formula qanday hisoblashni amalga oshiradi?

1. 
   ikki ishchi kitobdagi sonlarni qo’shadi
   
2. 
   ikki listdagi sonlarni qo’shadi
   
3. 
   listdagi ikki sonni bir-biriga qo’shadi
   
4. 
   ikki ishchi kitobni bir-biriga qo’shadi
   

128# Excel dasturida qator va ustunlar orasiga qator va ustun qo’shish uchun qaysi klavishalar kombinatsiyasidan foydalaniladi?

1. 
   Ctrl++
   
2. 
   Ctrl+-
   

C. Ctrl+Enter

4. 
   Ctrl+Shift
   
5. 
   Ctrl+Esc
   

129# Excel dasturida qator va ustunlar orasidan qator va ustunni o’chishish uchun qaysi klavishalar kombinatsiyasidan foydalaniladi?

1. 
   Ctrl+/
   
2. 
   Ctrl+-
   

C. Ctrl+Alt

4. 
   Alt+Tab
   
5. 
   Shift+F3
   

130# Excel dasturida quyidagi formula natijasi nechaga teng bo’ladi? =(5+26/13+3*2)^2

A. 256

2. 
   121
   
3. 
   81
   
4. 
   225
   
5. 
   1024
   

131# Excel dasturida A1 yacheykada 10 soni, B1 yacheykada 20 soni kiritilgan C1 yacheykaga kiritilgan quyidagi formula natijasi nechaga teng bo’ladi? =(2*A1+B1/2+3*2)/2

1. 
   36
   
2. 
   15
   
3. 
   18
   
4. 
   25
   
5. 
   28
   

132# Excel dasturida A1 yacheykada 100 soni, B1 yacheykada 1000 soni, C1 yacheykada 10000 kiritilgan, D1 yacheykaga kiritilgan quyidagi formula natijasi nechaga teng bo’ladi? =(A1/2+B1/2+C1/100)/2

1. 
   525
   
2. 
   1025
   
3. 
   325
   
4. 
   255
   
5. 
   15555
   

133# Excel dasturida A1 yacheykada 25 soni, B1 yacheykada 16 soni kiritilgan C1 yacheykada 36, D1 yacheykaga 49 soni kiritilgan, E1 yacheykaga kiritilgan quyidagi