Microsoft Excel Sorting And Filtering Quiz!

11 Questions | Total Attempts: 2625

SettingsSettingsSettings
Please wait...
Microsoft Excel Sorting And Filtering Quiz!

What do you know about sorting and filtering in Microsoft, and do you think you can pass this quiz? Sorting is used to arrange data in Excel. It can be done in ascending or descending order. It can sort numeric and alpha numbers. Filtering is an efficient method used when you can display only data that meets specific criteria. If you want to learn more about Microsoft and Filtering, try this quiz. �


Questions and Answers
  • 1. 
    If the data is sorted Alphabetically by "CAPITAL" Bismark is the 7th Capital listed?
    • A. 

      True

    • B. 

      False

  • 2. 
    How many states have the Robin as their State Bird?
    • A. 

      5

    • B. 

      7

    • C. 

      1

    • D. 

      3

  • 3. 
    Which statement is true about the data?  
    • A. 

      There are more than one state with the blue hen chicken as its state bird

    • B. 

      Washington DC was the 51st state admitted to the Union

    • C. 

      Delaware was admitted to the Union in 1789

    • D. 

      Alaska has a population of about half of Hawaii

    • E. 

      Phil Bresden is the Govenor of Utah

  • 4. 
    How many States have Governors with the letter "V" in the Governor's name? *
    • A. 

      10

    • B. 

      7

    • C. 

      5

    • D. 

      12

  • 5. 
    How many states have a population under 1 million? 
    • A. 

      11

    • B. 

      7

    • C. 

      5

    • D. 

      12

  • 6. 
    Of the states Admitted to the Union in 1788, Which has the 5th highest population?  
    • A. 

      New Hampshire

    • B. 

      Massachusetts

    • C. 

      Maryland

    • D. 

      New Jersey

  • 7. 
    Does Pennsylvania have the 9th highest population?  
    • A. 

      True

    • B. 

      False

  • 8. 
    When pasting in Excel which "Paste Option" do you choose if you want to paste without getting the formatting (font color or size) of the website where you got the data from?
    • A. 

      Keep Source Formatting

    • B. 

      Paste Options

    • C. 

      Match Destination Formatting

    • D. 

      This is not possible

  • 9. 
    In class we used a skill to take data we copied and put the data into multiple columns; what is the skill called?  
    • A. 

      Split screens horizontally

    • B. 

      Delimited

    • C. 

      Paste Special

    • D. 

      Text to Columns

  • 10. 
    Washington DC is the 51st State?
    • A. 

      True

    • B. 

      False

  • 11. 
    How many sheets are in this workbook you are using to take the test?  
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      There are no sheets

Back to Top Back to top