NEW
Font size
WorksheetsCLASS 7 COMPUTER CH-3 QUIZ
Total questions: 11
Worksheet time: 4mins
The rearrangement of data in ascending (A-Z) or descending (Z-A) orders is called _______________ .
Filtering
Clear Rules
Sorting
Custom Filter
When data is arranged in ascending or descending order for only 1 column is called __________ .
Multiple Column Sorting
One Bar Sorting
Single Column Sorting
None of the above
__________ is used to format the cells based on the set of specified conditions . You may change the font , font color , highlights and so on .
Conditional Formatting
Clear Conditional formatting
Subtotal
My own Formats
Sorting is done in ___________ ways .
One
Two
Three
Four
_______________ is an option in Microsoft Excel that helps you locate the data you wish to find and hide the rest .
Add level
My own Sheet
Sort it up
Filtering
Which function is the above image showing .
Sorting
Filtering
Rearrange
Conditional Formatting
In case you edit data and wish to apply the same filter ,click the ___________ in the sort and filter group .
Descending
Clear Rules
Reapply
Formatting of my own
To clear conditional formatting ,click the Conditional Formatting drop-down menu, select __________ from the sub-menu .
Format Painter
Reapply
Clear Rules
Conditional
To filter data press ____________ .
Ctrl+Shift+L
Ctrl+Shift+F
Ctrl+Shift+A
Ctrl+Shift+B
To quickly sort a list based on one column, on the Home tab , in the Editing group , click ___________ .
Filter
Sort and Filter
Sort
Review
Which option is selected in the Sort Dialog Box , if the selected range consists of columns headings ?
Has Headers
My data has headers
My sheet has headers
None of the above
