GLRA India Interview Questions and Answers

I am applying for this opportunity because of my passion for coordinating projects and my strong organizational skills.

• Passion for coordinating projects

• Strong organizational skills

• Desire to contribute to the success of the team

VLOOKUP is a function in Excel that searches for a value in the first column of a range and returns a value in the same row from another column.

• VLOOKUP stands for 'Vertical Lookup'.

• It is used to search for a value in the first column of a table and return a value in the same row from another column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, ...read more

A pivot table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.

• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired information.

• Users can easily group data, calculate totals, averages, and other statistical measures, and create customized reports.

• Pivot tables are commonly used in Excel and other spre...read more

A pivot table is a data summarization tool used in spreadsheet programs. It allows you to reorganize and summarize selected columns and rows of data.

• Select the data range you want to use for the pivot table

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

• Choose where you want the pivot table to be placed (new worksheet or existing worksheet)

• Drag and drop the fields you want to summarize into the 'Rows' and 'Values' sect...read more

Advanced Excel formulas are complex functions used to perform calculations, manipulate data, and automate tasks in Excel.

• Advanced Excel formulas can be used to perform complex calculations, manipulate data, and automate tasks.

• Examples of advanced Excel formulas include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.

• These formulas often involve nested functions, logical operators, and array formulas.

• Advanced Excel ...read more

MPR stands for Management Performance Report and QPR stands for Quarterly Performance Report. They are used to track and analyze performance metrics.

• MPR is a report that provides detailed information on the performance of an organization or department over a specific period of time.

• QPR is a report that summarizes the performance of an organization or department on a quarterly basis.

• Both MPR and QPR data are essential f...read more

Create a visually appealing PowerPoint presentation for a review meeting

• Start with a title slide introducing the purpose of the review meeting

• Include agenda slides outlining topics to be discussed

• Use visuals like charts, graphs, and images to present data and information

• Keep text concise and use bullet points for key points

• End with a summary slide highlighting key takeaways and action items