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
What is a word or phrase that further describes a document in excel workbook?
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
You could mean its properties. It could be a worksheet or a spreadsheet.
What is semi-selection in excel?
A semi-selection in Microsoft Excel is the action of selecting a few cells in a worksheet. To select the cells, you would click on them to highlight.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
Where can one find an Excel data analysis program?
One can find an Excel data analysis program when one goes to the site of BPI Consulting. One can buy the program from the site to facilitate better statistical analysis in Microsoft Excel.
What is unprotected cell in Excel?
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.
How do you add multiply subtract and divide in Microsoft Excel?
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
You use the 4 main operators which are + and * and - and / to do those operations. You can use numbers or cell references in the formulas and all formulas begin with the equals sign. See the examples below:
=10+2
=10*2
=10-2
=10/2
=A1+A2
=A1*A2
=A1-A2
=A1/A2
You can also use some of the functions to do these tasks, most commonly the SUM function to add up lots of cell values. So if you had values in all the cells for A2 to A20, the formula to add them using the SUM function would be:
=SUM(A2:A20)
Can you make a birthday list on Excel the will automatically update a list of ages?
Yes. You can set up a formula that will calculate the age of a person based on their date of birth. Say the date of birth was in cell A3, you could have a formula like this:
=INT((TODAY()-A3)/365.25)
It won't always be perfectly accurate, sometimes out by a day around the birthday, but other than that it will show the correct age. Because it uses the TODAY() function, it will work based on the current date when the file is opened. The INT function just gets the whole number part of their age. To allow for leap years, after finding the amount of days by subtracting the date of birth from today's date, it will divide the result by 365.25.
When you might want to change a theme in a workbook?
For some spreadsheets you might want a theme that fits a particular situation, like a colour-scheme for a company or maybe something for the time of year. Themes give you a combination of styles that you can pre-define and use as required. It keeps consistency and saves you having to change all the styles each time you need them.
What are the Advantages and disadvantages of fact sheets?
Advantages
1) They are good for short- term, one- message communication efforts.
2) They are short and include important points and hence attract the people who dislike the longer messages.
3) These do not involve a lot of cost as does other tools.
4) Not everybody is aware of the computer technology, so, these are very useful for those who do not know the usage of computers.
5) Usage of Jargon or technical language can be avoided. But even if they are included, people can look it up. (There is a fine line between over simplistic and over technical language which needs to be understood.)
6) They can be prepared and distributed quickly.
Disadvantages
1) Because of being short, they have limited space and hence cover limited information.
2) A lot of things are to be considered before writing a fact sheet like the usage of appropriate language, organization of the message( as the message is supposed to fit the limited space).
3) Not a good method to use for people who have difficulty reading.
Functions of arrow keys in MS Excel?
They are mainly used for moving around a worksheet. They can be used to enter values, by pressing one after something has been typed into a cell. They can be used when editing formulas for moving through the text of the formula and also for selecting cells.
Are there steps for inserting consecutive data in a range of cells?
There are different ways. If you were doing something like putting in the numbers from 1 to 10, you could do it different ways. You could type them in individually. You could type 1 in, and in the next cell type a formula that adds 1 to the previous value and copy it down. You could type 1 in a cell, then 2 in the next cell and the select both cells and then drag and more numbers will fill in. You could use the Fill Series feature, by specifying what you want including the type of data, the start and end points, and the step value.
What is the purpose of error bars in Microsoft Excel?
Error bars are a way to graphically represent the degree of uncertainty in a reported value. When you are producing 100,000 widgets it is impractical to test every one of them, so you might test 500 selected at random and find that you have 3 defective widgets. From that you can estimate that your defect rate is 6 defects per 1000 widgets - but is that the exact rate you would find if you tested all 100,000? Possibly, but more likely you would find it was some number close to that. Statistically you would expect it to be 6±4.37 for that sample size with 95% confidence. To represent this on a graph, you would show the value as 6 with error bars reaching out 4.37 above and below the data point.
Perhaps you are measuring the number of sales at a given store up to 11 am, noon, 1 pm, 2pm, 3pm, 4pm and 5 pm on Thursday. There is some uncertainty in the exact number because any returns would later have to be deducted from the total and there may be different amounts of lag time in reporting the sales from each register. If you know that the time error is no worse than 5 minutes and that, from experience, returns average about 1%, then you could show the data point with error bars reaching from 5 minutes before to 5 minutes after the hour and an error bar reaching down 1% from the reported total sales.
How to search my Excel file if file was rename?
well. u can open excel and file u should see the recent opened files if not
try searching .xml with last modified ( when did u rename it ) then search
that's all :)
How many sheets in a tone of iron sheet?
You have failed to include needed information:
How thick of sheet, probably stated in gauge if for thin sheet metal.
How long and wide.
And did you really mean Iron sheet? This is not available anymore, you probably want to know about particular type of steel or galvanised steel.
How do bold italic and underline activate the toolbar?
Bold: Ctrl + B
Italic: Ctrl + I
Underline: Ctrl + U
Activate menu : Alt or F10
What is the difference between font and border formatting?
Font formatting affects text changing things like text size, colour, font-face etc. Border formatting affects borders around boxes, cells, pictures etc. It will change things like style, colour, thickness and combinations of borders, like having different borders on different sides.
How do you use bullets within Microsoft Excel?
Insert Symbol, then select the bullet symbol you want to use.
The default row height in a blank worksheet is 12.75 points or 17 pixels?
Default row height in Excel 2007 is 15, if you leave the default font and font size alone.
The default row height depends on the default font. For example, if you change the font and font size in Excel Options to Arial 10, the default row height will become the more familar 12.75 from Excel 2003.
A range is a collection of cells (e.g. A1:A4 is the range of the cells from A1 to A4).
How do you increase the amount of text allowed in a cell in an Excel spreadsheet?
- Increase the width of the column.
- Format cell allignment for word wrap.
A format code is a series of what that defines how a cell entry assigned a format will appear?
Excel does not use format codes. Please ask the question again using more specific words about what you would like to know and ensure your question is in the correct category.
What is better Excel or Google spreadsheet?
Creating basic spreadsheets is easy with the new Google Docs Spreadsheets. No purchase is necessary and no installation is required. All you need is an Internet connection, a Google Account, and a web browser. The program is easy to use; the working screen is uncluttered; and the many options simple to find. Google Docs Spreadsheets can be shared and edited over the Internet making them ideal for colleagues wishing to collaborate on a project without having to coordinate their schedules.
Excel is widely used in the world. It also has far more facilities than Google, so it is much more powerful. So while you have to pay for it, you are getting more for doing so. So it is the better application when everything is considered.
