Microsoft Excel

It brings data from several source areas together and can do things like total them or other operations. If you have two sets of data, you can combine them into one single set of data without doing it through a formula. It can be done based on position, so you could have two lists of values and add them together. You can also combine them by category. So you could have several values under different headings with more than one set, so that there are lots of values for each. So say you have a number of years with a total for each month in each year. You could consolidate the data so that all the individual January totals are added together and given as one single total.

Say you want to display A1. You would put into the cell =A1.

It is at the left end of the Formula Bar.

There are various kinds of errors in Excel that you will see. An error reference in a cell always starts with the # symbol. If the cell is a continuous line of them, it means the cell needs to be widened to show the value properly. Other than that, the # will be followed by a word to indicate the specific error and will be followed the ! symbol. Some of the ones you may see are as follows, although there are many others:

#NUM!

#REF!

#DIV/0!

#NAME!

The help system will give you assistance on what can be the cause of the particular errors you come across.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

The are a lot of statistical functions, and lots of reasons for using them. Some are very specialised and would only be used by statisticians, but some are more general and would be used by lots of users. Functions like AVERAGE, MIN, MAX, COUNT and others are very commonly used by ordinary users. So what it is you are trying to do will determine when you need to use statistical functions, or any kind of function.

Yes. You can apply the various alignment formats to it.

They are logical functions, the most common one being the IF function.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

You can sort the data in ascending or descending order.

Print preview.

No. It is a spreadsheet application. You can do simple databases in it, but it is not designed to create complex databases like relational databases. To do that you would use an actual database application.

The accounting format sets the figures into currency and sets their alignment in a standard way so that the currency symbol is always positioned in the same place as it is in all values. Currency format always puts the currency symbol right beside the numbers, so they are not always in the same position in relation to the other figures.

active cell

As many as the memory in your computer can store. The number of worksheets in each workbook is limited only by the amount of memory available.

Almost any government office will use Excel. All government offices will need to do things with numbers, and that is exactly what Excel is used for. So very few, if any, government offices will not be using Excel or a similar spreadsheet application.

Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.

When you press the tab key from the last cell in the table it adds a new blank row to the bottom of the table.

It gets a total of the values in the cells that are selected or values that are listed in the function. It is a very commonly used function as you need to do a lot of adding in a spreadsheet. There are lots of ways of using it. You could use a cell range like this:

=SUM(A2:A10)

You can use individual cells:

=SUM(A2, A12, A14,B10)

You can use actual values:

=SUM(10,34,20)

You can use it mixing any of those:

=SUM(23,A3:A65,C10,D40)

A cell can hold up to 32,767 characters, of which only 1024 can be seen in the cell. Than cannot be changed. All of the characters can be seen in the Formula Bar. What you can do is set a minimum and maximum amount of characters that can be inputted, by using the text option in the Data Validation facility.

Because you can get injury or die

There are lots of keys and key combinations that will work. You can press the Enter key. You can press the Return key. You can press the Ctrl-Enter combination. You can use the Page Up and Page Down keys. You can use the Home key. You can use the End key. You can use any of the arrow keys, if what you are typing in is not a formula.

They identify each row in the spreadsheet. The rows are numbered. Along with the column headings they can give you cell addresses, by using the column heading and row heading of a cell. Cell H34 is in column H and in row 34.

Sorry for my English :)Short answer - the interface, *IF* you are not used to it.

Long answer, considering you as a intelligent being: (I won't comment the price, of course)That's a very, very delicate question. I myself answered it a loooot of times to a looot of people. They both are programs with similar purpose. I use both of them in a daily base and I think the answer is "NO", it's not "inferior". But it's not "superior", too. They're just different. They both are better or worse based on the characteristics the job you need done.

http:/en.wikipedia.org/wiki/Comparison_of_office_suites

Yes, both of them have strong and weak points. MS Office has a lot of bells and twinkles and is easier to use, but is a way too cumbersome or too difficult or too architecturally bad to do some things done. MS Office has the better interface (I think so) and lots of marketing :) - I like MS Office to do little jobs and files that I wouldn't care to lose. I use OpenOffice to professional work (note: I'm not a designer) and files that I know I want to keep for a long time. The times I need a LOT of resources to do text editing I use a borrowed WordPerfect (a legal copy, ou course). Yet more professional and styled jobs? Call a designer and use InDesign :)

I use Excel since 1992 and Word since 1989 and in that 20 years I've seen A LOT of people lose their documents, or the files became corrupted... The internal organization of MS Office formats are a real mess, so I don't and I won't trust my important works to that suite ;)

I'm not trying to create any flamewars or trolling, that's just my reality. I have more than 10 000 documents in my computer, some are 18 years old and I can open and edit and index all of them. Be careful with the important things. I prefer a long term relationship.If I need real security or a more professional way to organize my documents across a enterprise, I usually choose OpenOffice. MS Office is locked to Windows and the Mac version is always late, so if I need to generate documents to be read on different operating systems I again choose OpenOffice. At the college (more than 10 years ago) I've used TeX (don't remember the editor) and WordPerfect and I can still today see and print the files exactly as they was at that time. Sorry MS Office, I tried for years to learn and like you as other people do, but your fancy interface with that ugly inners just got me away - but that's my thuth and not everyone's.

I know people who have only used OpenOffice and think MS Office way to work is "different", for a number of reasons, and wouldn't like to change.

I too know people who have only used MS Office and think OpenOffice way to work is "different", for another number of reasons, and wouldn't like to change, too.

And I know some people who use none of them - users of WordPerfect Office, KOffice/GnomeOffice, iWork, LyX (yes they exist and believe me, in this respect they are the happiest people I know), Google Docs, EasyOffice, Scribus...

People who uses some system (in daily base) usually hate to change their way to do the things, or the way they get their job done -- "Hey, the program can't do this and that!" "No granny, it does, look here and here." "Hummmpf, why can't be equal?". That's inertia, and the number one reason to criticism of other programs.

Be careful of "advocates" (i.e. "fanatics") of the systems, they "owns all the truth and know everything", usually have a twisted look of all the other programs. They do a very very big disservice to other people, by imposing their ideas.

So, the answer is... "DEPENDS". Use both systems. Try other ones. Think about them. Study their strong and weak points and not only the look and feel. If you've tried and tried and aren't happy with something, change. And be happy with your choices :)

Above row 1 are the column headers, though they are not generally regarded as being a row. It just has the headings for the columns in it. Above that you may have different things like the Formula Bar and other toolbars.

Formulas go into cells. You can type them directly into a cell or on the formula bar, which will then enter it into the selected cell.