Math and Trig Functions

Question 1

CONVERT(Expression, Datatype)

Answer 1

Converts an expression of one data type to another.

Question 2

RADIANS(angle)

Answer 2

Converts degrees to radians.

Question 3

DEGREES(angle)

Answer 3

Converts radians into degrees.

Question 4

SIGN(number)

Answer 4

Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.

Question 5

CURRENCY(value)

Answer 5

Evaluates the argument and returns the result as currency data type.

Question 6

DIVIDE(numerator, denominator[,alternateresult])

Answer 6

Performs division and returns alternate result or BLANK() on division by 0.

Question 7

QUOTIENT(numerator, denominator)

Answer 7

Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.

Question 8

MROUND(number, multiple)

Answer 8

Returns a number rounded to the desired multiple.

Question 9

RAND()

Answer 9

Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The number that is returned changes each time the cell containing this function is recalculated.

Question 10

RANDBETWEEN(bottom,top)

Answer 10

Returns a random number in the range between two numbers you specify.

Question 11

EXP(number)

Answer 11

Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Question 12

EVEN(number)

Answer 12

Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate’s capacity.

Question 13

ODD(number)

Answer 13

Returns number rounded up to the nearest odd integer.

Question 14

ABS(number)

Answer 14

Returns the absolute value of a number.

Question 15

ACOS(number)

Answer 15

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.

Question 16

ASIN(number)

Answer 16

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2.

Question 17

ATAN(number)

Answer 17

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.

Question 18

LOG10(number)

Answer 18

Returns the base-10 logarithm of a number.

Question 19

COS(number)

Answer 19

Returns the cosine of the given angle.

Question 20

COT (number)

Answer 20

Returns the cotangent of an angle specified in radians.

Question 21

FACT(number)

Answer 21

Returns the factorial of a number, equal to the series 123… , ending in the given number.

Question 22

GCD(number1, [number2], …)

Answer 22

Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.

Question 23

COSH(number)

Answer 23

Returns the hyperbolic cosine of a number.

Question 24

COTH (number)

Answer 24

Returns the hyperbolic cotangent of a hyperbolic angle.

Question 25

SINH(number)

Answer 25

Returns the hyperbolic sine of a number.

Question 26

TANH(number)

Answer 26

Returns the hyperbolic tangent of a number.

Question 27

ACOSH(number)

Answer 27

Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.

Question 28

ACOTH(number)

Answer 28

Returns the inverse hyperbolic cotangent of a number.

Question 29

ASINH(number)

Answer 29

Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number.

Question 30

ATANH(number)

Answer 30

Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number.

Question 31

LCM(number1, [number2], …)

Answer 31

Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.

Question 32

LOG(number,base)

Answer 32

Returns the logarithm of a number to the base you specify.

Question 33

LN(number)

Answer 33

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Question 34

ACOT(number)

Answer 34

Returns the principal value of the arccotangent, or inverse cotangent of a number.

Question 35

MOD(number, divisor)

Answer 35

Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.

Question 36

POWER(number, power)

Answer 36

Returns the result of a number raised to a power.

Question 37

SIN(number)

Answer 37

Returns the sine of the given angle.

Question 38

SQRTPI(number)

Answer 38

Returns the square root of (number * pi).

Question 39

SQRT(number)

Answer 39

Returns the square root of a number.

Question 40

TAN(number)

Answer 40

Returns the tangent of the given angle.

Question 41

PI()

Answer 41

Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

Question 42

INT(number)

Answer 42

Rounds a number down to the nearest integer.

Question 43

FLOOR(number, significance)

Answer 43

Rounds a number down, toward zero, to the nearest multiple of significance.

Question 44

ROUNDDOWN(number, num_digits)

Answer 44

Rounds a number down, toward zero.

Question 45

ROUND(number, num_digits)

Answer 45

Rounds a number to the specified number of digits.

Question 46

ROUNDUP(number, num_digits)

Answer 46

Rounds a number up, away from 0 (zero).

Question 47

CEILING(number, significance)

Answer 47

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

Question 48

ISO.CEILING(number[, significance])

Answer 48

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

Question 49

TRUNC(number,num_digits)

Answer 49

Truncates a number to an integer by removing the decimal, or fractional, part of the number.