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. When the formula bar is activated, you can see

  • The Edit Formula button
  • The Cancel button
  • The Enter button
  • All of above

2. How we can view a cell comment ?

  • position the mouse pointer over the cell
  • click the comment command on the view menu
  • click the edit comment commands on the Insert menu
  • click the Display comment command on the window menu

3. Which function in excel counts the numbers of characters in a cell ?

  • LENGHT
  • LGT
  • LT
  • LEN

4. What is shortcut to enter current date in cell in excel ?

  • Ctrl + ;
  • Alt + ;
  • Shift + &
  • Ctrl + $

5. In Excel Worksheet how can you show or hide the gridlines ?

  • Click Gridline tool on Forms toolbar
  • Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • Both of above
  • None of above
Read more from - MS Excel Questions Answers
Post a comment