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 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 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 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 :)
In Excel why do numbers appear in decimal format even when the cel is set to general?
Check the options in Excel under the tools menu. I found the answer eventually. Tools/options, edit tab. Fixed decimal places. Set this to zero.
While typing in a formula the F4 key can be used to change a cell reference to being relative, absolute and mixed. This makes it slightly quicker to do.
What is the tab color when the worksheet is active?
The tab of an active worksheet is highlighted and the text is bold. It can display whatever color you choose. When you click on a tab that is colored it displays a color that faded from white at the top to the selected color at the bottom.
Normally it appears white with black text. Tabs can also have colours set for them. When you click on a tab that has this done, a thin line of that colour will be on the bottom of the tab, with the rest of it being white.
The tab of an active worksheet is highlighted and the text is bold. It can display whatever color you choose. When you click on a tab that is colored it displays a color that faded from white at the top to the selected color at the bottom.
The title tab is highlighted in white.
As the page above the tab with a bold title.
What is OLE in Microsoft Excel?
OLE stands for Object Linking and Embedding. It is a process that Microsoft developed to allow you to embed and link document and other objects. It allows you to create a document in an application designed to create a specific object, such as a chart from PowerPoint, and embed that object in another application, such as Excel.
What is a replace command in Excel?
The replace command in Excel is the same as the replace command in other programs such as Word. If you want to change one word throughout the worksheet (or workbook, there is an option for that) you can use the replace command rather than changing each instance manually. You define the word (or phrase, number, character, whatever) that you want to remove and define what you want to replace it with.
For example if you had used the name Jane 47 times in the spreadsheet and needed to change it to James, you could use find and replace to do all at once.
If you copied the same typo throughout a spreadsheet you could use the command to fix all instances at once.
Be careful though, Excel can't tell the difference between a word and the same word as part of a larger word. For example if you wanted to replace the word "me" with the word "you" and used this command it would change words like "same" and "mean" to "sayou" and "youan"!
Before using Excel advanced filtering capabilities what must you do?
Select the block of cells you want to work on, including headings. Then go to the Data menu and pick Filter and then Advanced Filter.
How are rows and columns inserted or deleted after a table has been inserted?
it depends on what you're using
if you're using open office you get a tool bar to add or delete
How do you insert data to another cell using an Excel formula?
A formula cannot change the contents of a different cell to itself.
Here's a method that might fill the bill:
- Paste an object into the spreadsheet. I selected a smiley face from the auto shapes. It can be anything. All it will do is function as a button...heck, there are even buttons that you can paste in.
- Next, right click the object and select assign macro.
- When the macro screen comes up, you select "Record Macro"
- Select the cell that you want to provide data.
- Copy the data
- Paste the data where it is supposed to go.
- Turn off the macro recorder.
The macro will look something like this:
Sub SmileyFace1_Click()
'
' SmileyFace1_Click Macro
'
'
Range("C4").Select
Selection.Copy
Range("E4").Select
ActiveSheet.Paste
End Sub
What is the web extension for Microsoft Excel?
MS Excel does not have a web extenstion. The file extenstion is .xls or .xlsx. If you convert a worksheet to HTML, then the extensiton will be .htm or .html.
How do you add 2 values in Excel?
The 'sum' function.
Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.
What returns a number that corresponds to the system date and time beginning with December 31 1899?
DATE STAMP -- The function to show current date and time in Excel is =NOW().
Now Function
When you type numeric data in a cell Excel automatically positions the entry in the cell?
Right-aligned
When should you use numbers in Excel formulas?
If there is a value in a formula that is never going to change, then you could use it directly in the formula. So if you always have to multiply something by 10, then the 10 could be put directly into the formula and a cell reference be used for other values. So fixed values that will never change can be put into formulas.
Does Excel have the same text format and alignment shortcuts as in Word?
A lot of them are the same, but not all of them. For example, Ctrl - E does not centre text in Excel.
How do you get data labels on Excel charts from the center of data back to y axis?
I was confusing Axis Titles with Axes. The solution is to turn off Data Labels and turn on Vertical Axes.
How do I link an Excel spreadsheet item to a paragraph in a Word document?
You can use a hyperlink to link from a Word document to an Excel document. Select the text you want to act as the link and press Ctrl-K. You can then find the excel workbook you want to link to.
You can also copy from an Excel document and paste as a hyperlink, using Paste As Hyperlink in the Word document. This can link to a specific point in the Excel Workbook. You can also do a Paste Link to maintain a connection between the two files, so that when there are changes in the Excel workbook, they will be seen in the Word document.
What are similarties between word tables and excel worksheets?
- They are organized into rows and columns.
- They can have a border around the cells.
How do change an active cell to F4 in Excel?
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
You can click on the cell F4. You can press the F5 key to activate the Goto facility and then type in F4 as the cell you want to go to. You can type F4 into the Name Box, which is at the end of the formula bar and press Enter.
How many rows can you have in an Excel pivot table?
as many as number of rows in the version that is used less one row for col labl. is the max no of rows.
What can be typed and entered into a cell?
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
Any kind of data, including text, numbers, dates, times and logical data can be entered into a cell.
