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
260 views
in Use of Spread Sheet in Business Application by (25.6k points)
closed by

Mr. Jyothis, a Plus two commerce student, entered the following details in a worksheet of LibreOffice Calc.

A B C D E F G H
1 Aralam Associates
Pay roll - June 2006
2 Name BP DA (15% of BP) HRA (5% of BP) HTA (2% of BP) Gross pay PF (6% of GP) Net Pay
3 Baby 14000
4 Shibu 12000
5 Rehman 10000
6 Shija 8000
7 Seema 6000

Write the command to calculate Net Salary

1 Answer

+1 vote
by (27.3k points)
selected by
 
Best answer
Sl. No. Cell Content
1 C3 = B3*15%
2 D3 = B3*5%
3 E3 = B3*2%
4 F3 = B3 + C3 + D3 + E3
5 G3 = F3*6%
6 H3 =F3 - G3

Fill down the calculation to remaining 4 employees

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.

...