MS Excel Questions Answers

• 43. Which function in excel counts the numbers of characters in a cell ?

  1. LENGHT
  2. LGT
  3. LT
  4. LEN

  Answer And Explanation

  Answer: Option D

  • Comment on this question

• 44. Which function converts miles to kilometers ?

  1. Change
  2. Covnert
  3. Shift
  4. Conv

  Answer And Explanation

  Answer: Option B

  • Comment on this question

• 45. What is shortcut to enter current date in cell in excel ?

  1. Ctrl + ;
  2. Alt + ;
  3. Shift + &
  4. Ctrl + $

  Answer And Explanation

  Answer: Option A

  • Comment on this question

• 46. Shortcut to edit the selected cell ?

  1. F3
  2. F8
  3. F4
  4. F2

  Answer And Explanation

  Answer: Option D

  • Comment on this question

• 47. Each excel can contain many sheets including worksheets and chart sheets.

  1. True
  2. False

  Answer And Explanation

  Answer: Option A

  • Comment on this question

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

  1. Ctrl + F2
  2. Ctrl + F6
  3. Ctrl + F8
  4. Ctrl + F10

  Answer And Explanation

  Answer: Option B

  • Comment on this question

• 49. Shortcut to delete the selected column ?

  1. Ctrl + -
  2. Alt + -
  3. Shift + -
  4. Insert + -

  Answer And Explanation

  Answer: Option A

  • Comment on this question