Amity University Interview Questions, Process, and Tips

CAGR stands for Compound Annual Growth Rate.

• CAGR is a measure used to determine the annual growth rate of an investment over a specific period of time.

• It takes into account the compounding effect of growth over multiple periods.

• CAGR is often used to compare the performance of different investments or to project future growth.

• The formula for CAGR is: ((Ending Value / Beginning Value)^(1 / Number of Years)) - 1.

• For examp...read more

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'Vertical Lookup'

• It searches for a value in the first column of a table and returns a value in the same row from a specified column

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

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 ...read more

To copy the entire sheet without erasing the formula in Excel, use the 'Paste Special' feature.

• Select the entire sheet by clicking on the square between the row numbers and column letters.

• Right-click and choose 'Copy' or press Ctrl + C.

• Right-click on the destination sheet and choose 'Paste Special'.

• Select 'Values' or 'Formulas' depending on what you want to paste.

• Click 'OK' to paste the content without erasing the form

To give ranking in Excel, use the RANK function or sort the data and assign ranks manually.

• Use the RANK function to automatically assign ranks based on values in a range.

• For example, =RANK(A2, A$2:A$10, 1) will rank the value in cell A2 against the values in cells A2 to A10.

• Alternatively, sort the data in ascending or descending order and manually assign ranks based on the sorted order.