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 creating a vertical page break ?

  • The active cell must be in row 1
  • The active cell must be A1
  • The active cell must be in row 10
  • The active cell must be in column A

2. If you press ___, the cell accepts your typing as its contents ?

  • Tab
  • Ctrl+Enter
  • Enter
  • Alt+Enter

3. Which types of charts can excel produce ?

  • Line graphs and pie charts only
  • Bar charts, line graphs and pie charts
  • Bar charts and line graphs only
  • Only line graphs

4. Which shortcut can be used to Switch between open workbooks ?

  • Ctrl + F2
  • Ctrl + F6
  • Ctrl + F8
  • Ctrl + F10

5. On an excel sheet the active cell in indicated by ?

  • A dotted border
  • A dark wide border
  • A blinking border
  • By italic text
Read more from - MS Excel Questions Answers