Sri Chaitanya Educational Institutions Accountant Interview Questions and Answers

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

• Used to retrieve data from a specific column in a table based on a lookup value.

• Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) looks for the value in A2 within the first column of B2:D10 and returns the corr...read more

Calculating percentages in Excel involves simple formulas using cell references to derive the desired percentage value.

• Use the formula: =Part/Total to calculate the percentage.

• Example: To find 20% of 50, use =20/100*50.

• To calculate percentage change: =((New Value - Old Value)/Old Value)*100.

• Example: For a price increase from $100 to $120, use =((120-100)/100)*100.

A pivot table is a data processing tool used to summarize and analyze data in spreadsheets.

• Allows users to reorganize and summarize selected columns and rows of data to obtain a desired report.

• Can perform calculations like sums, averages, and counts on data fields.

• Example: Summarizing sales data by product category and region.

• Facilitates quick data analysis without altering the original dataset.

• Interactive features all...read more