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
Undo
What is the use of move or copy sheet tab in Microsoft Excel?
If you have two workbooks and want to move a worksheet from one to the other, you would use the move option. If you want to copy the worksheet so that it is in both workbooks, you would use the copy option.
How do you add the workbook file name in the center of the footer on every page of your printout?
You go to the footer first, which can be accessed on the View tab or View menu. Once you are there, there are a number of options that you can click on to enter particular elements. The one you want is the file name. If you click on it, it will be entered into the footer.
How do you change a line chart to a column chart?
If you click on the chart and then right-click on the mouse and pick Chart Type and then choose the column chart you want.
What is used to create a cell name from column and row titles in Excel?
The following is copied from the Help dialog box in MS Excel 2000. A search for 'name cells' or 'cell label' should get the directions that you're looking for:
Name cells by using existing row and column labels
- Select the range you want to name, including the row or column labels.
- On the Insert menu, point to Name, and then click Create.
- In the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
How do you change column width to fit the contents?
Click on the letter at the top of the spreadsheet for the column you want to resize. Click the "Home" tab. Click on "Format" in the "Cells" area on the ribbon. Click on
"Autofit column width". This will size the column to the largest cell in the column.
What is an input in a spreadsheet?
It is something that goes into a spreadsheet. It can be text you type into a cell or data you import from an external source.
In a complex formula subtraction will be performed multiplication?
This is not a question. It is not even a complete statement. Ask again using words that make it clear what you want to know.
How you copy the document acrobat reader to ms Excel sheet?
You do not, unless you have Acrobat or some other software that can edit PDF files. An acrobat PDF file is basically a picture of the document. If you can edit the file, sometimes you can SaveAs, but if all you have is a PDF file and MS Excel, you will not be able to convert to a worksheet. You can, however, import as an object into Excel and display the page in a worksheet. This will be the same as importing an image; you can display the image, but you will not be able to edit the contents.
What is the formula for sound on spreadsheet?
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
What function can not be done by using a spreadsheet?
There is an almost infinite list of things (or functions if you prefer) that can not be achieved using a spreadsheet. I will write some for you to encourage your own imagination. You can not:
1. Achieve escape velocity and launch a rocket into space using a spreadsheet.
2. Paint a masterpiece using a spreadsheet.
3. Turn a base metal into gold using a spreadsheet.
There are many more.
What is the physical major difference in a mixed reference and an absolute reference?
A mixed reference has only one dollar symbol. An absolute reference has two dollar symbols:
$A3 is mixed.
A$3 is mixed.
$A$3 is absolute.
A3 is relative.
A mixed reference only locks the column or only the row, when copying a formula. In most instances where people use an absolute reference, a mixed reference would work. Most formulas are either copied down or across, but rarely both down and across. If you were using A3 in a formula and wanted to make it absolute, then you consider these things:
If a formula is copied down, then it is only necessary to lock the row, so A$3 is sufficient.
If a formula is copied across, then it is only necessary to lock the column, so $A3 is sufficient.
In both cases, $A$3 would work, but depending on which direction you are copying, you would only need one of the mixed forms. As most people don't know the way mixed references can be used, they just use an absolute. It is only if a formula is being copied into a block, so both down and across, that an absolute is needed.
A group of cells is called a range.
PV : the present value - the loan we are going to get now.
What indicates where the text will be inserted?
cursor's insertion point -- usually looks like a small I-beam
What happen when you click on the column headings?
when you click on the column headings, the entire columns will be highlighted
What effect does the comma style format have on selected cells?
It puts commas in to break the groups of thousands. They are sometime called thousand separators. Before being formatted you could have a number like 16777216. When it is formatted to the comma style it will appear as 16,777,216.00 including the two decimal points at the end. They can be removed if you wanted.
What is the forward slash used for in spreedsheets?
The forward slash (/) is the division symbol in Excel. =A1/A2 divides the value of cell A1 by the value of cell A2.
How can one create a retirement calculator in Excel?
There are many complicated ways to create a retirement calculator in Excel. The easiest way is to download a template that is offered for free from Microsoft and fill in all your information there.
How do you make the information on one Excel sheet the same as on another Excel sheet?
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
