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. B2

B. A2

C. C1

D. C2

Answer: Option D

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

To quickly find the sum of selected cells in Excel, look at:

A. Title bar

B. Name box

C. Formula bar

D. Status bar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When you select numeric cells, the status bar displays Sum, Average, Count.

This question belongs to: Computer Microsoft Office

Question #2

In MS PowerPoint, what is the shortcut key combination used to insert a brand new hyperlink on a selected object or text string?

A. Ctrl + M

B. Ctrl + K

C. Ctrl + H

D. Ctrl + L

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + K opens the Insert Hyperlink dialog box across MS Word, Excel, and PowerPoint.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the formula =SUM(Sheet2:Sheet5!B3) will:

A. Sum all cells named Sheet2 and Sheet5

B. Sum range B3 on the active sheet

C. Cause an error because of incorrect syntax

D. Sum cell B3 from Sheet2 through Sheet5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
This 3-D reference sums the same cell across multiple worksheets.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs