Excel Quiz 3

9 Questions

Settings
Please wait...
Excel Quiz 3

The quiz will test the basic knowledge of MS Excel which is very vital in our day to day job. Also, repeating the quiz will enhance your knowledge.


Questions and Answers
  • 1. 
    What is shortcut key to open cell format window?
    • A. 

      Ctrl+1

    • B. 

      Ctrl+F

    • C. 

      Ctrl+4

    • D. 

      Ctrl+Shift+Enter

  • 2. 
    Ctrl+B key makes the shortcut for making font in selected cell bold.
    • A. 

      True

    • B. 

      False

  • 3. 
     is icon on standard toolbar for following purpose.
    • A. 

      Copy

    • B. 

      Paste

    • C. 

      Painter

    • D. 

      Format Painter

  • 4. 
     is icon on standard toolbar for following purpose.
    • A. 

      Chart

    • B. 

      Formatting

    • C. 

      Conditional Formatting

  • 5. 
    Freeze Panes is option available in which of the following menu.
    • A. 

      Tools

    • B. 

      Data

    • C. 

      Windows

    • D. 

      Help

  • 6. 
    Following is shortcut to select font   option from Formatting toolbar.
    • A. 

      Ctrl+Shift+P

    • B. 

      Ctrl+K

    • C. 

      Ctrl+Shift+C

    • D. 

      Ctrl+Shift+F

  • 7. 
    Can i change the color of the worksheet tabs in my workbook? If yes, what is the shortcut key?
    • A. 

      No

    • B. 

      Yes, Alt+O+H+T

    • C. 

      Yes, Ctrl+O+H+T

    • D. 

      Yes, Shift+O+H+T

    • E. 

      Yes, Shift+O+H+M

  • 8. 
    This button represents:
    • A. 

      The AutoCorrect button

    • B. 

      The AutoFormat button

    • C. 

      The AutoSum button

    • D. 

      The conditional format button

    • E. 

      None of the above

  • 9. 
    What will be the result from this vlookup() function?
    • A. 

      Company

    • B. 

      Rebate

    • C. 

      Bookshelf Library

    • D. 

      0.01

    • E. 

      NA