In Excel, what is the purpose of the 'Freeze Panes' feature? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what is the purpose of the 'Freeze Panes' feature?

A. Locks cell formatting

B. Keeps selected rows or columns visible while scrolling

C. Prevents any changes to the worksheet

D. Splits the window into multiple panes that can scroll independently

Answer: Option B

Solution (By JKSSB Mock Tests)

Freeze Panes locks rows/columns. Split creates independent scrollable panes but doesn't lock.

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

Which of the following functions in MS Excel checks whether a cell value is text and returns TRUE or FALSE?

A. ISTEXT

B. ISNUMBER

C. ISBLANK

D. CHECKTEXT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ISTEXT is a built-in logical informational function that returns TRUE if the evaluated field holds alphanumeric text string structures.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key to insert a comment in MS Word?

A. Alt + M

B. Ctrl + Shift + M

C. Ctrl + Alt + M

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Alt + M inserts a comment. Ctrl + M indents a paragraph in Word. The others are not standard for comments.

This question belongs to: Computer Microsoft Office

Question #3

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

A. AVERAGE()

B. SUMIF()

C. AVERAGEIF()

D. COUNTIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs