Page 211 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes ABS(43) returns 43-43 is the absolute value of 43.

ABS(-105) returns 105_105 is the absolute value of -105.
CEILING Rounds a number away from zero to the nearest integer or to the nearest
multiple of significance.
Syntax: CEILINC(number, significance)

Number is the numeric value you want to round off.
Significance is the multiple to which you want to round off.
CEILINC (2.5,1) returns 3.

CEILINC(0.234, O.O1) returns 0.24.
FLOOR Rounds a number down to the level of significance that you specify.
Syntax: FLOOR (number, significance)

Number is the numeric value you want to round off.
Significance is the multiple to which you want to round off.
FLOOR(2.5, 1) returns 2.

FLOOR(-2.5, -2) returns -2. Rounds a number down to the nearest integer.
Syntax: INT(number) Number is the real number you want to round
down to an integer.
INT(8.9) returns 8.
INT(-8.9) returns -9.

ROUND Rounds a number to a specified number of digits.
Syntax: ROUND(number, num_digits)

Number is the number you want to round off.
Num_digits specifies the number of digits to which you want to round
off the number.

ROUND(2.149,1) returns 2.’1.
ROUND(-1 .475, 2) returns -1.48.
ROUND(21 .5, -1) returns 20.

Returns a positive square root.
Syntax: SQRT(number)

Number is the number for which you want the square root”
SQRT(16) returns 4.
SQRT(-1 6) returns #NUM!

SQRT(ABS(-16)) returns 4.
Adds its arguments.
Syntax: SUM(number 1, number 2, ...)

204 LOVELY PROFESSIONAL UNIVERSITY