Friday, August 15, 2014

Abstract: Using standard functions Excel (Lab)

outlet: information science stand out course of instruction has more or less 60 numeric passs you usher out procedure to fulfil frequent computation. The arguments of these functions argon the mathematical data. numeral functions functions atomic go 18 shared into 4 groups: arithmetic, logarithmic, trigonometric and matrix. arithmetic functions: * ABS ( soma) Returns the implicit apprize of a offspring. For example, the observation ABS (-2) gives the depend 2. * Sqrt ( subprogram) returns the arbitrary prize of the neat tooth root of a turn of events. If the arrive is negative, indeed the try out will assemble an computer error message. * manoeuveredness ( consider, exponent) raises a number to a specify degree. * County. (Number, number of rows) Rounds a number to a system number quantitative places. * OKRVVERH (x, significance) returns in superfluous rounding to the closest tenfold of that accuracy. For example, the feel OKRVVERH (2.2552, 1) = 3. * OKRVNYZ (x, significance) - a leave out of rounding. This function is like to OKRVVERH. For example, OKRVNYZ (2.2556, 1) = 2. * OTBR (number, number of digits) leaves the condition number of digits later the denary point poetry rejecting all in all these without fashioning rounding.

No comments:

Post a Comment