In Excel, what does the 'COLUMN' function return? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the 'COLUMN' function return?

A. The number of columns in a range

B. The column header

C. The letter of the column

D. The column number of a reference

Answer: Option D

Solution (By JKSSB Mock Tests)

COLUMN returns the column number (e.g., 1 for column A). It does not return letters or counts of columns.

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 PowerPoint, which of the following is used to insert a SmartArt graphic?

A. Insert > Graphic

B. Both A and B

C. Insert > SmartArt

D. Insert > Illustrations > SmartArt

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SmartArt is under Insert > SmartArt or Insert > Illustrations > SmartArt.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'RunSQL' macro action is used to:

A. Close a form

B. Open a report

C. Execute an SQL statement

D. Run a query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
RunSQL executes action queries.

This question belongs to: Computer Microsoft Office

Question #3

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

A. C2

B. A2

C. C1

D. B2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs