DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The function used to calculate the square root result in MS.Excel is____
|
|
COUNTA
|
|
|
SQRT
|
|
|
MOD
|
|
|
OOD
|
Explanation:
Detailed explanation-1: -The SQRT function syntax has the following arguments: Number Required. The number for which you want the square root.
Detailed explanation-2: -sqrt() in C++ is used to return the square root of any number. It is defined in the cmath header file. It takes in a non-negative number as an argument and returns the square root of that number. We can state mathematically : sqrt(x) = √x.
Detailed explanation-3: -Square a number in its own cell Type =N^2 into the cell, where N is the number you want to square. For example, to insert the square of 5 into cell A1, type =5^2 into the cell. Press Enter to see the result.
There is 1 question to complete.