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
Similar Questions :

1. What excel feature can you use if you want to work with one record at a time ?

  • Auto Complete
  • Data Form
  • Set Form
  • Auto Text

2. Which among following wildcard characters are recognized by excel ?

  • + and -
  • ! and ^
  • * and ?
  • < and >

3. The default style for new data keyed in a new workbook is ?

  • Comma
  • Normal
  • Currency
  • Percent

4. Which among following is not associated with spelling dialogue box ?

  • Edit
  • Ignore
  • Ignore All
  • Change

5. The accounting style shows negative numbers in ?

  • Bold
  • Italics
  • Parentheses
  • Quotes
Read more from - MS Excel Questions Answers
Post a comment