download Mastguru Android App

Question Detail

You will use which feature in excel, if you want to work with one record at a time ?

  • Auto Complete
  • Auto Filter
  • Sub Totals
  • Data Form
Similar Questions :

1. Which among following can't be considered as worksheet criterion ?

  • Efficiency
  • Auditability
  • Clarity
  • Description

2. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

  • C1:10H
  • C1:H10
  • C1:H-10
  • C1:H:10

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

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

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

  • True
  • False

5. Formula palette is used to ?

  • format cells containing numbers
  • create and edit formulas containing functions
  • entered assumptions data
  • copy all cells
Read more from - MS Excel Questions Answers
Post a comment