MS Excelda katakka murojaat. Nisbiy, absolyut va aralash murojaat. Katak yoki blokni nomlash

Informatika va aхborot texnologiyalari fanidan 1-kurs 1semestr uchun Elektron dars taqdimoti Mavzu: Katakka murojaat: nisbiy, absolyut va aralash murojaat. Katak yoki blokni nomlash. Murojaatdan foydalanib amal bajarishda nusxalashning afzalligi. Tuzuvchi: Tadjibayeva M.X. 1.Amallar va sodda ifodalarni hisoblash 2. Katakka murojaat: nisbiy, absolyut va aralash Reja murojaat. 3. Katak yoki blokni nomlash. 4. Murojaatdan foydalanib amal bajarishda nusxalashning afzalligi. x2  x(x2  4x) y  x=10 bo'lsa, Y ning x 5(x2  2) qiymatini hisolablang. A1 katakchaga x ni, A4 katakchaga y ni, B1 katakchaga x ni qiymatini va B4 katakchaga =(B1^2+(B1*(B1^2+4*B1))^(12)) (B1+5*(B1^2+2))^(12) ni kiritamiz. Misollar a  b  c r  ab 2a  d (n 1) S  n 2 2 x(x  5) y  2 5  2(x  2) Misollar r  (a  b  c) (a *b) s  ((2 * a  d * (n 1)) 2) * n y  ((x*(x^2  5))^ (1 2) (5  2*(x^2  2))^ (1 2) MS EXCEL dasturida amallar va sodda ifodalarni hisoblash 4y(5x  y)  (5x  2)(5x  2)  2  z 3 2 n  3n 12 n 2 2 3a  2ab  b 2 2 5a  2b 1   b ab 3 ab a3 a2b2  ab  a2   Ma'lumotlar turi Katakni formatlashga doir misollar MS EXCEL dasturida amallar va sodda ifodalarni hisoblash 4y(5x  y)  (5x  2)(5x  2)  2  z 4*y*(5*x-y)-(5*x-2)*(5*x+2)-2=z Arifmetik amallardan tashqari kataklarga turlicha murojat qilish orqali amaliy masalalarni yechish mumkin Katakka murojaat: nisbiy, absolyut va aralash murojaat =C5$B$5*100 absalyut murojat =C5B5*100 nisbiy murojat =C5$B5*100 aralash murojat Katakka murojaat: nisbiy, absolyut va aralash murojaat Fanlar O'zlashtirish ko'rsatkichi o'quvchi inforama inforama sinf soni ona tili adabiyot rus tili tika ona tili adabiyot rus tili tika 4-sinf 25 22 24 88,0 96,0 0,0 0,0 5-sinf 26 23 23 88,5 88,5 0,0 0,0 6-sinf 28 24 27 85,7 96,4 0,0 0,0 7-sinf 26 26 25 100,0 96,2 0,0 0,0 8-sinf 25 24 23 96,0 92,0 0,0 0,0 9-sinf 27 26 26 96,3 96,3 0,0 0,0 10-sinf 28 26 27 92,9 96,4 0,0 0,0 jami 185 171 175 0 0 647,3293 661,7688 0 0 Murojaatdan foydalanib amal bajarishda nusxalashning afzalligi. a a^2 a^3 a^4 a^5 2 4 8 16 32 3 9 27 81 243 4 16 64 256 1024 5 25 125 625 3125 ...