Microsoft Excel Quiz: Test Your GK!

9 Questions | Total Attempts: 2540

SettingsSettingsSettings
Please wait...
Microsoft Excel Quiz: Test Your GK!

Microsoft Excel has the fundamental features of all spreadsheets. The grid of cells is in numbered rows, and the columns are letter named. It also displays data as line graphs, histograms, and charts, with a three- dimensional graphical display. If you want to learn more about Microsoft Excel, this is the quiz for you.


Questions and Answers
  • 1. 
    What is the shortcut key to open a 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 the following purpose.
    • A. 

      Copy

    • B. 

      Paste

    • C. 

      Painter

    • D. 

      Format Painter

  • 4. 
     Is icon on standard toolbar for the following purpose.
    • A. 

      Chart

    • B. 

      Formatting

    • C. 

      Conditional Formatting

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

      Tools

    • B. 

      Data

    • C. 

      Windows

    • D. 

      Help

  • 6. 
    Following is a shortcut to select font   option from the 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

Back to Top Back to top