Excel Sorting And Filtering Quiz

11 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Use the data from the file "State Data Test" workbook to answer the following questions. � When you are done raise your hand and I will come by to check your test. � Good Luck!���


Questions and Answers
  • 1. 
     True or False? 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. 
    • 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 Govenors with the letter "V" in the Govenor'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. 
    True or False? Pennsylvania has 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. 
    True or False? 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