In Excel, to freeze the top row so it remains visible while scrolling, go to: MCQ with Answer and Explanation

In Excel, to freeze the top row so it remains visible while scrolling, go to:
A. Review tab -> Protect Sheet
B. Insert tab -> Header & Footer
C. View tab -> Freeze Panes -> Freeze Top Row
D. Page Layout -> Print Titles
Answer: Option C
Solution (By JKSSB Mock Tests)
Freeze Panes under View tab can freeze rows/columns. Protect Sheet restricts editing.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Word, the 'Show/Hide' button (¶) is used to:
A. Display or hide non-printing characters like spaces, tabs, and paragraph marks
B. Show or hide the ruler
C. Hide the document text
D. Toggle between print layout and draft view

Correct Answer: Option A


Explanation:
The Show/Hide button (¶) toggles the display of formatting marks (paragraph marks, spaces, tabs, etc.). It does not change view or hide text.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, what occurs when you click the 'B' key on the keyboard during an active, full-screen slide show presentation?
A. Moves the presentation instantly to the previous slide layout
B. Whites out the screen display completely
C. Launches the drawing pen annotation tool
D. Blacks out the screen display completely

Correct Answer: Option D


Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing the 'W' key turns the screen completely white. Pressing either key again returns to the slide show.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, the 'Transpose' paste option:
A. Copies only values
B. Switches rows to columns and columns to rows
C. Pastes formatting only
D. Pastes as a link

Correct Answer: Option B


Explanation:
Transpose changes data orientation.

This question belongs to: Computer Microsoft Office