Navigate

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. Each excel can contain many sheets including worksheets and chart sheets.

  • True
  • False

Answer: Option A

2. Using Paste Special command which of the following you can paste selectively

  • Formulas
  • Validation
  • Formats
  • All of above

Answer: Option D

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

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

Answer: Option A

4. Shortcut to edit the selected cell ?

  • F3
  • F8
  • F4
  • F2

Answer: Option D

5. A function inside another function is known as ?

  • Round function
  • Sandwich function
  • Switch function
  • Nested function

Answer: Option D

Read more from - MS Excel Questions Answers