In Excel, the function =COLUMN() in cell D5 returns: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function =COLUMN() in cell D5 returns:

A. D

B. 4

C. 5

D. Error

Answer: Option B

Solution (By JKSSB Mock Tests)

Column D is 4th column.

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

Share Report

In Excel, to delete a worksheet, right-click the sheet tab and select:

A. Clear

B. Cut

C. Remove

D. Delete

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Right-click -> Delete removes the sheet.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, what does the 'Flash Fill' feature do?

A. Fills a range with random numbers

B. Copies formatting from adjacent cells

C. Fills cells with a series like AutoFill

D. Automatically fills values by detecting patterns

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Word, which of the following is used to change the case of selected text?

A. Home > Change Case

B. Insert > Change Case

C. Review > Change Case

D. Format > Change Case

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Change Case is in the Home tab, Font group.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs