Advanced Excel Quiz Questions And Answers

50 Questions | Total Attempts: 1216

Settings
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

  • 26. 
    Which of the following is not a worksheet design criterion?
    • A. 

      Description

    • B. 

      Clarity

  • 27. 
    Which of the following is the latest version of Excel
    • A. 

      Excel ME

    • B. 

      Excel XP

  • 28. 
    To copy cell contents using drag and drop press the
    • A. 

      Ctrl key

    • B. 

      Esc key

  • 29. 
    Which menu option can be sued to split windows into two
    • A. 

      Window > split

    • B. 

      View > split

  • 30. 
    Which of the following is not information you can specify using the solver?
    • A. 

      Input cells

    • B. 

      Constraints

  • 31. 
     Excel probably considers the cell entry January 1, 2000 to be a
    • A. 

      Label

    • B. 

      Value

  • 32. 
    All worksheet formula
    • A. 

      Return a formula result

    • B. 

      Use the addition operator

  • 33. 
    Which of the following is not a valid data type in excel
    • A. 

      Number

    • B. 

      Character

  • 34. 
    Which area in an excel window allows entering values and formulas
    • A. 

      Formula bar

    • B. 

      Standard toolbar

  • 35. 
    Which of the following is a popular DOS based spreadsheet package?
    • A. 

      Excel

    • B. 

      Lotus 1-2-3

  • 36. 
    Which of the following is not a worksheet design criterion?
    • A. 

      Description

    • B. 

      Clarity    

  • 37. 
     What is an expression that tells how the numbers in a determined set of cells are to be calculated?
    • A. 

       Formula

    • B. 

      Field

  • 38. 
     Excel is a
    • A. 

       Word processor

    • B. 

      A spreadsheet

  • 39. 
     When you insert an Excel file into a Word document, the data are
    • A. 

      Hyperlinked

    • B. 

       Placed in a word table

  • 40. 
    How are data organized in a spreadsheet?
    • A. 

       Rows and columns

    • B. 

       Height and width

  • 41. 
    When you use the fill effects in the format data series dialog box, you can not
    • A. 

       rotate text on the chart

    • B. 

       select a fore ground color

  • 42. 
      Which of the following is not a basic step in creating a worksheet?
    • A. 

      Enter text and data

    • B. 

       Copy the worksheet

  • 43. 
     Hyperlinks cannot be
    • A. 

       Pictures

    • B. 

      All can be hyperlinks

  • 44. 
    To drag a selected range of data to another worksheet in the same workbook, use the
    • A. 

       Shift key

    • B. 

       Ctrl key

  • 45. 
     In a worksheet you can select
    • A. 

       Columns

    • B. 

      ROW

    • C. 

      SHEET

    • D. 

       a, b, and c

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

      Range

    • B. 

       Scenario

  • 47. 
    You can activate a cell by
    • A. 

      A FINCTION IN OTHER

    • B. 

      NESTED

    • C. 

      SINGLE

  • 48. 
    Macros are “run” or executed from the ….. menu.
    • A. 

       Tools

    • B. 

       Data

  • 49. 
    What term describes a background that appears as a grainy, non smooth surface
    • A. 

       gradient

    • B. 

        pattern

  • 50. 
    You can edit existing Excel data by pressing the
    • A. 

       F1 key

    • B. 

       F2 key