What is the function of Vlookup formula in Excel ?

Related Mcqs:

1. What is the function of the VLOOKUP function in Excel?

   A. To perform a vertical lookup and return a value based on a specified criteria
   B. To perform a horizontal lookup and return a value based on a specified criteria
   C. To add up a range of cells
   D. To find the average of a range of cells

   Submitted by: Areesha Khan

2. What is the function of the SUM function in Excel?

   A. To add up a range of cells
   B. To find the average of a range of cells
   C. To count the number of cells in a range
   D. To find the maximum value in a range of cells

   Submitted by: Areesha Khan

3. What is the function of the IF function in Excel?

   A. To perform a logical test and return a value based on the result
   B. To add up a range of cells
   C. To find the average of a range of cells
   D. To count the number of cells in a range

   Submitted by: Areesha Khan

4. Which of these keys are used in Ms Excel to copy formula from above cell?

   A. Ctrl+ ”
   B. Ctrl+ ;
   C. Ctrl+ :
   D. Ctrl+ ‘

   Submitted by: FAWAD MATLOOB

5. Which function calculates the largest value in a set of numbers in Excel?

   A. Average
   B. Count
   C. Minimum
   D. Maximum

   Submitted by: UMAR ASGHAR SANDHU

6. In Ms Excel, which of the following special function keys allow the content in cell?

   A. Shift
   B. Esc
   C. Tab
   D. Space

   Submitted by: Malik Asghar Hussain

7. Which Shortcut keys are used to strikethrough highlighted selection in Excel?

   A. Ctrl+4
   B. Ctrl+5
   C. Ctrl+6
   D. None of the above.

   Submitted by: Farjan Ahmed Soomro

8. Move to next cell in row in Ms Excel:

   A. Tab
   B. Shift
   C. Space
   D. None of these

   Submitted by: FAWAD MATLOOB

9. In MS Excel, Conditional Formatting is in ______ tab?

   A. Home
   B. View
   C. Page Layout
   D. Insert

   Submitted by: Syed Nizakat Ali Shah

10. In Excel, Conditional formatting is in: ______________?

    A. Insert Tab
    B. Page layout
    C. View Tab
    D. Home Tab

    Submitted by: Farhan Rana