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
How do you add a row of cells quickly in excel?
You can use the plus sign or the sum function. So if you wanted to add the values in row 1 that are in cells A1, B1, C1, D1, E1, F1, G1, H1, I1, J1 and K1 you could do it like this:
=A1+B1+C1+D1+E1+F1+G1+H1+I1+J1+K1
or as a better way:
=sum(A1:K1)
How do I move a chart to a new page within an Excel worksheet?
Right click on the embedded chart and choose 'location'.
Click radio button next to 'As new sheet' then click OK.
Al
select CHART TOOLS DESIGN TAB, then click MOVE CHART LOCATION
How do you remove hard returns in an Excel spreadsheet?
If they are in the middle of a cell there are a few things you can do. You can turn off wrap text. Press Ctrl-1 and go to the Alignment settings and if it is on, you can turn it off by removing the tick. If the hard return has been put in by the user, find the point in the text where it is, press F2 to edit the cell and use the Delete or Backspace key to remove it.
How do you find factors of a number in Excel spreadsheet?
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Use the FACT function. So to get the factorial of 5, you would enter:
=FACT(5)
Unique address of a cell that is the coordinates of the intersection of a row and column?
This is an incomplete sentance, not a question. Ask again using words that indicate what you want to know.
In Excel what are prewritten formulas designed to compute statistics called?
Statistical Functions
See related links for a list of statistical functions available in Excel.
How do you convert percentage of an hour into minutes in excel?
If you have a value of 3.4 hours in cell A1 and you want in to be converted to 3 Hours 24 Minutes into another cell, type this formula into the cell you wish to display Hrs and Mins:
=ROUNDDOWN(A1,0)&" "&"Hours"&" "&((A1-ROUNDDOWN(A1,0))*60)&" "&"Minutes"
If you want the 3.4 in cell A1 to show as 3:24, type this formula into the cell you want it to be displayed:
=ROUNDDOWN(A1,0)&":"&((A1-ROUNDDOWN(A1,0))*60)
How do you change axis values on an excel chart?
Carefully click on the axis to select it. Then right click on it and pick Format Axis. Then you can pick the scale option and adjust it to whatever values you need.
Specify that the formula in the edit line will always multiply by cell A4?
You make the cell reference an absolute one by putting in the dollar signs. So your formula could be:
=B2*$A$4
When this is copied the reference to cell A4 will not change.
How can you adjust a spreadsheet to fit?
First select the entire worksheet. You can do that by clicking on the box which is above the number for row 1 and to the left of the letter for Column A, just off the actual sheet. You could also do it by pressing the Ctrl key and holding it and then pressing the space bar, and then press one of the Shift keys and holding it and then pressing the space bar. Then go to the border between the A above column A and the B above column B, until the mouse pointer changes to a bar with an arrow pointing to the left and one pointing to the right. Then double click it. You could also go to the Format menu, pick Column and then Autofit Selection. You could also use that approach if you had just selected the actual data in your spreadsheet, as opposed to the entire worksheet.
If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) that are stored in a Microsoft Visual Basic module (module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.) and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
How do you use Microsoft Excel to multiply numbers in A column and B column?
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
You do it as follows, making sure the formula is not entered in cell A5 or cell B2:
=A5*B2
How do you copy a row in Excel?
To copy data in rows in a spreadsheet into columns, or data in columns into rows, do a regular copy. Go to the start of where you want to put it and then go to the Edit menu, pick Paste Special and click Transpose and then click OK.
How do you create a complex formula that calculates a 30 percent decrease in Excel 2010?
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
In an Excel worksheet does a column typically contain information that is similar to a list?
Yes it does, like a field in a database.
Which cell format is used by default in Excel?
The default format that Excel applies is normal text (no bold, etc.) with no color in the background of the cell. Numerals are formatted as Integers and justified right. Letters and special characters are formatted as text and justified left.
Is Microsoft access a database or a spreadsheet?
No it is not. However, there are a lot of things that both a database and a spreadsheet can do, so Access does have some capabilities to do what a spreadsheet can. Spreadsheets focus on numeric analysis and manpulation, so mostly concentrate on numbers. Databases deal with processing lists of data, some of which would be numeric, but it works with a lot of other kinds of data. Microsoft Access is a database and that is what it is designed to be, so it is not a spreadsheet.
How do you give hyperlink within excel sheet?
yes you can use hyperlink in MS Excel, Press Ctrl + K key on keyboard to put hyperlink. Also, you can have this to link between MS Excel files or website or email Sarfaraz Ahmed http://findsarfaraz.blogspot.com
Is hardware or software used in Excel?
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
Excel is software.
What do you click in the upper left corner of the Excel window to display the Office Button Menu?
Click the office icon (circle at the top left corner of the screen).
When working with predefined formulas in excel what category contains the boolean functions?
They are under the category of Logical Functions.
A graph in Microsoft Excel is pretty much anything ranging from a simple dot on a graph to a pie chart to a bubble chart to pretty much any of the charts in the drop-down menu.
