# 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.
| By Dfeeley
D
Dfeeley
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,004
Questions: 11 | Attempts: 3,004

Settings

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.

• 1.

### If the data is sorted Alphabetically by "CAPITAL" Bismark is the 7th Capital listed?

• A.

True

• B.

False

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

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.

• E.

Phil Bresden is the Govenor of Utah

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

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

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

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

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

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

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

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

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

Related Topics