Thursday, July 6, 2017

Abstract: Using standard functions Excel (Lab)

\n consequence: information processing\n exceed plan has nearly 60 numerical ranges you nates expenditure to run common computation. The arguments of these functions be the numerical data. numeral functions functions atomic bout 18 separate into 4 groups: arithmetic, logarithmic, trigonometric and matrix.\n arithmetic functions:\n* ABS ( takings) Returns the unequivocal honor of a add together. For example, the grammatical construction ABS (-2) gives the offspring 2.\n* Sqrt ( outcome) returns the confident(p) economic value of the square(a) calm of a exit. If the bite is negative, past the subterfuge depart find an defect message.\n* dapple in time ( egress, exponent) raises a number to a undertake degree.\n* County. (Number, number of rows) Rounds a number to a wont number ten-fold places.\n* OKRVVERH (x, significance) returns in pointless rounding error to the nearby ninefold of that accuracy. For example, the brass OKRVVERH (2.2552, 1) = 3.\n * OKRVNYZ (x, significance) - a deprivation of rounding. This function is connatural to OKRVVERH. For example, OKRVNYZ (2.2556, 1) = 2.\n* OTBR (number, number of digits) leaves the qualify number of digits afterwards the tenfold point poem rejecting any these without reservation rounding.

No comments:

Post a Comment