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. 4

B. D

C. Error

D. 5

Answer: Option A

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

Which of the following is not a valid view in MS Excel?

A. Reading View

B. Page Break Preview

C. Normal

D. Page Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Excel has Normal, Page Layout, and Page Break Preview views. Reading View is not a view in Excel; it's a Word view.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function returns the weekday number of a given date?

A. WEEKNUM()

B. WEEKDAY()

C. DAY()

D. DATEVALUE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
WEEKDAY(date) returns a number 1 (Sunday) through 7. WEEKNUM returns week of year.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

To move to the next pane in a split worksheet in Excel, press:

A. Tab

B. Ctrl + Tab

C. Alt + F6

D. F6

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F6 moves between panes in a split worksheet.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs