How to calculate average in Excel Select the cell to display the result e.g. cell C9 in the image shown below. Now type “=” sign in the cell and type “average” then type opening parenthesis. Now select the data, cells from C4 to C7 then press the Enter key to get the result.
How to do subtraction in Excel It is similar to addition just replace the plus “+” sign with minus sign “-“. Choose the cell where you want the result to appear as cell C6 in this example. Then type = sign in the cell, now select first cell C3 then type “-” sign then select…
Read more
Using Sigma Button to do addition in Excel Select the cell to display the result then in Home tab click on the Sigma button, on the right end of the ribbon. You will see the image given below: Now select the list of data you want to add. You will see the image shown below,…
Read more
How to do addition in Excel See the image, showing the addition of 10, 20 and 30. Choose the cell where you want the result to appear as cell C6 in this example. Then type = sign in the cell, now select first cell C3 then type “+” sign then select second cell C4, again…
Read more
How to insert symbols and special characters in Excel Select the cell where you need the symbol. Then click on the Insert tab and select Symbol command, on the right end of the ribbon. It will display a number of symbols, choose the desired symbol and click on Insert option then close the box. Symbol…
Read more
How to use spell check in Excel Select the data then click on the review tab it will display spelling command in the left corner of the ribbon. Left click on it or press F7. If there is any spelling mistake in the data, the spell check will suggest corrections in the spelling dialogue box.…
Read more
How to copy paste data in Excel Select the data, right click on it then select Copy option. Now select the cell where you want to paste the data then right click on it and select Paste option. After selecting the data, you can also press Control+C to copy and Control+V to paste the data.…
Read more
How to move data in Excel Select the data you want to move, right click on it then select the cut option then select the cell where you want to shift the data. Right click on the selected cell and select paste option. Data will be moved to the desired location.
How to delete data, rows and columns in Excel How to Delete Data Select the data you want to delete, right click on it then select delete option from the menu. You can also delete it by pressing Delete key on the keyboard. See the image: How to Delete a Row Select the row by…
Read more
How to select data in Excel There are various options to select data. The most common way is a left click on the cell then dragging the mouse over the data you want to select. Start from the upper-left cell of the data, as cell B3 in the image given below: