In Excel, which function returns the weekday number of a given date? MCQ with Answer and Explanation

Question

Share Report Error

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

A. WEEKNUM()

B. DAY()

C. WEEKDAY()

D. DATEVALUE()

Answer: Option C

Solution (By JKSSB Mock Tests)

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

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 PowerPoint, what is the action or function of the shortcut 'Ctrl + M'?

A. Saves the file

B. Opens a new window

C. Minimizes the interface

D. Inserts a new blank slide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In MS PowerPoint, Ctrl + M inserts a new slide into the active presentation, while Ctrl + N opens a brand-new blank file.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a 'Make-Table' query is an example of:

A. Parameter query

B. Select query

C. Action query

D. Crosstab query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Action queries modify data or structure.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to open the 'Symbol' dialog in MS Word?

A. Alt + Ctrl + S

B. Alt + N, U, S

C. Insert > Symbol

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can insert symbol via Insert > Symbol, and the keyboard shortcut Alt+N,U,S (or Alt+I,S in older versions) opens the Symbol dialog. So both are valid.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs