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 type of text is to be printed at the top of each page in a document?
That is called a header. You can use whatever type of text you like in a header (as long as it is available on your computer).
How many types we can format computer?
There are two types of formating of computer can be done.
(A).LOW LEVEL FORMATING
(B).HIGH LEVEL FORMATING.
LOW LEVEL FORMATING:which is done by the computer empire at the time of manufacturing.so when ever it is performed it is got as same as the newly built machines. And this type of formatting is done purely by software named "DISK MANAGER".
HIGH LEVEL FORMATING:It is the formating which is done generally by us or any person using the window CD.
Can you create a word association formula in Excel?
Based on the discussion, here is what the person who asked the question wants answered.
Given:
A3:A7 --> Recipe Titles
B3:B7 --> Corresponding Recipe Ingredients
Add:
D3 --> Set Data Validation to list of items in A3:A7 (create drop-down list of recipes)
E3 --> =VLOOKUP(D3,A3:B7,2,A3:A7)
When you select a recipe from the drop-down list in D3, you will see the list of ingredients in E3.
BONUS SECTION:
In Excel 2007, on the Data Tab, click on the Data Validation icon in the Data Tools section. In the Data Validation Window, on the Settings tab, select an Allow option of List. Select the list of A3:A7 and click OK.
What does excel insert when it runs out of room on a page?
The question is not clear, but if your are talking about when you print the worksheet, I believe the answer you want is page break.
Why is the function arguments putting quotation marks around your value if true text in Excel?
Text has to be in quotation marks. If it isn't, it is treated as being the name of something, like a name that has been defined for a range of cells.
What is the present value formula?
It gives you the current value of an investment based on a fixed interest rate and payment schedule. See the link below for more information.
How do you write IF statement to calculate tax on Excel?
Taxation systems around the world are different, so there isn't one definitive answer. In simple terms, the amount of tax you pay will depend on how much you earn. An IF function can be used to do that. So if you earn over a certain amount you pay one rate, otherwise you pay a lower rate. So if we take a simple example, which you can change to suit your own system, where the wage is in B2, the threshold is in C2 and D2 is the amount to be multiplied by the tax rate and F1 and F2 are the tax rates.=IF(B 2> C2, D2* F1, D2 * F2)Tax systems tend to be a lot more complicated, so there would be other formulas involved too, so this is really a simplistic answer.
What is underlying formula in Excel?
An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.
What is the difference between a cell style and a table style?
A cell style just applies to individual cells. Table styles apply to tables in Excel and allow you to do things like have different formatting for the main part of the data and the headings and any totals you may have. A lot of these styles are built in through Autoformat.
It puts in:
&[Date]
How do you calculate an overall average from a set of component averages?
I recommend you do not try to average a set of components, because your result may be not be accurate. The best way to find an overall average is to average the entire data set.
EXAMPLE: You have three columns of ten numbers each with an average listed at the bottom of each, say A11, B11, and C11. There are two ways you can solve this:
- Combine all the averages and divide by 3. [=SUM(A11:C11)/3] - But, the result may not reflect the average of the entire data set.
- Calbulate the average for all 30 numbers in the data set. [=SUM(A1:C10)/30] - This would give a much more accurate representation of the entire data set.
What chart shows the relationship of each part of a data reference to the whole?
The most common form is a pie chart.
It shows each part of a data relative to the whole cylinder, proportionally. Some forms of bar graphs can represent not just each datum (singular for data) but the whole, as can tables listing percentages.
How do you work out the area of a circle on excel?
Area of circle = PI * R2
- In A1 enter radius of circle (e.g. 4).
- In B1 enter this formula: =PI()*A1^2
- Observe in B1 the number as the area of a circle with radius of 4.
What kind of chart is better for showing 10 categories a pie or column chart?
It depends on what you are trying to show. If you want to show how the categories relate to the entire collection of data, use a pie chart. If you want to show how the categories relate to each other, you may want to consider a column chart. Recommend you try both in Excel (it takes little effort to drop two charts on a worksheet) and see which one displays the data the way you want.
What are the three components of data series Excel?
This function can be broken up into four elements as follows:
=SERIES([Series Name],[X Values],[Y Values],[Plot Order])
CAPM: kj = krf + B (market risk premium) = krf + B (km + krf)
Note: B is Greek letter beta, which is the relationship between market returns and your portfolio.
A bar chart used when a data set is cross-categorized according to two categorical variables. One variable is regarded as the main variable and the bars representing this variable are subdivided according to the other variable.
Compound bar chart. The diagram shows the similarity between the age distributions of two European countries and the difference between these and the age distributions of countries in other continents.
called group or the number of sheets in ms excel is called work sheet . note:(it is also called work book)
How is an embedded chart updated?
Any time any data that is used in a chart changes, the charts, be they on their own sheet or embedded, will automatically update. The user does not have to do anything else, other than change the data.
How do you add and divide numbers in the same cell in Excel?
Formulas can include a mix of calculations, so you can put several in, and have very long calculations. The only thing you need to know is how calculations are done when you have a mixture of operations in a cell. In this case, all divisions will be done before any additions, no matter where they appear in the calculation. That is a law of mathematics, an spreadsheets will follow that. For example, if you take this formula:
=5+6/2
In this case, the 6 will be divided by the 2, before the 5 is added to it. If you want the 5 added to the 6 first, then you have to put brackets around that part of it like this:
=(5+6)/2
The laws of mathematics dictate that anything inside brackets is done first, which is why that happens.
o__o this is confusing me... oh, wait, yeah, youre making complete sense...
1-1=0+3=3
so yeah, id say so... maybe?
