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 MS Word, which view shows the document as it will appear when printed?

A. Draft

B. Read Mode

C. Web Layout

D. Print Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Print Layout view displays the document with margins, page breaks, headers, footers, etc., as it will appear when printed. Read Mode is optimized for reading, Web Layout for web pages, Draft shows minimal formatting.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, a cell address $A1 is an example of:

A. Mixed reference

B. Relative reference

C. Absolute reference

D. Circular reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
$A1 has column absolute, row relative, so it's mixed.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is the shortcut to save the current workbook in Excel?

A. Ctrl + S

B. F12

C. Ctrl + Shift + S

D. Alt + F4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs