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

In Excel, the 'Sort & Filter' group is on which tab?
A. Formulas
B. Home
C. Data
D. View
Answer: Option C
Solution (By JKSSB Mock Tests)
Data tab has Sort & Filter.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, what occurs if you select an animation entry item in the Animation Pane and click 'Trigger'?
A. It records custom audio narratives over that design asset.
B. It forces the slide to move instantly to the next chronological presentation layout.
C. It maps the animation to run automatically inside an infinite timing loop.
D. It associates the animation sequence to run only when a specific asset on the slide is clicked.

Correct Answer: Option D


Explanation:
An animation 'Trigger' sets a specific condition or click target on a slide, so the animation executes only when that specific object is selected by the user during a show.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the function =NETWORKDAYS(start, end) returns:
A. Number of calendar days
B. Total days between dates
C. Days including holidays
D. Number of working days (excluding weekends) between dates

Correct Answer: Option D


Explanation:
NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.

This question belongs to: Computer Microsoft Office
Question #3
In MS PowerPoint, what are the entry effects that control how an object arrives or animates onto a slide during a show?
A. Entrance Effects
B. Motion Paths
C. Exit Effects
D. Emphasis Effects

Correct Answer: Option A


Explanation:
Entrance effects dictate how an item steps onto the slide canvas area during presentation playback steps.

This question belongs to: Computer Microsoft Office