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 NETSALARY as BASIC+HRA+DA-PF for employee Harsh and display in cell F2.(iii) To find the maximum NETSALARY 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
Answer:
I also wants the answer
Given : Sam International Ltd maintains their employee salary details in a spreadsheet as shown below.
To Find : .
(i) To calculate the DA as 25 % of BASIC + HRA for employee in A2 and display in cell D2.
(ii) To calculate the NETSALARY as BASIC+HRA+DA-PF for employee in A2 and display in cell F2.
(iii) To find the maximum NETSALARY 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.
Explanation:
Column A - Name
Column B - Basic
Column C - HRA
Column D - DA
D2 = 0.25 * B2 + C2
F2 = B2 + C2 + D2 - E2
maximum NETSALARY and display in cell F9 =MAX(F2:F8)
B10 = COUNTA(F2:F8)
The manager wants to graphically represent a comparative analysis of the salaries of employees.
BAR CHART is a good option.
learn More:
Difference between sorting and filtering in excel - Brainly.in
brainly.in/question/8773232
i am located near top of the excel window, below the quick access ...
brainly.in/question/11521467
