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 use the Comma tool in Excel?
Select some cells with numbers. Clicking on the comma tool will apply the formatting to the numbers, putting commas into the value so something like 23000 will change into 23,000.00 instead.
How do you select a range of cells as US currency in Excel?
To format a selected range of cells in Excel, click on "Format" in the cell section of the top menu bar. The keyboard shortcut Ctrl - 1 will also open the Format Cells dialog box. Next, click on "Format cells" in the drop-down menu. This will bring up a box. Click on the Number tab, then choose "Currency". Choose from a large range of symbols. The $ is the symbol for US currency.
What does the check-mark symbol mean in Excel?
Yes Choose "Insert > Symbol" and look for the character you want (you may have to select another font to find it. A font called Marlett which Windows instlls has one) If you do not have a system or version of Word that supports Unicode (the computer I an on right now does not) then that is the only one I can find. If you do have Unicode an Arial Unicode or Lucida Unicode or Symbol font will have them. Then there always is Wingdings...
üþPR
In excell windows may contain?
Your ugly matter of fact Fugly un fetich-e-ness MOM!
This is the answer to your question why you talking about my momma.
i have a burn book on you!
i will destory you LIFE!
you dnt know me i will destoy yo life
Now, go eat some cereal
because that's thwe last meal you will be eating !
i am freedy cougar daughter
im emo
and i have 7,000 children my mom is in the other room waiting on you too come out !
so BE AFRAID of me! i am Georgia.
Dont have a nice day.
im so crazy im in the nut house right now.
How do you make Microsoft Excel talk?
This code will make Excel speak the content of the first cell:
Sub SayThisCell()
Cells(1, 1).Speak
End Sub
A combination of columns and rows make up what?
There are several answers to that. Where a row and a column cross each other you get a cell. A combination of columns and rows could be a grid or a table or a spreadsheet or a range, depending on the context of your question, or the computer application you are using. Instead of a range there, you could say block and instead of a spreadsheet there, you could say a worksheet.
How do you sort column in an Excel document from 1 to 1000 if the numbers are currently 1000 to 1?
Any other time you can use this to reverse from low to high (Z-A) or low to high (A-Z). It may also appear under sort -descending or ascending. This does the same thing.
What is the feature that creates a single cell out of many cells when using excel?
Merging, or sometimes called Merge and Center, as content can be centered in the resulting cell.
Note, however, that only the content in the first (top, left) cell will be retained using the standard Merge or Merge and Center features.
When using Microsoft Excel what kind of characters can you use in your file name?
Any characters you can use in any other file name (no / \ ? % * : | " < >). You may not name the file CON, PRN, AUX, CLOCK$, NUL COM0, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9 LPT0, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, or LPT9. All restricted characters and names are reserved for other purposes.
What begins with lower case letters in the year?
There is nothing I am aware of in Excel that requires lower case letters in a year. Perhaps you need to ask this question again in the appropriate category or ask again to be more specific about what you would like to know.
How many decimals does the accounting format display in a cell in Excel?
The default is 2, but you can change the formatting to show a different amount of decimal places.
How do you delete a document name off the Excel list?
You can remove unwanted file names from the "Recent Documents" list in Microsoft Excel 2007. Here are the steps:
- Start Excel 2007 and click the MS Office button (circle at top left of the screen).
- For ï¬les you want to keep on the list, check the tack pin mark to the right of the ï¬le name in the "Recent Documents" list. The tack should change shape and color.
- Count the number of pinned ï¬les in the list and remember this number to use later.
- If you want to remove all files from the Recent Documents list, proceed to the next step. But, if you want to keep some of the files on the list, do the following steps before continuing:
- Click the "Excel Options" button at the bottom right of the MS Office window.
- In the "Excel Options" dialog box that appears, select the "Advanced" option, from the left panel of the "Excel Options" dialog box.
- Scroll down, till you reach the "Display" section.
- If you want to remove all the file names on the list, click on the up/down arrows to set the numerical value to "0."
- If you want to keep some of the file names, set the value to the number of files you counted in an earlier step.
- If you like, you can manually type the value-key in any number ranging from "0" to "50."
- In the "Show this number of Recent Documents" option, do one of the following:
- Click "OK."
- Your "Recent Documents" list will be cleared or show the number of documents you selected.
- If you checked the tack pin earlier, go back and check again to unpin the ï¬le name from the "Recent Documents" list.
- Repeat these steps any time you want to change the file names in your "Recent Documents" list.
What is the technique called that conceals data in excel?
There are many options. Two common methods are:
- Hide the row or column that contains the data. This way, you do not see that row or column.
- Change the font color to the same as the cell background (usually white). This way, the cell appears empty.
When you begin typing in a cell what appears on the formula bar?
The same thing as you type into the cell will appear in the formula bar as you type. Once you've entered something into a cell, the cell may show a number result rather than what you type in, if it is a formula.
What is the formula used in Excel to calculate interest?
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
The most common function to do this is IPMT and you can also use ISPMT.
What does hypothesis means in Excel?
In the context of a spreadsheet, it can be an idea you want to check out. You can build a series of formulas to carry out a task in order to find a solution You can try different values to see what effect they have and what result you get. To test a hypothesis means to evaluate the gathered facts with the help of an experiment. In a spreadsheet it can be called What-If analysis. What if we enter these values? What result does it give you? That is what you are doing with a hypothesis in Excel.
What are the two arguments of PMT in Excel?
PMT has the following structure:
PMT( rate, nper, pv, fv, type )
Rate is the interest rate for the loan.
Nper is the total number of payments for the loan.
Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.
Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
Type is the number 0 (zero) or 1 and indicates when payments are due.
What type of data is in a plain ASCII text file?
It would just be pure text characters, so things like letters, digits, punctuation symbols and other symbols that you can get from your keyboard. It would not be things like a photograph, which is a graphical file.
Are font sets an example of conditional formats?
Fonts can be changed when conditional formatting is used, so in that sense setting fonts are part of conditional formatting.
How do you put this formula in Microsoft Excel 10Log10milliWatts?
Put the power in milliwatts in cell A2, and then use the following formula to get the power in dBm. =10 * LOG(A2)
How do they pick the numbers for Social Security numbers?
The numbers on your Social Security card actually mean something!
Area numbers - The first three numbers originally represented the state in which a person first applied for a Social Security card. Numbers started in the northeast and moved westward. This meant that people on the east coast had the lowest numbers and those on the west coast had the highest. Since 1972, the SSA has assigned numbers and issued cards based on the ZIP code in the mailing address provided on the original application form. Since the applicant's mailing address doesn't have to be the same as his residence, his area number doesn't necessarily represent the state in which he resides. For many of us who received our SSNs as infants, the area number indicates the state we were born in. You can find out which area numbers go with each state at SSA.gov: Social Security Number Allocations.
Group numbers - These two middle digits, which range from 01 through 99, are simply used to break all the SSNs with the same area number into smaller blocks, which makes administration easier. (The SSA says that, for administrative reasons, group numbers issued first consist of the odd numbers from 01 through 09, and then even numbers from 10 through 98, within each area number assigned to a state. After all the numbers in group 98 of a specific area have been issued, the even groups 02 through 08 are used, followed by odd groups 11 through 99.)
Serial numbers - Within each group designation, serial numbers -- the last four digits in an SSN -- run consecutively from 0001 through 9999. Although SSNs are issued in some order, there is no simple way to tell a person's age based on his Social Security number.
<><>
See the Related Question below and its Related Links for more information.
