MS Excel Quiz Sample

10 Questions | Total Attempts: 290

SettingsSettingsSettings
Please wait...
MS Excel Quiz Sample

.


Questions and Answers
  • 1. 
    To change the format of a cell we go in ---------Menubar
    • A. 

      Page Layout

    • B. 

      Insert

    • C. 

      Home

    • D. 

      Data

  • 2. 
    The Background of a sheet in Excell  lies in 
    • A. 

      Home

    • B. 

      Page Layout

    • C. 

      Formulas

    • D. 

      Review

  • 3. 
    The name of the menu bar where "Data Validation" lies is
    • A. 

      Formulas

    • B. 

      Data

    • C. 

      Review

    • D. 

      Page Layout

  • 4. 
    The shortcut key of the Hide the Ribbon is 
    • A. 

      Ctrl+Shif+F1

    • B. 

      Ctrl+R

    • C. 

      Shif+R

    • D. 

      Ctrl+F1

  • 5. 
    The "F12" is the shortcut key of 
    • A. 

      Save as

    • B. 

      Macros

    • C. 

      Hyperlink

    • D. 

      Full Screen

  • 6. 
    We can filter a sheet by pressing the 
    • A. 

      Ctrl+Shift+F

    • B. 

      Ctrl+F

    • C. 

      Ctrl+Shift+L

    • D. 

      Shift+L

  • 7. 
    To combine the text of two cells in one cell we use
    • A. 

      Delete cell

    • B. 

      Insert cell

    • C. 

      Clear cell

    • D. 

      Merge Cell

  • 8. 
    "Protect sheet" means to protect the
    • A. 

      Workbook

    • B. 

      Sheet

    • C. 

      Cells

    • D. 

      Coloumns

  • 9. 
    The function use to seek the changes made by someone in your sheet is
    • A. 

      Track changes

    • B. 

      Data validation

    • C. 

      Error checking

    • D. 

      Evaluate formula

  • 10. 
    The syntax of the "Age Calculation" is
    • A. 

      =dateif(c4,today(),"y")

    • B. 

      =dataif(c4,today(),"y")

    • C. 

      =datedif(c4,today(),"y")

    • D. 

      =datedif(c4,today,"y")

Back to Top Back to top