Numerical functions

Question 1

ABS

Answer 1

Returns the absolute value of a number

Question 2

ACOS

Answer 2

Returns the arc cosine of a number

Question 3

ASIN

Answer 3

Returns the arc sine of a number

Question 4

ATAN

Answer 4

Returns the arc tangent of one or two numbers

Question 5

ATAN2

Answer 5

Returns the arc tangent of two numbers

Question 6

AVG

Answer 6

Returns the average value of an expression

Question 7

CEIL

Answer 7

Returns the smallest integer value that is >= to a number

Question 8

CEILING

Answer 8

Returns the smallest integer value that is >= to a number

Question 9

COS

Answer 9

Returns the cosine of a number

Question 10

COT

Answer 10

Returns the cotangent of a number

Question 11

COUNT

Answer 11

Returns the number of records returned by a select query

Question 12

DEGREES

Answer 12

Converts a value in radians to degrees

Question 13

DIV

Answer 13

Used for integer division

Question 14

EXP

Answer 14

Returns e raised to the power of a specified number

Question 15

FLOOR

Answer 15

Returns the largest integer value that is <= to a number

Question 16

GREATEST

Answer 16

Returns the greatest value of the list of arguments

Question 17

LEAST

Answer 17

Returns the smallest value of the list of arguments

Question 18

LN

Answer 18

Returns the natural logarithm of a number

Question 19

LOG

Answer 19

Returns the natural logarithm of a number, or the logarithm of a number to a specified base

Question 20

LOG10

Answer 20

Returns the natural logarithm of a number to base 10

Question 21

LOG2

Answer 21

Returns the natural logarithm of a number to base 2

Question 22

MAX

Answer 22

Returns the maximum value in a set of values

Question 23

MIN

Answer 23

Returns the minimum value in a set of values

Question 24

MOD

Answer 24

Returns the remainder of a number divided by another number

Question 25

PI

Answer 25

Returns the value of PI

Question 26

POW

Answer 26

Returns the value of a number raised to the power of another number

Question 27

POWER

Answer 27

Returns the value of a number raised to the power of another number

Question 28

RADIANS

Answer 28

Converts a degree value into radians

Question 29

RAND

Answer 29

Returns a random number

Question 30

ROUND

Answer 30

Rounds a number to a specified number of decimal places

Question 31

SIGN

Answer 31

Returns the sign of a number

Question 32

SQRT

Answer 32

Returns the square root of a number

Question 33

SUM

Answer 33

Calculates the sum of a set of values

Question 34

TAN

Answer 34

Returns the tangent of a number

Question 35

TRUNCATE

Answer 35

Truncates a number to the specified number of decimal places