In Excel, the function =OFFSET(A1,1,2) returns the value of cell: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function =OFFSET(A1,1,2) returns the value of cell:

A. A2

B. C2

C. B2

D. C1

Answer: Option B

Solution (By JKSSB Mock Tests)

OFFSET(A1,1 row down, 2 columns right) gives C2.

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

What is the shortcut to align selected text to the right margin in MS Word?

A. Ctrl + L

B. Ctrl + E

C. Ctrl + J

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + R aligns right. Ctrl + L left, Ctrl + E centre, Ctrl + J justify.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following file extensions is NOT associated with MS PowerPoint?

A. .wav

B. .ppsx

C. .pptx

D. .potx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.wav is an audio file, not a PowerPoint file.

This question belongs to: Computer Microsoft Office

Question #3

Which section of the MS Word status bar shows real-time page metrics, word counts, and proofing status?

A. The Title Bar

B. The Status Bar

C. The Ribbon

D. The Quick Access Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Status Bar located at the very bottom of the window displays document metrics such as total page count, active page, word count, language, and zoom sliders.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs