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 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .