Which Excel feature allows you to view two separate parts of a worksheet at the same time? MCQ with Answer and Explanation

Question

Share Report Error

Which Excel feature allows you to view two separate parts of a worksheet at the same time?

A. Freeze Panes

B. Split

C. Arrange All

D. New Window

Answer: Option B

Solution (By JKSSB Mock Tests)

Split divides the window into resizable panes. Freeze Panes locks rows/columns, Arrange All arranges open workbooks.

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

In Excel, the formula =$A1 is an example of:

A. Absolute reference

B. Mixed reference (column absolute, row relative)

C. Circular reference

D. Relative reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
$A locks column A, row remains relative.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is a 'Form' primarily used for?

A. Data entry and viewing

B. Storing data

C. Printing data

D. Querying data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms are designed for user-friendly data entry, editing, and viewing. Tables store data, queries retrieve, reports print.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, which view is used to see all slides as thumbnails?

A. Outline View

B. Reading View

C. Slide Sorter View

D. Normal View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Sorter shows thumbnails.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs