
Excel Quiz Questions
Authored by Moses Adejumo
Other
Professional Development
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
65 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does 'Sort Ascending' do in Excel?
Sorts from Z to A or largest to smallest
Sorts from smallest to largest or A to Z
Sorts based on header values only
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When sorting a range with multiple columns, what must you do?
Select only the column you want to sort
Select the entire range to keep data aligned
Click sort on the header cell only
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if you sort only one column in a multi-column range?
It organizes data perfectly
It maintains all relationships
It breaks the relationship between columns
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the Filter function do in Excel?
Deletes rows permanently
Hides rows that don't match criteria
Removes formatting from a table
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Where should filters be applied in a dataset?
On any random row
Below the data row
On the top row (header row)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do filters differ from table formatting?
Filters delete duplicates
Filters can be turned on/off without changing structure
Filters remove all hidden rows
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a key benefit of converting a range to a table in Excel?
It removes all filters
It creates fixed structure and shared formatting
It hides all empty cells
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?