A list of positive and negative numbers are in A2 through A400, and the square root of the absolute value is needed for each cell. Which function typed into B2 and copied through B400 will provide this information?
a.
=A2^(1/2)
b.
=SQRT(A2)
c.
=SQRT(ABS(A$2))
d.
=SQRT(ABS(A2))

Trying to take a square root of a negative number will result in a #NUM! error being shown in the result cell. Assuming you want the root of the magnitude of the numbers in column A, the value you want the root of is ABS(A2).

Using a dollar sign on a cell reference renders that portion of the cell reference fixed when the formula is copied. Referencing cell A$2 will mean you will get 399 copies of the square root of the contents of cell A2 in cells B2 through B400.

Formula

The formula that will give you the square root of the magnitude of the adjacent cell in column A will be

=SQRT(ABS(A2)) . . . . . . . . . formula for cell B2, copied to cells below

A list of positive and negative numbers are in A2 through A400, and the square root of the absolute value is needed for each cell. Which function typed into B2 and copied through B400 will provide this information? a. =A2^(1/2) b. =SQRT(A2) c. =SQRT(ABS(A$2)) d. =SQRT(ABS(A2))

Respuesta :

Considerations

Formula

Otras preguntas

A list of positive and negative numbers are in A2 through A400, and the square root of the absolute value is needed for each cell. Which function typed into B2 and copied through B400 will provide this information?
a.
=A2^(1/2)
b.
=SQRT(A2)
c.
=SQRT(ABS(A$2))
d.
=SQRT(ABS(A2))