|
-mavzu: MS Excel dasturiga oid test savollari
|
| bet | 26/31 | | Sana | 06.01.2024 | | Hajmi | 148,5 Kb. | | #131208 |
Bog'liq 1-mavzu Xavfsizlik va sanitar gegenik talablar 2-www.fayllar.org
1. MS Excelning C2 katakchasidagi formuladagi amallarni ketma-ket bajarib natijani aniqlang:
A1=5, B3=4, “=ABS(A1*B3-25)+ КОРЕНЬ(B3^2)”.
A) 6 B) 7 C) 8 D) 9
2. MS Excelning C2 katakchasidagi formuladagi amallarni ketma-ket bajarib natijani aniqlang:
A1=3, B3=2, “=СТЕПЕНЬ(A1; B3)+A1*B3-B3^2”.
A) 5 B) 7 C) 9 D) 11
3. MS Excelning C2 katakchasidagi formuladagi amallarni ketma-ket bajarib natijani aniqlang:
A1=7, B3=3, “=B3*B3 +ЦЕЛОЕ(A1/B3)- СТЕПЕНЬ (A1; B3-1)”.
A) 36 B) -36 C) -38 D) 38
4. Microsoft Office Excel dasturiy muhitida yangi ishchi varaq yaratish uchun qaysi tugma-larni birgalikda bosish kerak?
A) CTRL+N B) CTRL+S C) SHIFT+CTRL+N D) SHIFT+F11
5. Microsoft Office Excel dasturiy muhitida yacheykani ichida keyingi satrga o’tish uchun qaysi tugma yoki tugmalar birgalikda bosiladi?
A) ENTER; B) CTRL+ENTER; C) ALT+ENTER; D) SHIFT+ENTER;
6. Microsoft Office Excel dasturiy muhitida yacheykadagi belgilar o’rnida “решётка” (# # # # #) paydo bo’lsa bu nimadan dalolat beradi?
A) Sonlar ustun kengligiga sig’magan hisoblanadi;
B) Sonlar qator balandligiga sig’magan hisoblanadi;
C) Tanlangan formatdagi sonlar ustun kengligiga sig’magan hisoblanadi;
D) Tanlangan formatdagi sonlar qator balandligiga sig’magan hisoblanadi;
7. D1 yacheykaga =ЕСЛИ(КОРЕНЬ(C1)>8,A1+C1,B1+C1) formula kiritilsa uning qiymatini toping.
A) 26 B) 30 C) 31 D) 32
8. Yacheykadagi sonli qiymatlarni, matnlarni yoki formulalarni o’chirish uchun qaysi amallarni bajarish kerak?
A) Yacheykani faollashtirib, DELETE tugmasini bosish kerak bo’ladi;
B) Yacheykani faollashtirib, ENTER tugmasini bosish kerak bo’ladi;
C) Yacheykani faollashtirib, BACKCASE tugmasini bosish kerak bo’ladi;
D) To’g’ri javob A va C
|
| |
