MS Excel Questions Answers

• 36. What excel feature can you use if you want to work with one record at a time ?

  1. Auto Complete
  2. Data Form
  3. Set Form
  4. Auto Text

  Answer :

  Option B

• 37. Which function will you use to enter current time in a woksheet cell ?

  1. =time()
  2. =nowtime()
  3. =now()
  4. =currentTime()

  Answer :

  Option C

• 38. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  1. True
  2. False

  Answer :

  Option A

• 39. The name box appears at the ?

  1. left of the formula bar
  2. right of the formula bar
  3. below the status bar
  4. below the menu bar

  Answer :

  Option A

• 40. Protection and the Protect Sheet options can be selected from ?

  1. Data
  2. Tools
  3. Edit
  4. Format

  Answer :

  Option B

• 41. Style sheet formats can be applied from ?

  1. Table >> Autoformat
  2. Format >> Autoformat
  3. Table >> Cells
  4. Fromat >> Cells

  Answer :

  Option B

• 42. Shortcut to enter current date ?

  1. Home + ;
  2. Shift + ;
  3. Alt + ;
  4. Ctrl + ;

  Answer :

  Option D