Advanced Excel Quiz Questions And Answers

50 Questions | Total Attempts: 1774

SettingsSettingsSettings
Please wait...
Advanced Excel Quizzes & Trivia

Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your knowledge below.


Questions and Answers
  • 1. 
     _______ tab, in the Editing group, click Find & Select, and then click Go To.
    • A. 

      Data

    • B. 

      Home

  • 2. 
     On the _____tab, in the Font group,
    • A. 

      Home

    • B. 

      Data

  • 3. 
    On the ----------tab, in the Page Setup group, click Background.
    • A. 

      Page layout

    • B. 

      Home

  • 4. 
    On the ----------tab, in the Page Setup group, click Background.
    • A. 

      1.       Customize Ribbon

    • B. 

      2.       Page layout

  • 5. 
    Open a new, blank workbook
    • A. 

      CTRL+N.

    • B. 

      CTRL+s.

  • 6. 
    On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create
    • A. 

      Insert

    • B. 

      Data

  • 7. 
    On the------------ tab, in the Clipboard group, click Copy
    • A. 

      Customize Ribbon

    • B. 

      Home

  • 8. 
    Under SmartArt Tools, on the Format tab, in the _____ group, click the arrow next to Shape Outline.
    • A. 

      1.     Shape Styles group,

    • B. 

      2.       Data

  • 9. 
    If the Developer tab is not available, do the following to display it: File tab, - Options- ____________-  Developer -OK.
    • A. 

      Customize Ribbon

    • B. 

        Data

  • 10. 
      On the ________tab, in the Styles group,
    • A. 

      home

    • B. 

        Data

  • 11. 
     thesaurus in _______ menu
    • A. 

      Data

    • B. 

      Review

  • 12. 
    Sub total _______menu
    • A. 

        Data

    • B. 

      Review

  • 13. 
    Data validation from __________ menu
    • A. 

      Data

    • B. 

      Review

  • 14. 
    New coment from ______________ menu
    • A. 

      Insert

    • B. 

      Data

  • 15. 
    New coment from ______________ menu
    • A. 

      Insert

    • B. 

      Data

  • 16. 
     What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
    • A. 

      Elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows.

    • B. 

      Select the range you want, including both cells, point to Fill on the Edit menu, and then click down.

  • 17. 
    Which symbol must all formula begin with?
    • A. 

      =

    • B. 

      +

  • 18. 
    A typical worksheet has …. Number of columns
    • A. 

      128

    • B. 

      256

  • 19. 
    The  Chart wizard term data categories refers to;
    • A. 

      A chart plot area

    • B. 

      A horizontal axis

  • 20. 
    A worksheet range is a
    • A. 

      A group of cells

    • B. 

      A group of worksheets

  • 21. 
    The auto calculate feature
    • A. 

      Can only add values in a range of cells

    • B. 

      Provides a quick way to view the result of an arithmetic operation on a range of cells

    • C. 

      Option 3

    • D. 

      Option 4

  • 22. 
    You can edit a cell by
    • A. 

      Clicking the formula button

    • B. 

      Double clicking the cell to edit it in-place

    • C. 

      Option 3

    • D. 

      Option 4

  • 23. 
    Which elements of worksheet can be protected from accidental modification
    • A. 

      Scenarios

    • B. 

      All of above

  • 24. 
    Files created with Lotus 1-2-3 have an extension
    • A. 

      123

    • B. 

      WK1

  • 25. 
    Comments can be added to cells using
    • A. 

      Edit > Comments

    • B. 

      Insert > Comments