download Mastguru Android App

Question Detail

VLOOKUP function used to ?

  • Finds related records
  • Looks up text that contain "v"
  • Check if two cells are identical
  • None of above

Answer: Option A

Similar Questions :

1. The name box appears at the ?

  • left of the formula bar
  • right of the formula bar
  • below the status bar
  • below the menu bar

Answer: Option A

2. One cell format can be copied to another cell by using ?

  • Format Painter
  • Format Setting
  • Format Showing
  • Format Checking

Answer: Option A

3. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  • True
  • False

Answer: Option A

4. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

  • NOT
  • OR
  • IF
  • AND

Answer: Option C

5. To open an existing workbook, click the Open button on the ___ toolbar ?

  • Form
  • Standard
  • Drawing
  • Formatting

Answer: Option B

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs