Microsoft Excel

The Sort & Filter button is in the Editing group on the Home Tab.

Normally numbers align to the right. However, if a cell has had another alignment specifically set for it, then the number will follow that alignment.

Hold down the Ctrl key as you click the files.

A field.

The Tab key or the right arrow key will move to the next cell, to the right. You can use the other arrow keys to move to cells in other directions. Holding the Shift key and pressing the Tab key will move to the cell to the left.

A bar chart (and other graphs) enable you to quickly visualise graphically data that would be confusing if the data was simply a list of numbers.

this organizes your notes into the material you heard or read, and the questions you have.

Yes. Microsoft Excel and all spreadsheets are primarily used in business, though they can be used by anyone as they are very versatile. Excel as the market leader, has a huge range of uses that are useful for anyone.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Dan Bricklin, a business student, wanted a way of doing a spreadsheet on a computer instead of on paper, which is how they were done. One change of a number meant completely redoing it on paper. Together with a computer programmer who was a friend of his, Bob Frankston, they invented the first computerised spreadsheet. It was called VisiCalc, invented in 1978 and launched for an Apple computer in 1979.

A Calc spreadsheet is used like any other spreadsheet program. But, basically, a spreadsheet allows data to be typed in once, sorted many times, and manipulated to produce reports and graphs, etc, from the saved data, maintain customers' information (sales records, addresses, etc), and so on.

The same formatting as the cells above of them

The ribbon is the collection of tools at the top of the window.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

All three can be used as a spreadsheet. Excel is the most well known one.

Almost anyone can use Excel. It is mainly used for doing calculations, so if anyone needs to do any kind of calculation Excel can be used to do it. That would include business people, students, scientists, statisticians and even ordinary people wanting to do simple calculations or keep records of things like household budgets. Excel is very versatile, so it can do a lot of things and many people could find uses for it.

Macro is feature in MS Excel software which records all the steps and all the steps can be repeated whenever a same task is required to be performed. It helps in reduction of time in performing monotonous task. Macro is available in Tools menu.

It is used for numerical analysis and manipulation. So if you want to do a lot of calculations or analysing of figures, like getting statistical information or doing financial forecasting, then it is good to use a spreadsheet. It can just be used as a calculator to do simple calculations. It can work with many number formats and also dates and times. It can also be used for doing charts based on the numbers that are in the spreadsheet. It has other uses, like databasing capabilities, though if you have a lot of databasing requirements you are better to use an actual database application. A spreadsheet is very versatile so you will find a huge range of uses for it.

If you mean fix in the sense of have it so that the cell reference cannot change when it is copied, then you do it by making the cell reference absolute. That is done by putting a dollar sign before the column reference and a dollar sign before the row reference. So in the following formula A3 has been made into an absolute reference:

=$A$3*B3

There can be different categories of symbols used, but the ones you are referring to would be operators, such as the signs for addition, subtraction, multiplication and division. Other symbols used include brackets and symbols to aid formatting like currency symbols, decimal points and percentage signs.

The most basic function in Excel is SUM()

Other functions are AVERAGE, MIN, MAX

A collection of data organized into columns and rows generally is called a TABLE.

All you need to do is just press the arrow keys and the cursor will move in the direction of the arrow that has been pressed. If you press and hold the one of the Shift keys at the same time, then it will also select cells as the cursor moves.

function is called large. here is a link: http://chandoo.org/wp/2010/06/04/average-of-top-5-values/

still, I have tried it and had a syntax error when I have typed: =AVERAGE(LARGE(C9:H9,{1,2,3,4,5,6,7}))

I will be glad if someone can help:)

It is a formula that refers to the same cell addresses on more than one sheet. So if you wanted to add the value in C3 on Sheet1, Sheet2 and Sheet3, you would use a 3D formula. To refer to the sheet, you type its name followed by an exclamation mark and then the cell reference. You could start the formula in the cell you want the total to appear. You would type =SUM( and then click on the sheet tab for the first sheet, hold down Shift and select the tab for the third sheet, then click cell C3 and press Enter. The 3D formula created would be:

=SUM(Sheet1:Sheet3!C3)