Microsoft Excel Sorting And Filtering Quiz!

1. How many states have the Robin as their State Bird?

5

7

1

3

Three states have the Robin as their State Bird.

Explanation

Three states have the Robin as their State Bird.

2. Washington DC is the 51st State?

True

False

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.

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.

3. How many states have a population under 1 million?

11

7

5

12

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

Explanation

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

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

10

7

5

12

There are 7 states whose Governors have the letter "V" in their names.

Explanation

There are 7 states whose Governors have the letter "V" in their names.

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

Split screens horizontally

Delimited

Paste Special

Text to Columns

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.

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.

6. Which statement is true about the data?

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

Washington DC was the 51st state admitted to the Union

Delaware was admitted to the Union in 1789

Alaska has a population of about half of Hawaii

Phil Bresden is the Govenor of Utah

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

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.

7. Does Pennsylvania have the 9th highest population?

True

False

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.

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.

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

True

False

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.

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.

9. How many sheets are in this workbook you are using to take the test?

1

2

3

There are no sheets

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.

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.

10. 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?

Keep Source Formatting

Paste Options

Match Destination Formatting

This is not possible

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.

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.

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

New Hampshire

Massachusetts

Maryland

New Jersey

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.

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.