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.
�
- 1.
If the data is sorted Alphabetically by "CAPITAL" Bismark is the 7th Capital listed?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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. 3Explanation
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 HawaiiExplanation
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. 7Explanation
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. 7Explanation
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. MarylandExplanation
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. FalseExplanation
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 FormattingExplanation
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. 2Explanation
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 ColumnsExplanation
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. FalseExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 14, 2011Quiz Created by
Dfeeley
Back to top