Ardom Towergen HR-MIS Interview Questions and Answers

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Use the VLOOKUP function in Excel to search for a value in the first column of a table and return a value in the same row from another 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 in the range B2:D10 and retu...read more

Conditional formatting is used to visually highlight data based on specified conditions.

• Conditional formatting helps in easily identifying trends, outliers, and patterns in data.

• It can be used to highlight cells that meet certain criteria, such as values above or below a certain threshold.

• For example, in a sales report, you can use conditional formatting to highlight cells with sales figures below target in red.

• It impr...read more

There are multiple criteria functions in Excel such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, etc.

• Excel has various criteria functions like SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, etc.

• These functions allow you to perform calculations based on specified criteria.

• For example, SUMIF function adds the cells specified by a given condition or criteria.

• Another example is COUNTIFS function wh...read more