CEILING

Rounds a number up to the nearest specified multiple.

Syntax

=CEILING(number,significance)

Example:

=CEILING(127,10)

Result:

130

FLOOR

Rounds a number down to the nearest specified multiple.

=FLOOR(127,10)

Result:

120

POWER

Calculates a number raised to a power.

Syntax

=POWER(number,power)

Example:

=POWER(5,2)

Result:

25

SQRT

Calculates the square root.

=SQRT(144)

Result:

12

Practice

Create a Mathematical Calculation Sheet using:

  • CEILING
  • FLOOR
  • POWER
  • SQRT

Use examples from packaging quantities, dimensions and mathematical calculations.

PreviousNext