0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
The insertion point shows you where the next character will be inserted in the document?
True statement, but not a question. Ask again using words that make it clear what you want to know.
Where you could find Text length in Excel?
You use the LEN function. Say you had some text in cell A2 and you wanted to find out how long it was, then you would type the following formula:
=LEN(A2)
What is the formula to calculate 149.99 minus 30 percent in Excel?
There are lots of ways of taking 30% of 149.99 away from 149.99. It is also the equivalent of getting 70% of it. Assuming the 149.99 is in cell A2, then any of these formulas will do it:
=A2 - A2 * 30%
=A2 - A2 * 0.3
=A2 * 70%
=A2 * 0.7
What factor determines how the labels and values look in Excel?
Their formatting. You can set many different formats for cells, like different number types or different fonts or different colours for the cell or the contents.
To find all individuals whose name is tom or Tim enter in the criteria row of the appropiate column?
T?m
How do you convert winmail.dat files to Excel files?
Winmail.dat files are just for use by Microsoft Outlook, to help retain an email's look in terms of formatting, like colours, font sizes etc. They are not for use in Excel and have no relevance to it.
It means two columns immediately next to each other.
How can you change the width of a column to an exact measurement?
hold down the ALT key while dragging markers on the ruler
Is the cell address unique to an excel worksheet?
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
No two cells on the same worksheet can have the same address. Different worksheets can have cells with addresses on others. So there is an A1 on Sheet1 and on Sheet2 and on Sheet3 etc. When referring to a cell it is always assumed to be the one on the current sheet. You can refer to a cell on another sheet by putting the sheetname, an exclamation mark and the cell reference. So on Sheet1 you would refer to cell A1 on Sheet2 like this:
=Sheet2!A1
It is not XML, Excel is a spreadsheet software. But you could save your worksheet as XML format as well as other formats like XLS, CSV, and many more.
What is displayed when arrow at Undo is clicked in Excel?
A list of recent actions that you can undo is displayed. You can then choose what you want to undo.
What is automatic recalculation?
Every time you make a change to anything on a spreadsheet, all formulas are automatically re-calculated, so that all data is up to date. This is known as Automatic Recalculation. A spreadsheet can be set to manual calculation, where the user has to press a key to make all the formulas recalculate. That is the F9 key in Excel. Spreadsheets are normally set to Automatic Recalculation.
How do you avail of the spelling dialog box in Excel if there is none?
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
Press the F7 key.
What is the most efficient way for entering repetitive formulae?
Usually the approach is to copy the formula. There are many ways of doing this, so it depends on the situation as to which is the best to use. It is also possible to select all the cells you want the formula to be in before you enter it, and then type the formula into one cell and press and hold the Ctrl key and then press the Enter key. The formula will be entered in all of the selected cells.
What is an example of a numeric value?
You can represent numbers as the symbol for that number, like e À (pi) or √2
The numbers above are irrational, meaning they cannot be represented as a fraction of 2 integers. But you can give the numerical value as a decimal approximation:
e = approx 2.7182818285
pi = approx 3.1415926536
√2 = approx 1.4142135624
You would need the numerical value, if you needed to give an answer to a calculation, like 'how many cubic feet of water are in a pool in a shape of a circle, 20 feet diameter, and 4 feet deep', for example.
Nobody wants to see an answer like 400*pi cubic feet. They want to see 1256.64 cubic feet (or 9400 gallons). That's what makes sense to people.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
If something is truncated, then it has been cut short, so you cannot see it all. If you have text typed into a cell that is too wide to fit and there is something in the cell beside it, the text will appear to be truncated, so you will only see the text that does fit in the cell. The other text is not lost, just not visible. There is also a TRUNC function for truncating digits off a number. You can specify how many digits to show.
=TRUNC(100.7562,2)
This will show 100.75 as it is only showing two decimal places and ignores all after that.
