Assignment

Calculate Total Basic Salary of all employees

Try by using all following 4 formulas

Employee Name Basic Salary
P 50000
Q 40000
R 10000
S 90000
T 8000
Total 198000

 

How to Calculate Sum

Method 1

=Sum(Select Area)

 

Method 2

Select Individually each cell

Example

=D6 + D7 + D8 + D9 + D10

 

Method 3

Home---> Autosum

 

Method 4

Alt= and Enter

 

  1. Excel

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.