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
What should you do if you see a column of pound signs instead of values or results of formulas?
Increase the width of column, because it is not wide enough to show the full data that is in the cell.
Which built-in formula function can find the lowest number from a range of cells?
You can use the MIN function. If your range was A1 to A15, then your formula would be:
=MIN(A1:A15)
You can also use the SMALL function, although it is more for when you want to find a position like the second smallest or third smallest. To use it to find the smallest you would type:
=SMALL(A1:A15,1)
The 1 tells it to find the smallest. 2 would mean the second smallest and so on. To find the smallest it is better and simpler to use MIN.
Formulas can be entered in any case, but after entering them they will convert to uppercase. Spaces can also be entered with no problems, and the formulas will still work.
Made up of two values and a relational operator in excel?
It could be an equation or an expression or a condition.
What is the syntax for the SUM function?
You have the equals, the name of the function, an open bracket, what you want to sum and then close the bracket. Usually it is a range in the brackets, but it could be individuals cells or numbers. So to sum the cells from F6 to F9 we could do it different ways. The proper way is the first of the two examples, but it could be done the second way too, though nobody would do it that way.
=SUM(F6:F9)
=SUM(F6, F7, F8, F9)
What are ten things you can do with spreadsheets?
- Track your bank account transactions.
- Create an Invoice or any kind of form.
- Determine profit and loss for a small business.
- Track trends of stock prices.
- Develop a business balance sheet.
- Track expenses for a rental unit.
- Track personnel information and sort or filter by birth month.
- Create a decision matrix to evaluate various options and help determine best course of action.
- Develop a complex schedule matrix to determine who works when.
- Estimate number of personnel required, hours required, and total cost of a project.
Do you have other ideas how to use a spreadsheet? If so, please add them here:
What are three ways to re size a cell in Microsoft Excel?
Individual cell sizes cannot be changed. You have to change the width of all cells in a column or the height of all cells in a row. You can do this by putting the cursor between the headers on the rows or columns and then dragging. You can also set specific values through the Row Height and Column Width options which you can find as part of the formatting options.
What is a Formulas Version on Excel?
The formulas version shows the formulas in the cells that has them. Cells that just have values are shown with those values. Column widths automatically become wider in the formulas version so that the formulas can be seen.
Is ms Excel similar to Microsoft Word?
They are not the same. Excel is a spreadsheet that can be used to calculate and store data. Word is a program for writing documents such as letters.However, these two programs do have a number of similarities, for example the majority of Microsoft programs have a very similar toolbar area and controls, and all Microsoft programs share designs of buttons etc. It is also possible to do similar things in both. You can create tables in Word and even do formulas in them, like you would in Excel, but only to a very limited extent. In Excel you could type in text and format it like in a word processor, but it is not really ideal for doing large amounts. So depending on what you want to do, you would choose the application that is most suited to your requirements.
Excel is far more powerful than a calculator. There are a huge amount of things it can do that a calculator cannot do, far too many to mention. At a very simple level, for doing basic calculations Excel is far better. With a calculator, you can only see one number at a time. If you have a lot of figures to add, you won't be able to see them all, like you can with a spreadsheet. So it is far easier to see what you are doing and to spot any errors. You can use the same figures to do lots of calculations, and not have to type them in over and over again. Excel provides a wide range of built-in functions to use, that a calculator can't do. So there is no real comparison. Excel is a far better calculator than the Calculator on your computer is. Unless you are doing an extremely basic calculation, like adding two numbers, it is much better to use Excel.
Do Microsoft Vista systems include Word and Excel if not how can you install them into Vista?
IF EVER IT'S INSTALLED ON YOUR DEVICE, Go to: C:\program files\Microsoft Works Word is WksWP.exe (RENAMED: WORKS WORD PROCESSOR) and Excel is wksss.exe (RENAMED: WORKS SPREADSHEET) -or- Run\ [WksWP ¦ wksss] -or- start\all programs\microsoft works task launcher -and- choose at the right upper corner IF NOT INSTALLED: go on microsoft.com\Microsoft Works, where: ®·© = ±$$Bill's¢¢² /14952, New inscription for you! Was here 2008 NO 16, 18:18. *****NEXT AWNSER ¿ *****------ » Windows Vista is just an operating system like Windows XP, it does not include any Microsoft Office applications like Word and Excel. You need to get/buy license for these and need to install these separately. - Neeraj Sharma Many new computers and laptops come with a trial version Office installed which can be licensed for a fee. In this case you simply follow the instructions that will pop up when your trial period expires. If you don't have the trial version installed or you wish to get another version:
In order to install Word and Excel (both are part of Microsoft' Office Suite) you will need to buy Word and Excel seperately (not cost efficient) or together in "Office". Office comes in several configurations, so check them all out online at Microsoft.com and decide which one meets your needs first. After you have bought the version of software you need, then installing them is straightforward. Simply close all other applications you may have running, insert the CD or DVD that Office comes on. A window will pop up that begins the install process. Just follow instructions from there. (If the window doesn't pop up, then simply go to "My Computer" and click on the CD/DVD drive icon. This should start the process if the installation disc is inserted.)
-Jeff Miller
This is a false statement, not a question. If there is something you would like to know, ask a question using words that make it clear what you want to know.
What are all possible excel formulas?
There is a limited amount of functions, but there is no limit to the amount of formulas you can create, so that question is impossible to answer. It is like trying to answer "All possible sentences," which would also be impossible.
How do you fill adjacent cells with formulas in Excel?
You can copy the formulas from the first cell into the others. There are lots of ways of doing down, like using Ctrl-C to copy and Ctrl-V to paste, or using the icons on the toolbars or using the edit menu, and several other ways. You can use the fill handle to fill down. If you have selected an area down, you can use Ctrl-D. If you have selected to the right, you can use Ctrl-R to do it.
You can also select the cells you want to put the formula into and then type it in, but instead of hitting the Enter key, press and hold the Ctrl key and press Enter and it will automatically put the formula into all the selected cells, not just the first one.
Clicking the launcher in the Scale to fit group on the Page LAyout tab opens which dialog box?
hidth and height
What button is used to retrieve text from clipboard?
It is important to know how to work a computer. The buttons on most computers that retrieve items copied to the clipboard, are Ctrl+V.
How do you graph linear programming with excel?
You simply finish entering information into the worksheet, click on insert on the standard menu bar, click on a graph icon in the chart, a dialogue menu pops up and you can choose what type of graph you want to use,in this case, you click on your choice graph then it is done, a graph plots itself into the worksheet.
How do you Delete all rows on excel?
it's a pain but depending on the length of the document it may be worth it to make a macro, or make a column to the right of your data with the row numbers 1,2,3... (let auto fill do it), and then make the column next to it be the row number modulo 2 (if i remember right =(XX\2) or =mod(XX,2) where xx is the address of the column with the row number). This will alternate between 0 and 1 for the rows in that second column. Then you can sort that column in ascending/descending order (make sure it sorts the whole sheet and not just the one column) and delete either the 0's or the 1's en masse.
On October 16, 2009 at 03:46 am http://wiki.answers.com/Q/User:Mathuranathan [0] said:
Is a formula and a function the same?
An Excel Function is a instruction to excel to perform some built in task or calculation.
E.g. The function SUM(A1:A10) tells Excel to sum up all the values in cells A1, down to A10 and put the result in the cell where you typed it.
A formula is an expression that produces a result and may include functions.
E.g. A1+A2 tells Excel to sum the values in cells A1 and A2 only.
Another example of a formula is A1+SUM(A2:A10)
Both formulas and functions must be preceded by the equals sign for Excel to understand them.
A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.
All formulas must start with the equals sign.
=1+2+3
A function is a piece of code designed to calculate specific values and are used inside formulas. Functions to sum values, calculate a trigonometric cosine, and to calculate the current time are built into excel. Additional functions can be defined using Visual Basic.
Functions are typed alongside parenthesizes, where in the arguments if any are listed in between. To use functions in a formula, for example
=COS(3.14) will return the calculated cosine.
=NOW() returns the current time.
=SUM(1+2+3) *2 will multiply the sum by 2
A formula is any equation with a subject; e.g. y = 3x + 4.
A function uses a formula that produces a single value y for every valid subject x.
What is a small box or bar that is used to select an entire row?
It is often referred to as the row header or row heading or row number.
How can Microsoft Excel benefit your career choices?
It depends on your career, but knowing how to use Excel can benefit most careers. See related questions for some ways you can use Excel. Read through some of the different suggestions and see how some of the ideas may help you do your job. Almost any useful skill can benefit you in your career advancement, including the ability to use Excel to extend your capability.
Define category labels in Microsoft Excel?
It labels items on a chart. Category labels go across the bottom, on the horizontal or X-Axis. Values are normally on the Y-Axis. So if it were a bar chart, a category would have a bar coming from the X Axis and its value would be measured by what point on the Y-Axis it is equal to. The category labels tell us what that bar represents, like sales or profits or a particular year etc.
