In Excel, the 'Sort & Filter' group is on which tab? MCQ with Answer and Explanation

Question
In Excel, the 'Sort & Filter' group is on which tab?
A. Data
B. Formulas
C. View
D. Home
Answer: Option A
Solution (By JKSSB Mock Tests)
Data tab has Sort & Filter.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Access, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?
A. Input Mask application
B. Indexed set to 'Yes (No Duplicates)'
C. Required set to 'No'
D. Validation Rule mapping
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, what is the function of 'Track Changes'?
A. Compares two documents
B. Records all edits made to a document for review
C. Automatically saves versions
D. Protects the document with a password
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Track Changes highlights insertions, deletions, and formatting changes.
This question belongs to: Computer Microsoft Office
Question #3
What is the function of the 'Ctrl + Shift + End' key combination in Excel?
A. Selects all cells from the current position to the last used cell in the worksheet
B. Deletes all data to the right
C. Moves the active cell to the last cell
D. Saves and closes the workbook
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+End extends the selection to the bottom-right used cell.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Computer Abbreviations 369 Operating Systems 510 Computer Networking 325 Microsoft Office 1199
Explore Subjects
Computer 5279 Science 4430 Geography GK 6121 Current Affairs 575 Static General Knowledge 6362
Practice Mix
The street ______ I live on is quiet.
What is the capacity unit for modern RAM modules?
Which of the following is a Rabi millet?
An object moving with uniform circular motion has
Identify the error: 'You are senior than me.'