Microsoft Excel Sorting And Filtering Quiz!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Dfeeley
D
Dfeeley
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,004
Questions: 11 | Attempts: 3,004

SettingsSettingsSettings
Microsoft Excel Sorting And Filtering Quiz! - 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

    Correct Answer
    A. True
    Explanation
    If the data is sorted alphabetically by "CAPITAL", Bismark being the 7th capital listed means that there are six capitals listed before Bismark in alphabetical order. Therefore, the statement is true.

    Rate this question:

  • 2. 

    How many states have the Robin as their State Bird?

    • A.

      5

    • B.

      7

    • C.

      1

    • D.

      3

    Correct Answer
    D. 3
    Explanation
    Three states have the Robin as their State Bird.

    Rate this question:

  • 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

    Correct Answer
    D. Alaska has a population of about half of Hawaii
    Explanation
    The statement "Alaska has a population of about half of Hawaii" is true because Alaska's population is approximately half of Hawaii's population.

    Rate this question:

  • 4. 

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

    • A.

      10

    • B.

      7

    • C.

      5

    • D.

      12

    Correct Answer
    B. 7
    Explanation
    There are 7 states whose Governors have the letter "V" in their names.

    Rate this question:

  • 5. 

    How many states have a population under 1 million? 

    • A.

      11

    • B.

      7

    • C.

      5

    • D.

      12

    Correct Answer
    B. 7
    Explanation
    The correct answer is 7. This means that there are 7 states with a population under 1 million.

    Rate this question:

  • 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

    Correct Answer
    C. Maryland
    Explanation
    Maryland is the correct answer because it is one of the states admitted to the Union in 1788 and it has the 5th highest population among these states.

    Rate this question:

  • 7. 

    Does Pennsylvania have the 9th highest population?  

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Pennsylvania does not have the 9th highest population. This means that there are 8 other states in the United States with a higher population than Pennsylvania.

    Rate this question:

  • 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

    Correct Answer
    C. Match Destination Formatting
    Explanation
    If you choose the "Match Destination Formatting" option, it means that when you paste the data into Excel, it will adopt the formatting (font color or size) of the destination cells where you are pasting the data. This option allows you to keep the formatting consistent with the rest of your Excel sheet, rather than retaining the formatting from the website where you copied the data.

    Rate this question:

  • 9. 

    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

    Correct Answer
    B. 2
    Explanation
    The answer is 2 because the question is asking about the number of sheets in the workbook being used to take the test. Since the question implies that there is a workbook being used, it can be inferred that there are at least 1 sheet in the workbook. However, since the answer options start from 1, it is safe to assume that there are 2 sheets in the workbook.

    Rate this question:

  • 10. 

    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

    Correct Answer
    D. Text to Columns
    Explanation
    Text to Columns is the skill used to take data that has been copied and paste it into multiple columns. This skill allows the user to separate the data based on a specified delimiter, such as a comma or space, and distribute it into different columns. It is a useful tool for organizing and analyzing data that is initially in a single column format.

    Rate this question:

  • 11. 

    Washington DC is the 51st State?

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Washington DC is not the 51st state. It is a federal district and the capital of the United States, but it is not considered a state. The United States has 50 states, and Washington DC is a separate entity that is not included in that count.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 14, 2011
    Quiz Created by
    Dfeeley
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.