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

Question Report Error

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

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

B. Cell B2

C. An error

D. Third row, second column

Answer: Option A

Solution (By JKExamLibrary)

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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

What is the maximum number of columns in a table in MS Word?

A. 256

B. 63

C. No limit

D. 10

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
A Word table can have up to 63 columns.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which of the following field properties in MS Access determines the maximum number of characters that can be stored in a 'Short Text' data type field?

A. Input Mask

B. Format

C. Field Size

D. Validation Rule

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The Field Size property specifies the upper limit of character storage for a Short Text field, which defaults to 255 characters but can be set to any value between 1 and 255.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What is the shortcut key to select all content in MS Office?

A. Alt + A

B. Ctrl + Shift + A

C. Ctrl + A

D. Ctrl + E

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs