Excel

Today our teacher taught use how to use excel. It is a very useful program. In average businesses we usually oranguise our profits on spreadsheets but, it on paper so we have to use calculators to add and subtract, but this make life alot simpler. you just right a formula and drag it down the column and every single digit in that column will follow that formula. the formula is as follows.

There are 3 things that you could put on microsoft Excel, it is text, value and formula.

Text is what exactly what it is, text is words, sybols and other things that represent somthing but doesn't have a value, even when you wright the number out in words it isn't doesn't have a value.

Each side have their own name. This name is the Cell Adress. The cell adress is determined by the row and column titles. When you click on a cell on the top right corner you can see somthing with a letter and a numeber is is the cell adress bar and it makes it easier to find the cell adress.

Values are numbers and things that worth somthing.

All formulas start with and equals sighn or else it will be a value strand.

Formula formulas are usually operations between cells, so the value in the cells can be added subtracted or in other words could be operated. Some formulas are better that others, for exapmle if your just put formulas with values in one cell, if you messed up one cell with the value you will have to change the formula becuase it is operating with values, but if you operate with cells, if you change the value in the cells the formula will react and the column with the formula will change so the value will change. Formulas using cells have to have specific titles after the equals sighn to determine what operations to use. To make this formula go to the bar beside the cell adress bar, or just double the cell to write the formula, first put equal than the title like SUM(cell,operation,cell). After doing so whenever you change one of the 2 cells this cell will change occoding to the value of what is in the cell and the operation you are using. When you drag this cell down the column or row, the formula will be given to these cells but instead of the same cells you chose its the cells under these cell you chose because depending on where the formula goes it affects the cells you are draging it to, if the cells you chose were the on the left of it, than the cell on the bottom will have the same formula but with the cells 2 left of it so its under the cell and it will be different. Draging drags the formula and the values down the column so if you are recording bottled water sold, you will make a column for numbers of water sold, price, total. You would first make 1 cell under price, lets say 1.00 and then drag it down everything under will have 1.00 and then you just and it on the quantity on the number sold, and thand make the formula on one cell and drag it down. For the total, you just make a formula by putting equals than SUM(Cell+Cell+Cell) and so on so you click on all the sums you want to add. If you are lazy and the sums you want to add are in a strait row just click on the first cell and drag down than click enter, then thats the answer.

The text is usually used to organise things.