How to calculate data in Microsoft Excel? Urdu

Calculation with Basic Functions in Microsoft Excel:

The biggest problem in these to calculate a large number of data without any error/mistakes. If we remind the past and for a minute think that time How the people calculate a large number of data? I think it would be more time consuming and expensive at that time. But recently, the time in which we use computer applications for a different type of works through which we can complete our work or task within a short time than before. 

One of the best applications in Information Technology is Microsoft Excel which is used for calculation in the different departments in the Organization for collecting, sorting, and presenting the data. From collecting to presenting the data each and every step is related to formulas through which we calculate our data in different shapes like Sum, Minus or Subtraction, Percentage, Division, and Multiplication, etc.

One by one now is going to discuss in detail below:

1. Sum 

  

Sum function uses for Adding some data or we can say that plus different figures form the data. For example =1+2+3+4=10, we can calculate this formula in different types in Microsoft Excel but here we are using one of them in below screenshot:

The formula should be like this in Microsoft Excel SUM(number1, [number2], …), instead of numbers 1 and 2 we can use a range of data like in the above screenshot look from C9: D9 means the range from C9 to D9. So we can expand this formula from C9 to Z9 and so on.

2. Subtraction or Minus

As we discussed in the above for Sum Function, we are using the Subtraction function in Microsoft Excel as well. =5-3=2, so the question is that how can we calculate in Microsoft Excel? Look in the below screenshot:

Here in the above screenshot, the function for subtraction is E9-D9 (60-50) which is equal to 10. So it is very simple to calculate subtraction in Microsoft Excel. Visit this link for tutorial related to this topic click here 

This is how you can calculate your data even small or large within a seconds and without omission or commission errors. I hope you will share your opinion about this information.

For further information visit our facebook page click here WaseemWebWork

You can visit our youtube channel click here WaseemWebWork for learning these tips practically and don't forget to subscribe our channel for upcoming videos

For contact us, you can email us click on WaseemWebWork