answersLogoWhite

0


Best Answer

Alt+251 -- To show the symbol you need to hold alt and press 251 on the numpad.

Just in case you are meaning to find the square root of a number then you only need the function SQRT(~number~).

Also, it looks kind of like a check mark. So, as an alternative, you can also write square root as "^(1/2)" or "^0.5" or just "^.5"

User Avatar

Wiki User

โˆ™ 2011-08-26 15:28:27
This answer is:
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
User Avatar

Add your answer:

Earn +20 pts
Q: How do you display a square root symbol using Excel?
Write your answer...
Submit
Related questions

How do you display the power of 2 symbol using Microsoft Excel?

Exponent symbol is the carat (^). Four squared is 4^2.


How do you display the square root symbol on output screen using C Plus Plus?

The the square root symbol can be displayed by using ASCII code cout<<"press alt251"; pressing alt251 "��"


How do you display the square root symbol on the screen using Apple Pages?

option/alt V


How do you display the square root symbol on the screen using Microsoft Excel?

There is an Expression Builder in Excel, but it not installed by default. To see if it is installed, goto: Insert Menu->Object Menu Look for Microsoft Equation 3.0 If it is not there, Add it From the Office Installer (Office Tools) Using this object, you can create all kinds of crazy mathematical equations ...


How do you display a square root symbol using word pad?

WordPad is not meant to handle the typesetting and display of mathematical expressions. You can use this radical symbol: √ to display simple square roots, but you can't extend the mark above the thing you're taking the square root of. To display more complex expressions, you need a program like MathType, which is specifically designed to typeset math.


How do you display the power of 2 symbol using Microsoft wordpad?

In WordPad, you can highlight the exponent and format it as a SuperScript. In Excel, you use the ^ symbol to represent an exponent (Example: 4^2 means four to the second power, or four squared.)


How do you display the power of four symbol using Microsoft word?

^4


Using what button on the Ribbon instructs Excel to display additional decimal places in a cell?

Increase Decimal.


Using the button on the Ribbon instructs Excel to display additional decimal places in a cell?

increase decimal


How do you display del symbol on output screen using C Plus Plus?

The del character, #255, has no symbol. It is a non-printing character, so you cannot display it on the screen.


Display square root of 1 to 50 using flowchart?

1 =1


How do you get multiples by using raise to a number in excel?

Use the exponent symbol (^). Example: 3 to the 4th power is 3^4.


How do you display a square root symbol using open office impress?

From within the program - click on Insert, then Special Character. Locate it in the table (it's towards the bottom of the table - roughly central) and click OK


How do you display an exponential power symbol on the output screen using Borland C Plus?

Use the ^ (Shift 6) character usually called the Carrat Symbol.


How do you calculate a square root of a number in Excel?

You calculate square root in Excel using the Sqrt() function. for example: If the value of A1 is 81 and A2 contained the formula "=Sqrt(A1)", The number 9 would be displayed.


How do you type dia symbol in Excel?

Any unusual symbols can be entered through the Insert Symbol option or by using the Character Map in Windows and copying it from there. You can search through the characters available to find the symbol you want. The dia symbol can be added in that way.


What does daverage do in Excel?

It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.


How do you display Sales Amt on Excel 2013?

You would calculate it using the Sum function. It will depend on what cells your values are in as to what form the actual formula will take.


How do you type a square root symbol using Microsoft PowerPoint?

Go to Insert Symbol. From there you can go through the character sets and you will find the square root symbol. You could also get it in the Character Map and then copy and paste it into Powerpoint.


Where is autofill in Excel?

It depends on what version of excel you are using.


Should you press ctrl to display underlying formulas used in the worksheet?

You can display formulas by using the keyboard Shortcut CTRL + ` in Excel. (The ` Grave Accent key is below the ESC Key on the upper left side of most keyboards.)


Is hardware or software used in Excel?

Microsoft Excel is itself software, so you are using software when you are using it. All software uses the hardware of the computer, and you would be using your keyboard, mouse and screen, which are all hardware, as you use Excel. If you printed something from Excel, you would be using hardware too. Excel, works with the operating system and it is the operating system that works with the hardware. So Excel does not work directly with the hardware, but you would be using hardware in order to work with Excel.


When using Excel formula always begins with what?

When using excel, always start your formulas with an "=" (equal) sign.


How do you display a square root symbol using openofficeorg impress?

In a text box:ALT-Insert -> Special CharacterThen search for it (it appears at U+221A in Liberation Sans/Mathematical operators; probably in same place for other fonts too).Alternatively, you can use:Alt_Insert -> Object -> Formulato insert a formula box and use the function:sqrt{}To display the square root symbol around , for example sqrt{b^{2} + c^{2}}These work throughout the openoffice.org programs.


What are the advantages of using Microsoft Excel over Microsoft Word?

They are different products for different purposes. Unless you define the scope of the question, it makes no sense. Excel can automatically calculate square roots and word can not.