Informatika fanidan

ELEKTRON JADVALLAR

165. 
     Birinchi electron jadvallar dasturini ko’rsating?
     
     1. 
        VisiCalc
        
166. 
     Birinchi electron jadvallar dastur qachon yaratilgan?
     
     1. 
        1979
        
167. 
     Microsoft Excel dasturi qachon yaratilgan?
     
     1. 
        1994
        
168. 
     MS Excel dastur ish maydoni nechta satrlardan iborat jadvaldan buladi?
     
     1. 
        65 536
        
169. 
     MS Excel dastur ish maydoni nechta ustunlardan iborat jadvaldan buladi?
     
     1. 
        256
        
170. 
     MS Excel dasturida yaratilgan fayl qanday nomlanadi?
     
     1. 
        Книга
        
171. 
     MS Excel dasturida ishchi varoqlar qanday nomlanadi?
     
     1. 
        Лист 172. MS Excel dasturida C2:D5 ma’nosi?
        

a. C2 yacheykadan D5 gacha yacheykalar turtburchak bloki 173. MS Excel dasturida C2;D5 ma’nosi?
a. C2 xamda D5 yacheykalar

174. 
     MS Excel dasturida yangi ishchi varoq qushish uchun nima qilish kerak?
     
     1. 
        Sichqoncha bilan Вставка menyusi ichidan Лист buyrugini tanlaymiz.
        
175. 
     MS Excel dasturida yangi ishchivaroq nomini o’zgartirish uchun nima qilish kerak?
     
     1. 
        Sichqoncha bilan varoq belgisiga o’ng tugmasini bosib xosil bulgan kontekst menyusining Переименовать buyrugini tanlaymiz. 176. MS Excel dasturida yacheyka xossalarini ko’rish oynasini xosil qilish tugmalari?
        

a. Klaviaturadan CTRL+1!.

177. 
     MS Excel dasturida bitta yacheykada yangi satrga majburiy o’tish tugmalari?
     
     1. 
        Klaviaturadan ALT+Enter.
        
178. 
     MS Excel dasturida formula nusxalashda $ belgisi ma’nosi nima?
     
     1. 
        Faqat shu ustun, satr, yoki satr va ustunlarga murojaat qilish
        
179. 
     MS Excel dasturida nisbiy muroajjaatni absolyut murojaatga aylantirish uchun nima qilish kerak?
     
     1. 
        Ustun va satrlar nomlaridan oldin $ belgini quyish yoki klaviaturadan F4 klavishani bosish qerak
        
180. 
     MS Excel dasturida boshqa fayldagi ishchi varoqda joylashgan yacheykaga tug’ri yozilgan murojaat?
     
     1. 
        [Xisobot.xls] Лист 1!A4
        
181. 
     MS Excel dasturida ishlatish mumkin emas bulgan arifmetik amalni ko’rsating?
     
     1. 
        % (foiz hisoblash) , ^ (darajaga ko’tarish) , * , / ,
        

+ , -

177. 
     MS Excel dasturida nechta formulalar mavjud?
     
     1. 
        400 dan ortiq
        
178. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СЧЕТ(A1:A5) to’g’ri ko’rsating?
     
     1. 
        А1 dan А5 gacha yacheykalar ichida nechta
        

raqamlar

177. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СУММ(A1;A5) to’g’ri ko’rsating?
     
     1. 
        А1 ва А5 yacheykalar summasini
        
178. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СРЗНАЧ(A1;A5) to’g’ri ko’rsating?
     
     1. 
        А1 ва А5 yacheykalar o’rta arifmetik sonini
        
179. 
     MS Excel dasturida ushbu formula nima xisoblaydi =МАКС(A1;A5) to’g’ri ko’rsating?
     
     1. 
        А1 ва А5 yacheykalar ichida eng kattasini
        
180. 
     MS Excel dasturida ushbu formula nima xisoblaydi =МИН(A1;A5) to’g’ri ko’rsating?
     
     1. 
        А1 ва А5 yacheykalar ichida eng kichik
        
181. 
     MS Excel dasturida ushbu formula nima xisoblaydi =КОРЕНЬ(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani kvadrat ildizini xisoblaydi
        
182. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ЗНАК(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani ishorasini xisoblaydi
        
183. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ЦЕЛОЕ(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani yaxlitlash
        
184. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ABS(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheyka modulini xisoblaydi
        
185. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СТЕПЕНЬ(A1;А5) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani А5 darajasiga kutarish
        
186. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ОСТАТОК(A1;А5) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani A5 bulinish qoldigini aniqlash
        
187. 
     MS Excel dasturida ushbu formula nima xisoblaydi =И(A1;А5) to’g’ri ko’rsating?
     
     1. 
        А1 va A5 yacheykalarni mantiqiy ko’paytirish amali
        
188. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ИЛИ(A1;А5) to’g’ri ko’rsating?
     
     1. 
        А1 va A5 yacheykalarni mantiqiy qu’shish amali
        
189. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ДЛСТР(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykada xarflar sonini aniqlash
        
190. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ЗНАЧЕН(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani matnli xolatga o’tqazish
        
191. 
     MS Excel dasturida ushbu formula nima xisoblaydi =SIN(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheyka sinusini aniqlash
        
192. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ATAN(A1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheyka arctangensini aniqlash
        
193. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СЦЕПИТЬ(A1;B1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani B1 yacheykaga ko’shish
        
194. 
     MS Excel dasturida ushbu formula nima xisoblaydi =НАЙТИ(A1;B1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani B1 yacheyka ichida topish
        

177. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ЛЕВСИМВ(A1;B1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykada B1-ta xarflarni chapdan olish
        
178. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ЗАМЕНИТЬ(A1;B1;C1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani B1-chi xarfdan C1 yacheykani qo’shish
        
179. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ПСТР(A1;B1;C1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykada B1-chi xarfdan C1-ta xarflarni o’ngdan olish
        
180. 
     MS Excel dasturida ushbu formula nima xisoblaydi =ПОВТОР(A1;B1) to’g’ri ko’rsating?
     
     1. 
        А1 yacheykani B1-ta takrorlanish
        
181. 
     MS Excel dasturida ushbu formula nima xisoblaydi =СЧЁТЕСЛИ(A1:B1;”>0”) to’g’ri ko’rsating?
     
     1. 
        А1 dan B1 gacha nechta 0 dan kattalari