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 function that determines whether a condition is true or false?
A logical function, such as the IF function.
Explain when a second sort is important in Excel?
If you have two columns to sort on, like firstname and surname, you will want the first sort on surname and the second sort of firstname. That way your surnames will be in order and within each surname, people will have their firstnames in order.
What two colors on Excel is better not to use?
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
You never use colours that clash. You want to be able to see your data. So you either have a dark colour on a light background or a light colour on a dark background. You never do a light colour on a light background or a dark colour on a dark background, as it will be difficult to see you data properly.
"Reach throw row go" is the way for remembering the order of preference of rescue methods when someone is in trouble in the water: Reach (with a pole, boat hook or oar) . . . Throw (a life ring, a life jacket, an empty cooler, or anything esle that floats) . . . Row (use a boat) . . . Go (into the water and swim to assist . . . the most dramatic and least prefered method since it can easily lead to two drownings)
How do you display a formula so you can edit it?
Click on the cell. Then press F2 or click in the formula bar to edit the formula.
When is it good to use a slope formula?
When formatting the equation of a given line into slope-intercept form.
What does it mean Percent style format?
It will show the number as a percentage. If you have 5 in a cell and format it to Percent Style it would show as 500%. If you had 0.73 in a cell and formatted it to Percent Style it would show as 73%.
What is a good way to compare visually a small set of numbers in excel?
You could use a chart. You could also lay them out in a table and be able to see them clearly that way and compare them.
How do you make disbursement voucher in Excel?
See related links for an example of a disbursement voucher form in Excel format.
The default value of desimal places for a number in Ms-Excel is?
Normally it is 2 when decimal places are being used.
thin black cross
What do you drag to resize the chart?
Drag the chart handles (small squares centered on each border and at each corner).
What is the difference between a lin chart and apie chart?
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
They are different in a number of ways. First visually. A line chart can have one or more lines. A pie chart is a circle divided into slices. A line chart can have more than one series. A pie chart has only one series. A line chart tracks how things change, often over a period of time. A pie chart demonstrates how much each part makes up of the whole lot.
That is column C, row 1to Column G, row 8. So in a formula it would be done as C1:G8 to reference that range. So a typical formula:
=SUM(C1:G8)
Where is text moved from and placed and where is the insertion point when you paste text?
Your question is worded in a confusing way, so let me help you sort this out.
When you highlight-copy text in MS Word, it appears in the Office Clipboard. On your PC, the text is being held in Random Access Memory (RAM) -- and remains there until your next copied text.
After copying the text, then position your cursor at the insertion point, and paste. The insertion point is wherever you place your cursor.
Copy-paste leaves the text where it was, and puts it at the insertion point.
Using the move command removes the text from where it was and puts it on hold on the Clipboard and in RAM until you place your cursor and paste the text.
What can you do in Excel that you cannot do in Access?
There are lots of differences as they are two applications designed for different tasks. Access is mainly for storing lists of data of different kinds. Excel is for Numerical Analysis and Manipulation. So its focus is on working with numbers. As such it provides a much wider range of functions than Access does.
Access stores data in tables, but with Excel it is easier to lay out tables visually and put all sorts of calculations around them, like totals and averages, together with the original data. Access can store the data in tables and do calculations, but they are not done together.
Excel provides a wide variety of charts, many very specialised, which Access does not. Excel has the power of doing extensive pivot tables and gives other ways of analysing data, which Access does not.
There are a lot of things both can do, but Excel is more versatile in what it does and it can be used in many creative and imaginative ways. Access is good at what it does, but it is designed for different kinds of tasks than Excel is. There are many other differences. When it comes to processing numeric data of any kind, Excel does far more.
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
What is the dialog box containing commands to manage connections between files in Microsoft?
The Existing Connections dialog box.
