Tuesday , March 26 2019

# Formula Max Ms-Excel 2010 – 2

The really good thing about Excel is when you start to use formulae. Using a formula Excel will make calculations for you automatically. To learn how to use formula in Excel, we will do a page of sums. We use these symbols in Excel.

 +   add –   subtract *   multiply /   divide ()  brackets are used whenever necessary

Create a worksheet to do calculations

***  Open a new Excel work book.
***  Type ADD in cell A1, SUBTRACT in cell C1, DIVIDE in cel E1, Multiply in cell G1.

***  Type all the numbers shown in te correct cells.

Selecting Cells to format

In order to change the look of certain cells by making the grid lines bold or to change the font, you
must select the cells.

***  To make a change to the whole workbook select the tope left header.

***  To make a change to a whole column select the header for the column.

***  To make a change to a whole row, select the row header.

***  Select cel A1 and hold down the left mouse button.

***  Drag the mouse across cells A1 to G1

***  Press the Bold button on the home tab to show the menu ribbon to change the font.

***  Select the Cell A4 and hold down Ctrl, while you have Ctrl held down select C4, E4 and G4.

***  Select the small arrow next to the border button to show a small drop down menu.

***  Select option to have a top and thick bottom border

This gives a neat finish to the area for your calucations.

***  Now we are going to Save our Workbook. Call the file Formula.

***  Click on Save.

Entering the Formula

We are going to use the cell references.

***  Click in cell A4
***  Type an equals sign = to tell Excel that you are going to use a calculation/formula

***  Then type a2+a3 so that the formula looks like this;

***  Press Enter and the answer will appear
***  In cell C4 type =c2-c3 and press enter

***  In cell E4 type =e2/e3 and press enter

***  In cell G4 type =g2*g3 and press enter

***  Your worksheet will now look like this;

Automatic re-calculation

The best main thing about spreadsheet is that once you have entered the formula, yu can
change the contents of the other cells and answers will still be right.

***  Change cell A2 to 175

***  Delete the contents of cells c2 and c3. Select each cell and press the delete key.
Now what is the answer in cell C4?

***  What is 60 divided by 2? Use your spreadsheet to find out.

***  What is 1.85 x 2.99? Type 1.85 into cell G2 and 2.99 into cell G3

Entering formula by pointing

You use the mouse to point to the cells in the formula instead of typing in a formula.
***  Change the numbers on the worksheet to be like this

Delete the formula in Row 4.

***  Click in cell A4 and press delete.
***  Click in cell C4 and press delete.
***  Click in cell E4 and press delete.
***  Click in cell G4 and press delete.
***  In cell A4 type = and then click the mouse  in cell A2.

***  Type + and the click the mouse in cell A3.

***  Press Enter
***  Try to enter the other formula in the same way
***  When you have finished save your workbook again.

Previews || Next || Fist

Thanks #Internet