EXAMRADAR

Question: Which function is used for finding the square root of any number in MS EXCEL?

Answer:

The function used to find the square root of a number in Microsoft Excel is the "SQRT" function.

The syntax for the SQRT function is as follows:

```
=SQRT(number)
```

Here, "number" represents the value for which you want to calculate the square root. You can enter a specific number or refer to a cell containing the number.

For example, to find the square root of the number 25, you can use the following formula:

```
=SQRT(25)
```

The result will be 5, as the square root of 25 is 5.

You can also use cell references with the SQRT function. For example, if you have a number in cell A1 and you want to find its square root, you can use the formula:

```
=SQRT(A1)
```

This will calculate the square root of the number in cell A1.

By using the SQRT function in Excel, you can easily calculate the square root of a given number in your worksheet.

MCQ: Which function is used for finding the square root of any number in MS EXCEL?

Correct Answer: A. SQR

Explanation:

The function used to find the square root of a number in Microsoft Excel is the "SQRT" function.

The syntax for the SQRT function is as follows:

```
=SQRT(number)
```

Here, "number" represents the value for which you want to calculate the square root. You can enter a specific number or refer to a cell containing the number.

For example, to find the square root of the number 25, you can use the following formula:

```
=SQRT(25)
```

The result will be 5, as the square root of 25 is 5.

You can also use cell references with the SQRT function. For example, if you have a number in cell A1 and you want to find its square root, you can use the formula:

```
=SQRT(A1)
```

This will calculate the square root of the number in cell A1.

By using the SQRT function in Excel, you can easily calculate the square root of a given number in your worksheet.

Discuss a Question

Related Questions

You may be interested in:

Computer Basics MCQs

Recently Added Articles

How Can AI Simplify the Academic Life of Students?

How Can AI Simplify the Academic Life of Students?

Last updated on: April 16, 2025Posted by: ExamRadar

Want to Clear IBPS RRB PO? Master These Mock Test Hacks!

Last updated on: March 10, 2025Posted by: ExamRadar

Top AI Tools for Instantly Detecting Plagiarized Writing

Last updated on: December 5, 2024Posted by: ExamRadar

5 Important Tools for System Administrators

Last updated on: December 1, 2024Posted by: ExamRadar

Image to Text Conversion Made Easy: Online Tool Insights

Last updated on: April 12, 2024Posted by: ExamRadar

Tips to Write an Email: Pro Email Writing Tips

Last updated on: March 20, 2024Posted by: ExamRadar

Yellow diamond: the market worth and value

Last updated on: March 9, 2024Posted by: ExamRadar