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

Question Report Error

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

A. The column header

B. The column number of a reference

C. The number of columns in a range

D. The letter of the column

Answer: Option B

Solution (By JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS PowerPoint, which feature can draw a user's attention to a specific spot on a slide during a live presentation by turning the cursor into a glowing pointer?

A. Magnifier Tool

B. Laser Pointer

C. Highlight Tool

D. Ink Pen Annotator

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Holding Ctrl and left-clicking during a slide show activates the built-in Laser Pointer feature to guide audience focus.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Word, 'Kerning' refers to:

A. Adjusting the spacing between specific pairs of characters

B. Fitting text to a shape

C. Applying shadow effects to text

D. Changing the line spacing

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Kerning adjusts space between individual letters.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which of the following is the correct way to exit MS Word?

A. File -> Close

B. Ctrl + Q

C. Alt + F4

D. Ctrl + F4

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Alt+F4 exits the application. Ctrl+F4 closes document.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs