|
Amaliy ishni bajarish tartibi
|
| bet | 54/74 | | Sana | 13.06.2024 | | Hajmi | 6,59 Mb. | | #263152 |
Bog'liq Informatika fanidan amaliy ishlar uchun o’quv uslubiy qo’llanma ( Amaliy ishni bajarish tartibi:
1. Komyuterni ishga tushirish uchun o’qituvchidan ruxsat oling.
2. Kompyuterni ishga tushiring va windows operatsion tizimini yuklang.
3. Excel dasturini ishga tushiring (Пуск – Программы – Microsoft Excel).
4.Yangi ishchi kitob yarating. Joriy ishchi varag’ining yorlig’ida sichqoncha tugmachasi ni 2 marta bosing va ushbu ishchi varaqqa “Данные” deb nom bering.
5. Al yacheykani faollashtiring va unga “Результат” deb sarlavha kiriting.
6. A ustunning A2 yacheykasidan boshlab keyingi yacheyka larga ixtiyoriy sonlarni kiriting.
7.Bl yacheykaga “Удвоенное” satrini kiriting. Cl yacheykaga “Квадрат значения” satrini kiriting. Dl yacheykaga “Квадрат следущего число”satrini kiriting.
8.B2 yacheykaga =2*A2, C2 yacheykaga esa =A2*A2 formulalarini kiriting. D2 yacheykaga = B2+C2+1 formulasini kiriting. B2, C2, D2 yacheykalarini ajrating. 9.Sichqoncha ko’rsatkichini ajratilgan yacheykalar diapazoni qamrab olgan ramkaning o’ng pastki burchagida gi to’ldirish markeri ustiga olib keeling.Sichqonchaning chap tugmasini bosgan holda markerni shunday joygacha sudrab olib boring, A ustunda qancha son bo’lsa, ramka B, C, D ustunlarda shuncha satrni qamrab olsin. A ustundagi biror sonni o’zgartirib, B, C, D ustundagi mos sonlarni ham avtomatik ravishda qayta hisoblanishicha o’zgarishiga ishonch hosil qiling. El yacheykaga “Масштабный множитель” satrini ko’chiring. E2 yacheykaga 5 sonini kiriting. Fl yacheykaga “Масштабированное” satrini kiriting. 10. F2 yacheykaga =A2*E2 formulasini kiriting. Avtoto’ldirish yordamida ushbu formulaning nusxasini F ustuning yacheykalariga ko’chiring.Masshtablash natijasi noto’g’ri bo’lganligiga ishonch hosil qiling. Bu hodisa E2 manzili formulada nisbiy havola bilan berilganligi sababli ro’y bergan.
11. Oldin F2 yacheykasida, keyin esa formula satrida sichqoncha tugmasini bosing. F4 klavishini bosing. Endi formula =A2*$E$2 ko’rinishini olganligiga ishonch hosil qiling va Enter klavishini bosing.F ustunini F2 formula bilan to’ldirishni takrorlang.
12.Absolut havola qo’llanganligi sababli, F ustun yacheykalaridagi qiymatlar to’g’ri hisoblanganligiga ishonch hosil qiling. Ishchi kitobni books.xls nomi bilan saqlab qo’ying.
13. Dastur ishini yakunlang, kompyuterni o’chiring.
|
| |
