Question

Below is given the table showing the name, department, and salary paid for different employees

Name of Employee	Department	Monthly salary
Arun	Purchase	15000
Basil	Production	8000
Celin	Purchase	18000
Denny	Production	10000
Elias	Production	7500
Famis	Sales	12000
Gopi	Finance	17000

• Find number of employees in the firm. 
• Find number of employees in Production Department. 
• Find the total monthly salary paid in Purchase Department. 
• Find the total monthly salary paid in Finance Department.

Answer 1

Procedure: 

Step 1 – Open a new blank work sheet in LibreOffice Calc.

Step2 - Enter the following details as given below.

Step 3 – Enter the following text in different cells as given below.

Cell	Text
A9	No. of employees in the firm
A10	No. of employees in the production department
A11	Total monthly salary paid in purchase department
A12	Total monthly salary paid in finance department

Step 4 – Enter the following formula in different cells as given below.

Cell	Formula
B9	= COUNTA(A2: A8)
B10	= COUNTIF(B2: B8, “Production”)
B11	= SUMIF (B2: B8, “Purchase”, C2: C8)
B12	= SUMIF (B2: B8, “Finance”, C2: C8)

Output:

	A	B
9	No. of employees in firm	7
10	No. of employees in production dept.	3
11	Total monthly salary paid in purchase dept.	15000
12	Total monthly salary paid in finance dept.	17000