Excel Level 3

10 Questions | Attempts: 279
Share
SettingsSettings
Please wait...
  • 1/10 Questions

    What does transpose mean in Excel?

    • In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns to rows
    • Paste Special
    • Paste
    • Paste without values
Please wait...
About This Quiz

Advanced Excel skills.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    What language is used to create macros in Excel?

    • Visual C++

    • Visual Basic

    • Java

    • Flash

    Correct Answer
    A. Visual Basic
  • 3. 

    The Range, Criteria and Sum_range are part of which function?

    • Nested If

    • IF

    • SumIf

    • Vlookup

    Correct Answer
    A. SumIf
  • 4. 

    What is the difference between the vlookup and index and match?

    • They are both the same

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

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

    Correct Answer
    A. The vlookup looks up data in the left column - index and match can lookup multiple columns
  • 5. 

    You can save and protect your workbook by using the following?

    • Write reservation Password

    • Protection Password

    • Read only recommended

    • All of the above

    Correct Answer
    A. All of the above
  • 6. 

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

    • The formula is trying to divide an empty cell

    • You have failed to put the / sign inside the formula

    • The cells do not exist

    • You have inserted an incorrect cell

    Correct Answer
    A. The formula is trying to divide an empty cell
  • 7. 

    What is a Pivot table?

    • A lookup table

    • Pivot tables creates reports from information you supply

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

    • It shows only the formulas

    Correct Answer
    A. Pivot tables creates reports from information you supply
  • 8. 

    What is known as the backstage view in Excel?

    • The file menu

    • Print Menu

    • The information menu

    • The edit menu

    Correct Answer
    A. The file menu
  • 9. 

    What are the len, left and Mid function  used for?

    • Looking up data

    • The functions will help to clean up data

    • It is part of the pivot table

    Correct Answer
    A. The functions will help to clean up data
  • 10. 

    What are the two dates systems that Excel can use?

    • 1900 and 1904

    • Excel can use any format

    • 2004 and 2010

    • 1900 and 2000

    Correct Answer
    A. 1900 and 1904

Quiz Review Timeline (Updated): Feb 20, 2013 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Feb 20, 2013
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 08, 2012
    Quiz Created by
    MarieLamb
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.