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. Merge cells option can be applied from ?

  • Formatting toolbar
  • Format Cells dialog box Alignment Tab
  • Both of above
  • None of above

2. To join some cells and place the content at the middle of joined cell, which tool you will use?

  • From Format Cells dialog box choose Merge and Center check box
  • Click on Merge and Center tool on formatting toolbar
  • From Format Cells dialog box select the Centered alignment
  • From Format Cells dialog box click on Merge Cells check box

3. Gridlines may be turned off for display but turned on for printing.

  • True
  • False

4. How do you change column width to fit the contents ?

  • Single-click the boundary to the left to the column heading
  • Double click the boundary to the right of the column heading
  • Press Alt and single click anywhere in the column
  • All of above

5. Insert picture option is in which of the following toolbars ?

  • Standard
  • Formatting
  • Drawing
  • Picture
Read more from - MS Excel Questions Answers
Post a comment