Sanoq sistema bu …

Excel: A1 yacheykaga 5, B1 yacheykaga 3, C1 yacheykaga 8, D1 yacheykaga 4, E1 yacheykaga =(A1+B1+C1)/D1 formula kiritilsa uning qiymatini toping.

1. 
   4
   
2. 
   5
   
3. 
   3
   
4. 
   2
   
5. 
   6
   

ANSWER: A


Elektron jadvalda A1 yacheykaga 10 soni, B1 yacheykaga =A1/2 formula, C1 yacheykaga =SUMM(A1:B1)*2 formula kiritilgan. C1 yacheyka qiymatini aniqlang.

1. 
   30
   
2. 
   150
   
3. 
   10
   
4. 
   75
   
5. 
   60
   

ANSWER: A


Elektron jadvalda A1:B3 yacheykalar ajratilgan. Ajratilgan yacheykalar soni nechta?

1. 
   6
   
2. 
   7
   
3. 
   5
   
4. 
   4
   
5. 
   8
   

ANSWER: A


Elektron jadvalda A1:A5 yacheykalar ajratilgan. Ajratilgan yacheykalar soni nechta?

1. 
   5
   
2. 
   7
   
3. 
   6
   
4. 
   4
   
5. 
   3
   

ANSWER: A


Microsoft Office EXCEL dasturiy muhitida yangi ishchi varaq yaratish uchun qaysi tugmalarni birgalikda bosish kerak?

1. 
   SHIFT+F11
   
2. 
   CTRL+N
   
3. 
   CTRL+S
   
4. 
   SHIFT+CTRL+N
   
5. 
   SHIFT+F12
   

ANSWER: A


Microsoft Office EXCEL dasturiy muhitida yacheykani ichida keyingi satrga o‘tish uchun qaysi tugma yoki tugmalar birgalikda bosiladi?

1. 
   ALT+ENTER;
   
2. 
   ENTER;
   
3. 
   CTRL+ENTER;
   
4. 
   SHIFT+ENTER;
   
5. 
   ALT + SHIFT
   

ANSWER: A


Yacheykadagi ma’lumotlarni taxrirlash uchun qaysi tugmani bosish kerak?

1. 
   F2;
   
2. 
   F12;
   
3. 
   F1;
   
4. 
   F11;
   
5. 
   F4;
   

ANSWER: A