Ms excel dasturida funksiyalardan foydalanib murakkab hisobotlarni tashkil etish reja: ms excel dasturida funksiyalardan foydalanish

Excelda funktsiyalar tasnifi:
1. miya tizeri (agar aagar xato bo'lsa, va, yoki, rost, yolg‘on, emas)
2. matematik (abc, acos, acosh, asin, asinh, atan, atan2, atanh, cos, cosh, exp, ln, log, log10, sin, sinh, tan, tan, daraja, dfactr, belgi, ildiz, ildiz, mobr, mored , ko'p sonli, ko'payish, g'alati, tugun, taqish, okrup, okrvniz, yaxlitlangan, o'ralgan, aylantirilgan, yumaloqlangan, qolgan, o'chirilgan, pi, prod, oraliq yig'indilar, radianlar, rim, yig'indilar qatori, sonlar, darajalar, darajalar o'rtasidagi ishlar. , sum, agar, sum, s, yig'indisi, yig'indisi, summasi, summasi, summasi, summasi, summasi, summasi, summasi, summasi, haqiqati, butun, son, juft, juft, raqam com)
3. statistik(frasp, fresp, pearson, ztest, betaobr, betarasp, binomarasp, Weibull, ehtimollik, gammanlog, gammaobr, gammarasp, gipergeomet, tarqatish, tarqatish, tarqatish, tarqatish, ishonish, quadrotkl, kvartil, qpirson, kovar, korrel, kritbinom, lgrfp , chiziqli, lognormal, lognormal, lognormal, max, max, median, min, mine, moda, eng katta, eng kichik, qiyalik, normallashtirish, normobr, normrasp, normstobr, normstrasp, otrbinomrasp, segment, foiz, foiz, taxmin qilingan, foiz, poisson , daraja, balandlik, bevel, srgarm, srgeom, o'rtacha, o'rtacha, o'rtacha, o'rtacha, o'rtacha, o'rtacha, o'rtacha, o'rtacha, turish, turish, turish, turish, turish, turish, turish, turish, hisoblash, hisoblash, hisoblash, agar, agar, hisoblash, hisoblash , baliqchi, fisherobr, ftest, chi2obr, chi2rasp, chi2test, chastota, ekspress, kurtoz)
4. moliyaviy(amoruv, amorum, apl, acch, tayinlanmagan, bs, vd, ddob, davomiylik, kunlik kupon, kunko'pondo, kunlik kupon, daromad, ish haqi, daromad daromadlari, ish haqi, daromad, daromad, daromad , jamg'arib boriladigan daromadni to'lash, denominatsiya, umumiy daromad, umumiy to'lov, osplt, plt, olingan, foiz to'lovlari, prplt, ps, puo, ravnokchek, rubl.des, rubl.fraksiya, chegirma, stavka, fuo, narx, narx, chek, narx narxlari, sotib olish narxi, sotishdan keyingi narx , raqam kuponi, chistvndokh, chprnz, chps, effekt)
5. matn(battext, dlstr, almashtirish, ma'no, kalsimb, levsymb, topish, pecsymb, takrorlash, almashtirish, qidirish, huquqymbol, kapital, propnach, pstr, rubl, siqilgan bo'shliqlar, belgi, gugurt, kichik harf, ulash, t, matn, sobit)