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

In PowerPoint, which option allows you to apply a custom color to all slide backgrounds at once?

A. Home -> Fill Color

B. Both A and B

C. Design -> Format Background -> Apply to All

D. View -> Slide Master -> Background Styles

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both methods can set background for all slides: Slide Master or Format Background with Apply to All.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which shortcut is used to increase the font size in MS Excel?

A. Ctrl + >

B. Ctrl + Shift + > (or Ctrl + ])

C. Alt + >

D. Ctrl + Shift + .

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Same as Word, Ctrl+Shift+> or Ctrl+].

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which data type stores a value that is either -1 (Yes) or 0 (No)?

A. Yes/No

B. Boolean

C. Logical

D. Both A and B, but it's called Yes/No

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The data type is Yes/No.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs