Question

Below is given the table showing the Name, Department, and Salary paid for different employees.

• Name the employee name column as “Emp Name”, Department column as “Dept” and monthly salary column as “Salary”. 
• Find the total monthly salary.

Answer 1

procedure: 

Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details in respective cells.

Step 3 – Select the range A2: A6, From the Data tool menu, select “Dene Range” and – give name as “ Emp Name” and click (OK) button. 

Step 4 – Select the range B2: B6, From the Data tool menu, select “Dene Range” and give name as “Dept” and click (OK) button. 

Step 5 – Select the range C2: C6, From the Data tool menu, select “Dene Range” and give name as “Salary” and click (OK) button. 

Step 6 – Enter the following formula to nd out the total monthly salary.

Cell	Text/formula
A7	Total monthly Salary
B7	=SUM(salary)

Output:

Total Monthly Salary

12500