πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      In MS Excel, the 'VLOOKUP' function is primarily used

      to:
      A Create a pivot table Correct Answer Incorrect Answer
      B Find a value in a table based on a lookup value Correct Answer Incorrect Answer
      C Calculate the average of a range Correct Answer Incorrect Answer
      D Perform conditional formatting Correct Answer Incorrect Answer
      E Create a chart Correct Answer Incorrect Answer

      Solution

      The VLOOKUP (Vertical Lookup) function is used to search for a value in the first column of a table range and return a value in the same row from a specified column. Its syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). It is extensively used in finance for tasks like matching data from different lists.

      Practice Next
      ask-question