Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Working with Roots and Powers | Basic Functions
Google Spreadsheets Tutorial

bookWorking with Roots and Powers

The SQRT function calculates the square root of a number. It returns a positive value that, when squared, equals the original number. This function is useful for geometric calculations, speed or acceleration measurements, and other mathematical operations involving squares and roots.

Calculating Powers

The POWER function raises a number to a specified exponent. This is useful for calculations involving progressions, scaling, compound interest, and any operations requiring exponentiation.

Task: Understanding SQRT and POWER Functions

You have the following formulas in your spreadsheet:

AFormulaExpected Result
25=SQRT(A1)?
2=POWER(A2, 3)?
-8=POWER(A3, 1/3)?
question mark

Which of the following answer choices correctly fills in the expected results for each formula?

Select the correct answer

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 6. Luku 6

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Awesome!

Completion rate improved to 1.45

bookWorking with Roots and Powers

Pyyhkäise näyttääksesi valikon

The SQRT function calculates the square root of a number. It returns a positive value that, when squared, equals the original number. This function is useful for geometric calculations, speed or acceleration measurements, and other mathematical operations involving squares and roots.

Calculating Powers

The POWER function raises a number to a specified exponent. This is useful for calculations involving progressions, scaling, compound interest, and any operations requiring exponentiation.

Task: Understanding SQRT and POWER Functions

You have the following formulas in your spreadsheet:

AFormulaExpected Result
25=SQRT(A1)?
2=POWER(A2, 3)?
-8=POWER(A3, 1/3)?
question mark

Which of the following answer choices correctly fills in the expected results for each formula?

Select the correct answer

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 6. Luku 6
some-alt