In MS Excel, which feature enables users to lock row or column headers in place so they stay visible on screen while scrolling through large datasets? MCQ with Answer and Explanation

Question

In MS Excel, which feature enables users to lock row or column headers in place so they stay visible on screen while scrolling through large datasets?

A. Data Validation boundaries

B. Freeze Panes

C. Cell Lock utility

D. Split Windows

Answer: Option B

Solution (By JKSSB Mock Tests)

The Freeze Panes tool locks selected rows or columns in place, keeping them visible on screen as you scroll through the rest of the worksheet.

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

Share Report

Which tab in MS PowerPoint contains the 'Animation Pane'?

A. Slide Show

B. Animations

C. Insert

D. Home

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Animation Pane is found on the Animations tab, in the Advanced Animation group.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut to open the 'Spelling & Grammar' dialog in MS PowerPoint?

A. F7

B. Alt + F7

C. Shift + F7

D. Ctrl + F7

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F7 works in PowerPoint for spelling check.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is the shortcut to save the current workbook in Excel?

A. Ctrl + Shift + S

B. F12

C. Alt + F4

D. Ctrl + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs