hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Which function is used to calculate the square root of a number in Excel?
    Question

    Which function is used to calculate the square root of a number in Excel?

    A.

    SAND

    B.

    SQRT

    C.

    SORT

    D.

    SROOT

    Correct option is B

    The correct answer is: (b) SQRT

    Explanation:
    In Excel, the SQRT function is used to calculate the square root of a number. The syntax is:

    =SQRT(number)

    Where "number" is the value for which you want to find the square root.

    The other options:

    • SAND: Not a valid Excel function.
    • SORT: This function is used to sort a range of data.
    • SROOT: Not a valid Excel function.

    Therefore, the correct function to calculate the square root is SQRT.

    Free Tests

    Free
    Must Attempt

    Punjab Police Constable Paper-I & II PYP (Held on 30th July 2024 Shift 1)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon180 Mins
    languageIcon English
    Free
    Must Attempt

    Punjab Police Constable Paper-I & II PYP (Held on 6th Aug 2024 Shift 1)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon180 Mins
    languageIcon English
    Free
    Must Attempt

    PSSSB Excise Inspector (Paper I) Mock Test -01

    languageIcon English
    • pdpQsnIcon50 Questions
    • pdpsheetsIcon50 Marks
    • timerIcon30 Mins
    languageIcon English
    test-prime-package

    Access ‘PSSSB Clerk’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    383k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow