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

Question Report Error

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

A. The week number of a date in the year

B. The number of weeks in a year

C. The day of the week

D. The weekday name

Answer: Option A

Solution (By JKExamLibrary)

WEEKNUM returns the week number (1-53) for a given date. WEEKDAY returns the day of the week as a number.

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 Access, to add a new table using SQL, you use:

A. INSERT INTO

B. SELECT INTO

C. ALTER TABLE

D. CREATE TABLE

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
CREATE TABLE defines a new table.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which shortcut key is used to center align text in MS Office?

A. Ctrl + J

B. Ctrl + L

C. Ctrl + E

D. Ctrl + R

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl + E centers text. Ctrl + L left aligns, Ctrl + R right aligns, Ctrl + J justifies.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, the 'IF' function falls under which category?

A. Text

B. Information

C. Statistical

D. Logical

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
IF is a logical function.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs