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
Yes.
What does the AND function in Excel do?
The AND function is one of the logical functions in Excel. It used when testing more that one condition to see if all of these are true. So if you were testing for something like is someone earning over a certain amount of money and paying a certain tax rate, you would need the AND function, in conjunction with an IF function to help you achieve this. By itself it returns TRUE or FALSE. Only if all the tests are true does it return TRUE. The following one checks if 10 is less than 5 and is 6 less than 20. Obviously they are, so the function will return a TRUE value.
=AND(10>5,6<20)
The following one checks if 20 is less than 15 and is 60 more than 42. Obviously only one of those things is the case, so the function will return a FALSE value, as both must be true.
=AND(20<15,60>42)
Both of those are simple and obvious examples, but often you will be using values in cells which may or may not meet the conditions and could give different results.
=AND(A3>40,B3<10)
Which phrase best describes a spreadsheet?
They can manipulate numbers and change calculations when one number in the table changes.
What can Excel spreadsheets be used for in the home?
Excel spreadsheets are designed to make statistics, which could always come in handy when you are filling in your taxes. It could also be used to calculate your expenses or you could quickly create an invoice.
What is SUmProduct in Excel mean?
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.
=SUMPRODUCT(A2:A5,B2:B5)
The result would be 230.
What is the Fx formula on Excel?
Fx represents functions. It is on the Formula Bar and on the Insert Function Button. Clicking on it starts the process of allowing you to enter a function.
How do you explode a pie chart?
Click on a slice and the whole chart will be selected. Then drag the piece out and all of the chart will explode.
If you have multiple Excel workbooks open to close all open workbooks and exit Excel what do we do?
Click the X in the very top right of the title bar or use the Alt - F4 keyboard shortcut or the Alt - F - X keyboard shorcut.
Dividing a cell into more than one cell in Excel is called?
In Excel 2003, it was called splitting. To bring them back together it is called merging.
Would a histogram help you to data analyze data?
As a visual representation of data, then a histogram is a way of analysing data.
How do you shade a row based on one cell value in Excel?
You need to use Conditional Formatting to do that. You need to set a formula option within Conditional Formatting for the cells that look at one particular cell's value. Conditional Formatting has the option to set formatting based on values or based on formulas. In this instance you would need a formula. For example you could have a formula like this, which checks if cell A2 is greater than 10:=$A$2>10Then you can set whatever formatting you want.
What is Locked cells in excel?
They are cells that cannot be changed, usually because they have important values that the creator of the spreadsheet does not want anyone to change. Cells can be locked in such a way that only some people can change them, if they have a password. Other cells can be left open to change by anyone.
When you change the color of the fill in a cell in excel you are changing its?
When you change the color of the fill in a cell you are changing its format. This action applies to Microsoft Excel.
In Project Management, this is called a requirements document or specifications document.
Computer term for short bond paper?
There is no computer term of short bond paper but size of shot bond paper is 8.5X15 i think
How do you display worksheet in 100 percent magnification in excel 2007?
Click on view tab on the ribbon menu bar, then select 100% from the Zoom section.
Upgrade to Excel 2007 or higher. There is no way to increase the number of columns designed into the spreadsheet. Excel 2003 and earlier have a limit of 256 columns. Excel 2007 and higher has increased that to 16,000 columns.
What is the function of pre-defined function LEN in Excel?
The LEN function returns the length of the specified string.
=LEN(text)
text is the string to return the length for.
EXAMPLE:
=LEN(word) will return the value of 4.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
There are a few ways to do it. Put 1 in the first cell and 2 in the second cell. Then select both cells and then start dragging down and the values will continue to increase.
Another way is to put 1 in the first cell and in the second cell, put in a formula to add 1 to the cell above and copy the formula down.
A third way is to type 1 into the first cell. Then put the cursor on the fill handle and press and hold the Ctrl and then start to drag down and the values will continue to increase.
Which symbol may be used in an Excel formula to display current date?
The TODAY() function displays the current date. If you want to put the current date into a cell, press the Ctrl and the semi-colon key.
How do you use Excel to calulate the 75th percentile?
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:
=PERCENTILE(B2:D50,0.75)
