Prayag Group Interview Questions and Answers

Creating tables in Excel involves defining column headers, entering data, and formatting the table.

• Define column headers by selecting the first row and entering the header names

• Enter data in the rows below the header row

• Select the data and click on the 'Insert Table' button in the 'Insert' tab

• Format the table by selecting a style and adjusting column widths

• Add or remove rows and columns as needed

A pivot table is a data summarization tool used in Excel to analyze and present data in a more organized manner.

• Select the data range you want to summarize

• Go to the Insert tab and click on the PivotTable button

• Choose the location where you want to place the PivotTable

• Drag and drop the fields you want to summarize into the Rows and Columns areas

• Add any necessary calculations or filters to the PivotTable

I am a highly motivated and experienced Business Analyst with a strong background in data analysis and problem-solving.

• Experienced Business Analyst with a track record of successfully analyzing complex business processes and identifying areas for improvement

• Proficient in data analysis and using various tools and techniques to extract insights and drive decision-making

• Skilled in requirements gathering, documentation, an...read more

I am interested in joining your company because of its strong reputation, innovative projects, and collaborative work environment.

• Your company has a strong reputation in the industry, which is appealing to me as it indicates stability and success.

• I am impressed by the innovative projects your company has undertaken, such as the development of cutting-edge software solutions.

• The collaborative work environment at your co...read more

I believe that my skills and strengths are better suited for a non-technical profile.

• While I have good grades, I have discovered that my true passion lies in areas that are more people-oriented and strategic.

• I have excellent communication and analytical skills, which are essential for a business analyst role.

• I enjoy working with diverse teams and solving complex problems, which aligns well with the responsibilities of ...read more

GST rates vary depending on the type of goods or services being sold.

• GST rates range from 0% to 28%

• Some goods and services are exempt from GST

• Different rates apply to different categories of goods and services

• For example, essential items like food and healthcare have lower GST rates than luxury items like cars and jewelry

TDS has different sections with varying rates based on the type of payment and recipient.

• Section 192 - TDS on salary income

• Section 194A - TDS on interest income

• Section 194C - TDS on contractor and sub-contractor payments

• Section 194H - TDS on commission payments

• Section 194J - TDS on professional and technical service payments

• Section 195 - TDS on non-resident payments

• Rates range from 1% to 30% depending on the section an

To convince an irate customer on call, empathy, active listening, problem-solving skills, and offering appropriate solutions are needed.

• Show empathy and understanding towards the customer's frustration.

• Listen actively to the customer's concerns and let them vent their frustrations.

• Apologize for any inconvenience caused and take responsibility for resolving the issue.

• Offer appropriate solutions or alternatives to addres...read more