MS Excel Questions Answers Online Quiz Test

• 1. Which among following is divide symbol in excel ?

  1. /
  2. D
  3. Div
  4. \

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

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

• 3. Which function converts miles to kilometers ?

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

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

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

• 5. Shortcut to edit the selected cell ?

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

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

  1. True
  2. False

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

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

• 8. Shortcut to delete the selected column ?

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

• 9. Shortcut to enter current date ?

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

• 10. When the formula bar is activated, you can see

  1. The Edit Formula button
  2. The Cancel button
  3. The Enter button
  4. All of above

• 11. Style sheet formats can be applied from ?

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

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

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

• 13. Merge cells option can be applied from ?

  1. Formatting toolbar
  2. Format Cells dialog box Alignment Tab
  3. Both of above
  4. None of above

• 14. How many recent files you can display on File menu at maximum ?

  1. 3
  2. 7
  3. 9
  4. 15

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

• 16. Entire worksheet can not be selected in one time.

  1. True
  2. False

• 17. Where are the status indicators located ?

  1. Horizontal Scroll
  2. Vertical Scroll
  3. Formula bar
  4. Address bar

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

  1. Standard
  2. Formatting
  3. Drawing
  4. Picture

• 19. What term refers to a specific set of values saved with the workbook ?

  1. Range
  2. File set
  3. Data set
  4. Scenario

• 20. We can cancel marquee by pressing ?

  1. Ctrl + Esc
  2. Alt + Esc
  3. Shift + Esc
  4. Esc