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. 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

2. You can convert existing Excel worksheet data and charts to HTML document by using the ?

  • Internet Assistant Wizard
  • Intranet Wizard
  • Import Wizard
  • Export Wizard

3. Which function calculates your monthly mortage payment ?

  • PV
  • NPER
  • PMT
  • All of above

4. Which among following is types of excel data types ?

  • Numbers, Formulas, Labels
  • Data, Words, Numbers
  • Words, Number, Labels
  • Equations, Data, Numbers

5. Where are the status indicators located ?

  • Horizontal Scroll
  • Vertical Scroll
  • Formula bar
  • Address bar
Read more from - MS Excel Questions Answers
Post a comment