Basic Functions
Intermediate

POWER Function / Exponentiation

Calculate powers and square roots using mathematical functions.

Task:

You need to perform mathematical calculations involving exponents and roots. Calculate the square of each number in column B and the square root in column C to understand how numbers change with these operations.

Learning Objectives:

  • Learn POWER and SQRT functions or exponentiation operator
  • Understand mathematical operations
  • Practice advanced calculations
Hints

Solve without hints for +5 XP

Interactive Spreadsheet

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

ABC
1NumberSquareSquare Root
24
39
416
525
What this exercise teaches (contains the answer)

Mathematical functions like POWER and SQRT, or operators like ^, help with advanced calculations such as exponents and roots.

Functions used here