Sam International Ltd maintains their employee salary details in a spreadsheet as shown below. Write the answers based on the given spreadsheet.
(i) To calculate the DA as 25 % of BASIC + HRA for employee Harsh and display in cell D2.
(ii) To calculate the NET SALARY as BASIC+HRA+DA-PF for employee Harsh and display in cell F2.
(iii) To find the maximum NET SALARY and display in cell F9.
(iv) To count the number of employees and display in cell B10.
(v) The manager wants to graphically represent a comparative analysis of the salaries of employees. Suggest the most suitable chart type for achieving the same.
Answers
Answered by
1
Answer:
Explanation:
ohhhh please do it on excel so that it would be easy
excel has many option
Similar questions