Microsoft Excel is a spreadsheet application. With it, you can perform even the most complex calculations using the built-in function wizard, as well as build graphs and charts based on numerical data.
It is necessary
Excel
Instructions
Step 1
Start Microsoft Excel. Enter the table heading (column names). Select the range of cells in which you want to perform the calculation by the formula. Select the menu command "Format" - "Cells". In the "Number" tab, select the number format and set the number of decimal places to 2. Click the "OK" button. After setting the format, you can start calculating in Excel.
Step 2
Enter the initial data for calculations in the columns of the table. 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 math operations. If your formula contains a fraction, use the division sign instead, and enclose the numerator and denominator in parentheses.
Step 3
To add values from cells to the formula, select them with the mouse. For example, to calculate the sum of cells C1 and B1 using a formula, enter the following in any cell: = C1 + B1. Enter the cell addresses manually or click on them with the left mouse button and the address will be added automatically. Press Enter to complete the formula entry.
Step 4
Use the autocomplete function to calculate the values in the columns using a similar formula. To do this, select the cell with the formula, move the mouse cursor over its lower right corner so that the black + sign appears. Hold down the left mouse button and drag down to the end of the initial values column.
Step 5
Perform the calculation using the Excel Function Wizard for more complex calculations. For example, to calculate the average value in a column, place the cursor in any empty cell, then on the toolbar, click the "Function Wizard", select the "Statistical" - "AVERAGE" group, click "OK".
Step 6
In the window that opens, click on the button to add a range of cells. Highlight the desired values, press Enter. In the wizard dialog box, click on the "OK" button.
