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 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 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 PowerPoint, which key toggles between Normal and Outline view?

A. There is no single shortcut; use View tab

B. Ctrl + Shift + Tab (in some versions)

C. F6

D. Ctrl + F6

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
No direct toggle; you switch in the View tab. I'll rephrase: In PowerPoint, which view displays only text in an outline format? Answer: Outline view (accessible from View tab). So I'll ask: In PowerPoint, to see only the text content of slides in a structured list, use Outline view. That's fine.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which formula will return the number of characters in cell A1?

A. =LEN(A1)

B. =COUNT(A1)

C. =CHAR(A1)

D. =LENGTH(A1)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
LEN returns character count.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following database tools in MS Access is designed to summarize, group, and format table information for clear paper printing or digital distribution?

A. Query setup

B. Macro asset

C. Report

D. Form

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reports are specialized database objects used to organize, summarize, and format data from tables or queries for printing or professional distribution.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs