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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of POWER
0/3The same formula in the other shapes it takes at work.
- POWER Function / Exponentiation
Calculate powers and square roots using mathematical functions.
CoreIntermediate - Compound growth with ^
Growth that builds on itself is a power, not a multiplication.
Intermediate - POWER with a fraction: the yearly growth rate
A root is a power of 1/n — which is how you get an average annual rate.
Advanced
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.
| A | B | C | |
|---|---|---|---|
| 1 | Number | Square | Square Root |
| 2 | 4 | ||
| 3 | 9 | ||
| 4 | 16 | ||
| 5 | 25 |
Functions used here
What this exercise teachesMay contain the answer
Mathematical functions like POWER and SQRT, or operators like ^, help with advanced calculations such as exponents and roots.