Press the left mouse button and hold down. This will copy the formula in the cell down to f5. Place your cell pointer in b6 and double click the autosum button. Copy the formula to c6 through f6 using the above process. Now, we will create other formulas.
All spreadsheets follow a specific order of operations when processing formulas.
Next it will do multiplication, division, addition and finally subtraction from left to right in the order in which they occur. Place your cell pointer on b10 and look in the formula bar to see the formula you entered into that cell. The result of the formula is displayed in the cell. Click on Format on the menu bar. Click on Cells, then click the Borders tab.