WorksheetsSorting in Microsoft Excel HEART
Total questions: 10
Worksheet time: 5mins
The arrangement of data in Z to A will arrange the data in __________ order.
Ascending
Descending
Sorting makes the data______________ to read.
difficult
easier
complex
Which option is used to arrange data in order.
insert
order
sort and filter
The Sort & Filter option is present under which tab of Microsoft Excel?
Insert Tab
Data Tab
Page Layout
View
The arrangement of data in 0 to 9 will arrange the data in the order---
Smallest to Largest
Largest to Smallest
Sorting can save our ________________
time
money
space
Sorting in Excel is arranging data according to our requirements. It can be done alphabetically or numerically.
True
False
We sort for all the possible reasons except?
help to order elements that are in a list.
it helps you quickly visualize and understand your data
organize and find the data that you want
save lots of energy and money
These are the only ways to sort data descending or ascending order and by color.
True
False
The sorting in the image is
Ascending order
Descending order
