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. Cell Lock utility

B. Split Windows

C. Data Validation boundaries

D. Freeze Panes

Answer: Option D

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 Excel, which function is used to find the remainder after division?

A. REMAINDER

B. QUOTIENT

C. MOD

D. DIV

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MOD returns the remainder of a division. QUOTIENT returns the integer portion.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function counts the number of blank cells in a range?

A. COUNTBLANK()

B. ISBLANK()

C. COUNTIF()

D. COUNTA()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNTBLANK(range) returns count of empty cells.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which function in Excel returns the average of cells that meet a given condition?

A. AVERAGEIF()

B. SUMIF()

C. AVERAGE()

D. COUNTIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AVERAGEIF averages based on a criterion. AVERAGEIFS for multiple criteria.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs