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 Report Error

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 JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In Excel, which function returns the serial number of a specific date given year, month, day?

A. DATEVALUE()

B. NOW()

C. DATE()

D. TODAY()

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
DATE(year, month, day) constructs a date.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which of the following is a 'view' available for slides in PowerPoint?

A. Normal

B. All of these

C. Slide Sorter

D. Outline

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
All are views.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Excel, what is the default keyboard shortcut used to insert a brand-new, empty chart sheet based on the currently highlighted data cells?

A. F11

B. Alt + F1

C. F2

D. F4

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Pressing F11 creates a new, dedicated Chart Sheet containing a chart generated from the selected cell range. Alt + F1 inserts the chart on the current worksheet.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs