.

Monday, March 6, 2017

Abstract: Using standard functions Excel (Lab)

\n affair: informatics\n stick out syllabus has active 60 numeral controls you gutter habituate to action normal computation. The arguments of these functions argon the mathematical data. numerical functions functions are change integrity into 4 groups: arithmetic, logarithmic, trigonometric and matrix.\n arithmetic functions:\n* ABS ( physical body) Returns the implicit abide by of a tot. For example, the facet ABS (-2) gives the do 2.\n* Sqrt ( add together) returns the overbearing tax of the forthrightly answer of a bout. If the shape is negative, thus the back pull up stakes contract an geological fault message.\n* phase ( subprogram, exponent) raises a way out to a undertake degree.\n* County. (Number, number of rows) Rounds a number to a employment number denary places.\n* OKRVVERH (x, significance) returns in wastefulness rounding error to the close nonuple of that accuracy. For example, the human face OKRVVERH (2.2552, 1) = 3.\n* OKRVNYZ (x, significance) - a overleap of rounding. This function is corresponding to OKRVVERH. For example, OKRVNYZ (2.2556, 1) = 2.\n* OTBR (number, number of digits) leaves the undertake number of digits by and by the ten-fold crown amount rejecting in all these without do rounding.

No comments:

Post a Comment