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
Excel function that allows you to set the value in a single cell in a worksheet?
You can use a facility called Goal Seek to try to establish a value in one cell that will produce a specific result for a formula in another cell.
What is the difference between an excel table and a range?
A table is an organized group of cells for a specifc purpose. A range is a group of cells, but may or may not be organized. A table always has a range, but a range might not contain cells from a table.
What is the function of the Merge Cells option?
The function of the merge cells option is to combine multiple cells in a table. This merging can take place for different reasons such as addition.
On the Home ribbon click on Clear in the Editing section.
It displays #DIV/0! when you try to divide a number by zero. That is because it is mathematically impossible to divide something by zero, so Excel gives you that error code to indicate that it is what you tried to do.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
Yes it will.
What is the best Excel tutorial?
There are a great many Excel tutorials available on the Internet. You will find them with keyword searches such as "excel beginners tutorial" or "excel made easy."
A very good place to start is with the popular tutorial, Excel Made Easy, at www.keynotesupport.com
It is an excellent tutorial for someone brand new to Excel, it is easy to use (one webpage), and it prints nicely for later reference.
The website also has other tutorials, including excellent ones on Excel Formulas and Excel Functions - both with many examples.
What is the location that receives the data from the copy area in Excel?
It is called the clipboard and the information is stored in the computer's memory until it is cleared.
To from one worksheet to another you click the sheet tab of the desire worksheet?
This question is not clear. If you have multiple worksheets in a workbook, you can click on the tab of the worksheet you want to display. To go to another worksheet, just click on its tab.
The default name of an Excel document before saving it?
Book1.xls is the default name for a new document in Excel.
How do you cancel the formula that you entered into an excel?
You place your cursor in the cell, and delete the formula.
It will move the worksheet to the other workbook.
If an outside source requires a copy of the SOP what ensures proper receipt?
Deliver the SOP to the appropriate official of the unit and have that person sign for it
Are there any games in Microsoft Excel?
It depends on the version of Excel you have. Anything from Excel 2003 onwards does not have games, but earlier versions do. There is a game in "MS Excel 2000".The game call "Dev Hunter Game".Here the process to create the game in Excel 2000 -
Requirment :- 1)Excel 2000 2)DirectX.
To create the game,create a new file in Excel 2000 and go to File > Save as Web Page.Choose 'Publish Sheet' and 'Add Interactivity'.Next ,save and open it using Internet Explorer.You see the Excel file in the middle of the page.Go to Row 2000,and Column WC and select this row.Press and hold[Shift]+[Ctrl]+[Alt]and click the Office logo in the upper-left corner.
A car racing Spy Hunter shuld start.Use the arrow keys to steer,[Space] to fire,[O] to drop oil on the road and [H] to turn on your head-ights.
By, Udayan Raj Pramanick [ Raja ]
Source:- "Digit" July 2004 Magazine.
What is the name used for the money signs the commas and the percent signs in excel?
They are called symbols. The money sign is the currency symbol. The comma is the thousands separator symbol. The percent sign is the percentage symbol.
How do you group cells in Excel so they are treated as one when you sort?
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
Select the cells before you sort them and include any cells related to the ones that are being sorted on. So if you were sorting a list of names and for each name there was other details on the same row then you need to select not just the names, but all of the cells with the data. Then when you sort, each row will move with the first cell as it is sorted.
How do you specify cells will be italic in Microsoft Excel?
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
Select the cells you want first and then the easiest way is to press Ctrl - I. You can also go to the Format Cells dialog box, by clicking Ctrl - 1 and choose the Font tab and pick Italic under Font Style.
the sum of something is the answer of two number. 12 canot have a sum because it does not have a nouther number to add it with but if you want to find numbers that if you add them together they will turn out 12 here they are
1. 6+6=12
2. 3+9=12
3. 4+8=12
4. 12-4+5-1=12
How are numerical entries in a table formated?
They can be formatted in any way that is appropriate. If you are making a table, you will determine the numerical format of entries.
What are macros useful for in controlling what happens in a spreadsheets?
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
They can automate repetitive actions, so you can quickly do things. When you have them set up you can trust in their ability to do what you want, and not make errors.
A spreadsheet is a grid that is filled in with information. Most commonly, they're used to keep track of finances. The Microsoft program "Excel" will help you make spreadsheets, as will "Corel Word Perfect".
What are brackets used for when creating a formula or calculation?
Brackets are used for creating an array formula.
From Microsoft:
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. For example, you can place an array formula in a range of cells and calculate a column or row of subtotals. You can also place a formula in a single cell and calculate a single amount. An array formula that resides in multiple cells is called (logically enough) a multi-cell formula, and an array formula that resides in a single cell is called a single-cell formula.
To multiply the values in the array (the cell range C2 through D11), select cells E2 through E11, and then enter the following formula in the formula bar:
=C2:C11*D2:D11
Press CTRL+SHIFT+ENTER to enter the array formula (and observe the brackets in the formula).
TIP: If you later go back and edit the array formula, remember to press CTRL+SHIFT+ENTER. Don't just press ENTER or you will destroy the array formula and display an error message until you go to the cell and press CTRL+SHIFT+ENTER again.
