Topgan xatolani qo`ldan kegancha to`g`illadm from Neurosurgeon


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


Download 211.7 Kb.
bet45/64
Sana25.11.2021
Hajmi211.7 Kb.
#177172
1   ...   41   42   43   44   45   46   47   48   ...   64
Bog'liq
Informatika Moodle testlar Imtihon uchun

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

  1. Ctrl+Shift

  2. 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

  1. Alt+Tab

  2. Shift+F3



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

A. 256

  1. 121

  2. 81

  3. 225

  4. 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


Download 211.7 Kb.

Do'stlaringiz bilan baham:
1   ...   41   42   43   44   45   46   47   48   ...   64




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling