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

Question
In Excel, what does the 'WEEKNUM' function return?
A. The weekday name
B. The number of weeks in a year
C. The day of the week
D. The week number of a date in the year
Answer: Option D
Solution (By JKSSB Mock Tests)
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
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 Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?
A. Short Text
B. Hyperlink
C. Long Text
D. OLE Object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, whereas 'Short Text' is capped at 255 characters.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, what is a 'Form' primarily used for?
A. Storing data
B. Querying data
C. Data entry and viewing
D. Printing data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms are designed for user-friendly data entry, editing, and viewing. Tables store data, queries retrieve, reports print.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, to add a calculated field in a query, you:
A. Type an expression in a blank column of the query design grid
B. Both A and B
C. Use the Expression Builder in the Field row
D. Use the Append query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can type directly or use Expression Builder.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?