You will need
- - Excel.
Start the program Microsoft Excel. Enter table header (column names). Select the range of cells that you want violnet the calculation of the formula. Click menu "Format" — "Cells". In the tab "Number" choose the number format and set the number of decimal places — 2. Click "OK". After setting the format, you can proceed with calculations in Excel.
Enter initial data for calculations in table columns. Place the cursor in the cell where you want to get the result. Enter the = sign. Then enter the formula using the signs +, -, /, * to perform the corresponding mathematical operations. If the formula is present in a fraction, use it instead of a division sign, and the numerator and denominator enclose in parentheses.
To add into the formula the values from the cells, highlight them with the mouse. For example, to calculate the formula sum cells C1 and B1, enter in any cell the following: =C1+B1. The cell addresses you enter manually or press the left mouse button and the address will be added automatically. To finish entering the formula, press Enter.
Use AutoFill to calculate by a similar formula the values in the columns. To do this, select the cell with the formula, hover over its bottom right corner, the mouse cursor changes to a + sign in black. Hold down the left mouse button and drag down to the end of the column with the original values.
Perform a calculation using the function wizard Excel for more complex calculations. For example, to calculate the average value in the column, place the cursor in any empty cell, then on the toolbar click the "function Wizard", select the group "Statistics" — "average", click "OK".
In the opened window click the button to add a range of cells. Scroll to the desired value, press Enter. In the wizard dialog, click "OK".