.

Sunday, February 21, 2016

Abstract: Using standard functions Excel (Lab)

\n musical theme: Informatics\n outmatch program has well-nigh 60 mathematical functions you can mapping to perform commonplace computation. The arguments of these functions argon the quantitative data. Mathematical functions functions are divided into 4 groups: arithmetic, logarithmic, trigonometric and matrix.\narithmetical functions:\n* ABS ( estimate) Returns the absolute time value of a go. For example, the panorama ABS (-2) gives the number 2.\n* Sqrt (number) returns the ordained value of the forthright root of a number. If the number is negative, consequently the screen impart receive an fracture message.\n* Degree (number, exponent) raises a number to a contract degree.\n* County. (Number, number of rows) Rounds a number to a practise number decimal fraction places.\n* OKRVVERH (x, significance) returns in dissipation rounding to the near multiple of that accuracy. For example, the contemplation OKRVVERH (2.2552, 1) = 3.\n* OKRVNYZ (x, significance) - a ove rleap of rounding. This function is correspondent to OKRVVERH. For example, OKRVNYZ (2.2556, 1) = 2.\n* OTBR (number, number of digits) leaves the specified number of digits by and by the decimal phase numbers rejecting in all these without making rounding.

No comments:

Post a Comment