Excel Square Root Calculation Quiz

Excel Square Root Calculation Quiz

Assessment

Interactive Video

Mathematics

6th - 7th Grade

Hard

Created by

Jennifer Brown

FREE Resource

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step to calculate the square root of a number in Excel using the built-in function?

Click on the 'Insert Function' button

Type the number directly into the cell

Use the 'Data' tab to find the function

Type an equal sign followed by 'SQRT'

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When using the SQRT function with a cell reference, what should you do after typing 'SQRT('?

Type the number directly

Select the cell containing the number

Type a comma and then the number

Press the 'Enter' key immediately

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you input a number directly into the SQRT function in Excel?

Type the number inside the parentheses of the SQRT function

Select the number from a drop-down list

Use the 'Insert' tab to find the number

Type the number after an equal sign

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What symbol is used in Excel to represent 'to the power of' when creating a custom formula for square roots?

Asterisk (*)

Carrot (^) symbol

Dollar sign ($)

Ampersand (&)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the custom formula method, how is the square root of a number expressed mathematically?

Number divided by 2

Number subtracted by 2

Number multiplied by 2

Number raised to the power of 1/2