Question

The given table shows name of employees, Designation and monthly salary paid for different employees in Jose Traders.

Find out the following: 

1. The total monthly salary by naming range (TOTAL SALARY) 

2. The total monthly salary paid to marketing managers (MM) in the firm 

3. The name of employees with a monthly salary of Rs.30000 by using LOOK UP function.

Answer 1

Procedure: 

Step 1 – Open LibreOffice Calc worksheet Applications → Office → LibreOffice Calc

Step 2 – Enter the data in the appropriate cells

Step 3 – Naming a range Select the range which shows monthly salary ie C2: C7 click on “Data” from the menu bar. Select “Dene Range” Type the name “TOTAL_SALARY” in the name box and press OK or Enter key

Select the Range (C2: C7) → Data → Dene Ranges Type TOTAL_SALARY. Press OK/Enter Key

Step 4 – Enter the following formulas in respective cells.