Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
398 views
in Spread Sheet by (27.3k points)
closed by

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.

1 Answer

+1 vote
by (25.6k points)
selected by
 
Best answer

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

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...