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 letter of the column

B. The column number of a reference

C. The column header

D. The number of columns in a range

Answer: Option B

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 Access, to create a form that displays data from a query, use:

A. Report Wizard

B. Table Analyzer

C. Macro Builder

D. Form Wizard or Form Design based on the query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Forms can be bound to tables or queries.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the 'Selection Pane' shows:

A. Transition settings

B. Slide thumbnails

C. Animation timeline

D. A list of all objects on the slide, allowing you to hide, rename, reorder them

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Selection Pane (Home -> Select -> Selection Pane) manages objects.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what is the maximum size of an OLE Object field?

A. 1 GB

B. Limited by database size

C. 256 MB

D. 2 GB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
OLE Object fields can store up to 1 GB of data.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs