In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:

A. Third row, second column

B. Second row, third column of the range A1:C3

C. Cell B2

D. An error

Answer: Option B

Solution (By JKSSB Mock Tests)

INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell 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

In Excel, which function returns the smallest number in a range that meets a condition?

A. MINIF()

B. SMALLIF()

C. DMIN()

D. MINIFS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MINIFS returns minimum based on criteria.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, to view two parts of a document simultaneously, use:

A. Both A and B

B. Review -> Compare

C. View -> Split

D. Window -> New Window

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office

Question #3

To select a whole word in MS Word with a single mouse action:

A. Double-click the word

B. Ctrl + Click

C. Single-click the word

D. Triple-click the word

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Double-click selects a word; triple-click selects a paragraph.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs