Aster MIMS Interview Questions and Answers

Pivot tables are used to summarize and analyze large amounts of data in a spreadsheet.

• Pivot tables help in organizing and summarizing data from a spreadsheet

• They allow for easy filtering, sorting, and grouping of data

• Can quickly create visualizations like charts and graphs based on the summarized data

• Useful for identifying trends, patterns, and outliers in the data

MAT stands for Minimum Alternate Tax, which is a tax imposed on companies that show profits but have paid little to no tax due to various exemptions and deductions.

• MAT is a way to ensure that companies pay a minimum amount of tax even if they have utilized exemptions and deductions to reduce their tax liability.

• It is calculated on the book profits of a company rather than the taxable income.

• MAT rate is generally 1...read more

HRA stands for House Rent Allowance, a component of salary provided by employers to employees to cover their rental expenses.

• HRA is a part of the salary package and is provided to employees to help them with their rental expenses.

• The amount of HRA received by an employee is usually a percentage of their basic salary.

• HRA is tax-exempt up to a certain limit, based on the employee's actual rent paid and salary.

• Employ...read more

The best induction policy is one that is well-structured, informative, engaging, and inclusive.

• Clear communication of company values, goals, and expectations

• Comprehensive orientation on company policies, procedures, and culture

• Interactive sessions with key stakeholders and team members

• Training on job responsibilities, tools, and systems

• Mentorship program for new hires

• Feedback mechanisms for continuous improvement

• R...read more

Normal levels of blood investigations vary depending on the test.

• Complete Blood Count (CBC): Hemoglobin (Hb) - 12-16 g/dL for women and 14-18 g/dL for men

• Blood Glucose: Fasting blood sugar (FBS) - 70-100 mg/dL

• Lipid Profile: Total cholesterol - less than 200 mg/dL

• Liver Function Tests (LFTs): Alanine aminotransferase (ALT) - 7-56 U/L

• Renal Function Tests (RFTs): Blood urea nitrogen (BUN) - 7-20 mg/dL

• Thyroid Function ...read more