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?

  • SQR
  • SQRT
  • MOD
  • MODE()
Correct Answer: B. SQRT

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

Discuss a Question








Share with : Share on Linkedin Share on Twitter Share on WhatsApp Share on Facebook

You may be interested in:

Computer Basics MCQs

Recently Added Articles

Image to Text Conversion Made Easy: Online Tool Insights

Tips to Write an Email: Pro Email Writing Tips

Yellow diamond: the market worth and value

Tips to Help Students Perform Their Best in Online Exams

Types of IP Address in Computer Network: What is & Full Form

NLP AND ML PARADIGMS FOR SENTENCE REPHRASING: FROM CHANGING TO REINVENTING

Understanding of Optical Fiber Cables

Advantages of Pursuing a Business Analytics Degree in Germany