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))

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 4.5CP
icon
Related questions
Question
  1. 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))
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Variables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L