Shanti Informatics Interview Questions and Answers

Excel is used in accounting for VLOOKUPs, pivot tables, and macros to analyze and manipulate financial data.

• Excel is used to organize and analyze financial data efficiently.

• VLOOKUPs are used to search for specific information in a large dataset.

• Pivot tables are used to summarize and analyze data in a customizable way.

• Macros can automate repetitive tasks in Excel, saving time and reducing errors.

• For example, VLOOKUP can be used to match invoice numbers with customer names, piv...read more

Prepaid expenses are expenses paid in advance but not yet incurred. They are recorded as assets on the balance sheet.

• Prepaid expenses are considered assets because they represent future economic benefits.

• They are initially recorded as assets on the balance sheet and then expensed over time as they are incurred.

• Common examples of prepaid expenses include prepaid rent, insurance premiums, and prepaid subscriptions.

• To record a prepaid expense, a company debits the prepaid expens...read more

I prioritize tasks, delegate when necessary, and communicate effectively with team members to ensure deadlines are met.

• Prioritize tasks based on urgency and importance

• Delegate tasks to team members with appropriate skills and resources

• Communicate regularly with team members to track progress and address any obstacles

• Utilize time management techniques such as setting specific goals and breaking down tasks into smaller steps

• Stay organized with detailed schedules and checklists

• E...read more

Confidentiality in accounting roles is managed through strict access controls, encryption of sensitive data, and signed confidentiality agreements.

• Implementing strict access controls to limit who can view sensitive financial information

• Encrypting sensitive data to protect it from unauthorized access

• Having employees sign confidentiality agreements to ensure they understand the importance of keeping financial information private

Yes, I have found exact latlong locations on Google.

• Yes, I have used Google Maps to find exact latlong locations.

• I have entered the address or name of the location in the search bar to get the latlong coordinates.

• I have also used the 'What's here?' feature on Google Maps to get the latlong coordinates of a specific point on the map.

Excel formulas are used to perform calculations and manipulate data in spreadsheets.

• SUM: Adds up a range of cells

• AVERAGE: Calculates the average of a range of cells

• VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column

• IF: Performs a logical test and returns one value if the test is true and another if it's false

Paytm is a popular Indian digital payment platform.

• Paytm was founded in 2010 by Vijay Shekhar Sharma.

• It offers services such as mobile recharging, bill payments, online shopping, and ticket booking.

• Paytm has a digital wallet feature that allows users to store money and make quick payments.

• The platform has grown to become one of the leading payment solutions in India.

Yes, I have knowledge about Excel including formulas, functions, data analysis, and creating charts.

• Proficient in using Excel for data entry, analysis, and reporting

• Familiar with various Excel functions such as VLOOKUP, SUMIF, and IFERROR

• Experienced in creating pivot tables and charts for data visualization

• Knowledgeable about advanced Excel features like macros and conditional formatting