Excel Level 3

10 Questions | Total Attempts: 223

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Advanced Excel skills.


Questions and Answers
  • 1. 
    What is known as the backstage view in Excel?
    • A. 

      The file menu

    • B. 

      Print Menu

    • C. 

      The information menu

    • D. 

      The edit menu

  • 2. 
    What language is used to create macros in Excel?
    • A. 

      Visual C++

    • B. 

      Visual Basic

    • C. 

      Java

    • D. 

      Flash

  • 3. 
    You can save and protect your workbook by using the following?
    • A. 

      Write reservation Password

    • B. 

      Protection Password

    • C. 

      Read only recommended

    • D. 

      All of the above

  • 4. 
    What are the two dates systems that Excel can use?
    • A. 

      1900 and 1904

    • B. 

      Excel can use any format

    • C. 

      2004 and 2010

    • D. 

      1900 and 2000

  • 5. 
    When you see the following in a cell - what does it mean? #DIV/0!
    • A. 

      The formula is trying to divide an empty cell

    • B. 

      You have failed to put the / sign inside the formula

    • C. 

      The cells do not exist

    • D. 

      You have inserted an incorrect cell

  • 6. 
    The Range, Criteria and Sum_range are part of which function?
    • A. 

      Nested If

    • B. 

      IF

    • C. 

      SumIf

    • D. 

      Vlookup

  • 7. 
    What is the difference between the vlookup and index and match?
    • A. 

      They are both the same

    • B. 

      The vlookup looks up data in the left column - index and match can lookup multiple columns

    • C. 

      The vlookup looks up data to the left and the Index and Match looks up data to the right

    • D. 

  • 8. 
    What does transpose mean in Excel?
    • A. 

      In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns to rows

    • B. 

      Paste Special

    • C. 

      Paste

    • D. 

      Paste without values

  • 9. 
    What is a Pivot table?
    • A. 

      A lookup table

    • B. 

      Pivot tables creates reports from information you supply

    • C. 

      A Pivot table quickly allows you to make your table look visually presentable

    • D. 

      It shows only the formulas

  • 10. 
    What are the len, left and Mid function  used for?
    • A. 

      Looking up data

    • B. 

      The functions will help to clean up data

    • C. 

      It is part of the pivot table

    • D.