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
In Excel what is used to perform mathematical problems?
yes you can do math in excel, it is very easy.
In Excel where is the Insert Function button located?
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
On the Formulas ribbon and also beside the Formula bar.
You insert the second IF function into the first one, creating what is called a nested If. Another IF can be put in the True or False part of an existing IF function. In as situation where there is a need for another IF when the first condition is true, the structure could then be something like this:
=IF(condition, IF(condition, true, false), false))
Note there are two brackets at the end, closing the two IF functions.
What is a fx toolbar in Microsoft Excel?
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
It is the function toolbar. The fx is a mathematical way of representing functions.
A formula containing a relative cell address looks to different cells based on a relative position to the cell containing the formula. So, if you had a formula in cell B1 which included the information from relative cell address A1, that formula, when copied to another cell will always look for the information in the cell directly to it's left on the same row. Copy that formula to B2 and the formula will use the information from A2...copy the formula to T64 and the formula will use S64. A formula containing an absolute cell address will always look to the exact same cell regardless of where you copy the formula. So if the formula in B1 contained absolute cell address A1, that formula will always look to A1, whether you copy it to B2 or T64. You can also have an address which is part relative and part absolute - so a formula will always look to a specific row but different columns (if the row is absolute and the column is relative), or the same column but different rows (if the column is absolute and the row is relative). So, if you wanted to use information contained along row 2 of each column, but the formula might be on different rows in different columns, you could make the row absolute and the column relative. so the formula in A7 would use A2, the same formula in B6 would use B2, the same formula in C26 would use C2.
When text is longer than the width of a column and text wrapping is turned off?
It depends, if the next cell is blank that the cell will extend normally to allow the text to be displayed.
However, if the cell is occupied it will display something along the lines of ##### to indicate the column width is not sufficient; the solution to which are as follows:
- Extend the column width by placing your arrow on the line next to the letter until your cursor changes and click and drag to the desired width.
- Set the cell to 'wrapped text' by right clicking on the cell and going to format, and extend the row height using the same method as mentioned in 1. but with the row instead of the column.
- Reduce the length of the text in the cell
- Reduce the font size of the text in the cell
Why do you use formatting in Excel?
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.
How do you get the median of a range of numbers that match a specified criteria in Excel?
You have to use the MEDIAN and IF function together and then enter it as an array formula. Say you wanted to find the median of values in cells from E2 to E27 that were over 20, you would type this in.
=MEDIAN( IF( E2:E27>20, E2:E27 ) )
To enter it as an array formula, you must press Ctrl- Shift - Enter together. The formula will then appear with curly braces around it, indicating that it is an array function.
Who would most likely use a spreadsheet every day as part of their job?
It would be impossible to say. A spreadsheet is so versatile that there are a wide range of jobs that would find it useful. Jobs which involve a lot of dealing with numbers would particularly use it. So anyone in financial work, accountancy, statistics etc. would be likely to use a spreadsheet a lot. You could not really pick one single job though.
How do you create a bin range in Microsoft Excel?
Bin ranges normally represent a set of values to be used in a function, like for creating Histograms. Bin numbers represent the intervals that you want the Histogram tool to use for measuring the input data in data analysis. When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data. Bin ranges can be found in other things too, and you will sometimes see functions asking for them.
What are the benefits of using range names in Excel fomulas?
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
It reduces down the mistakes people make by typing incorrect cell references. It can be easier to remember them than remembering cell references. It can make your formulas make more sense when you look at them so that it is easier to know what they are doing. Something like =Sales+Tax is more obvious than =B40+C5 when you look at them. It is particularly useful when your formulas are long and complex.
What is a category axis on a spreadsheet chart?
The category labels will be across the bottom, so they are on the X axis which is the horizontal axis.
Are column headings identified by coulmns?
Column headings have letters in the to represent the columns.
Explain the purpose of using multiple worksheet within one spreadsheet file?
There are many reasons why you would do it. For example you could have a business with different offices in different regions. The head office might put figures from the regional offices onto different sheets, like their amounts of sales, and then have one sheet which totals them all up. They could then see the individual offices and the totals all in one sheet, rather than having them in separate files. That is more efficient and saves space and allows you to do lots of calculations from figures on the different sheets. It is also better than have the different regional figures all together in one single sheet, as it would make it harder to control and navigate through. They can lay things out in the exact same cells in each sheet, making calculations easier to do. So the total sales in each sheet could be in cell D54 and knowing that they are all in D54 on each sheet can make it easier to do calculations to total them on another sheet.
Another reason might be to have things that are loosely related to each other all in different sheets in one spreadsheet. Using a business example again, they could have sales in one sheet, purchases in another, wages in another, stock levels in another and so on. All of these are aspects of their business. There would be some connections between some parts, so they could have calculations that might involve their sales and their stock levels. It can be handier to have them together in several sheets, rather than in separate files.
So there are many advantages to using several worksheets within one workbook.
What are the restrictions on Solver referred to in Excel?
They are called Constraints. They are restrictions on what values can be used, like setting maximum or minimum values for cells.
Yes, that works (in Microsoft Word at least). For example, a chemical formula might be HCl (hydrogen H, plus chloride Cl), but Word will find the second capital letter suspicious (since that is a common typing error) and change it to Hcl, which in this particular case is wrong. Ctrl-Z will undo the auto-correction.
a spreed sheet allows you to display information clearly and quickly. it allows you to solve problems and can help you with businesses
Why is it more advantageous to use a header or a footer to insert page numbers?
Because your pages will be automatically numbered, no matter how many pages you have in the document and what changes you make. There are also extra facilities available, like giving the total of the pages in the document. Again this can be calculated automatically, so you do not have to worry about it or change it as the amount of pages in a document changes. You can also put a standard formatting on them and be sure they are in the same location on each page, or have their positions changing on odd and even numbered pages.
Excel will use the standard order of operations according to the laws of mathematics. See the related question below.
Error messages always begin with what symbol?
The pound or number (#) symbol.
#
An example would be: #REF! or #VALUE!
What are the parts of an ivcdv chart?
its kinda like 3 lines and u name the first one independent variable ot iv and so on then you try to find what they are
How do you activate the format painter button?
Click on the cell that you want to take formatting from. If you click once on the Format Painter, you can then click on another cell and it will receive the formatting from the other cell and the Format Painter will be deactivated. If you double click on the Format Painter, then it is turned on until you click on it again, meaning you can apply formatting to lots of cells.
What is the name of the button you click to sum cells in Excel?
You use the sum button in excel when you want to add numerous amounts of numbers.
