

InterviewSolution
Saved Bookmarks
1. |
(1x5=5)25.Answer the given questions after referring the following data:ABCDES.NO.NAMEBASIC PAY HRADA1TOTAL21AMAN1200032BALJEET 150003HARISH 14500Write the functions/formula for the following:a) To Calculate the HRA i.e. 12% of Basic pay.b) To Calculate the DA i.e. 10% of Basic pay.c) To get the TOTAL i.e. Basic pay+HRA+DA.d) To find the Maximum and Minimum Basic pay.e) What is the reference of shaded cell? |
Answer» Answer: 1263.1436 Explanation: |
|