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

Question
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 weekday name
D. The day of the week
Answer: Option A
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 Word, which of the following is used to create a list of headings and their page numbers?
A. Index
B. Table of Figures
C. Table of Contents
D. Bibliography
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Table of Contents generates a list of headings with their corresponding page numbers based on heading styles. Index lists keywords, Table of Figures lists captions, Bibliography lists sources.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which error value indicates that a formula contains invalid numeric values?
A. #REF!
B. #NAME?
C. #DIV/0!
D. #VALUE!
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
#VALUE! appears when wrong data type is used. #REF! invalid reference, #DIV/0! division by zero, #NAME? unrecognized text.
This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to open the 'Page Setup' dialog in MS Excel?
A. Alt + P, S, P
B. F5
C. Ctrl + Shift + P
D. Ctrl + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+P,S,P opens Page Setup in Excel. Ctrl+Shift+P is not standard. Ctrl+P is Print. F5 is Go To.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Networking 325 Microsoft Office 1199 CPU (Central Processing Unit) 327 Cyber Security 269 Memory and Storage Devices 438
Explore Subjects
Geography GK 6121 Current Affairs 575 History GK 3374 Accountancy and Statistics 3179 Maths 5575
Practice Mix
Select the most appropriate meaning of the idiom: 'Make a mountain out of a molehill'.
What does the 'GUI' acronym stand for in computer interface terminology?
A trader marks his goods 80% above cost price and gives a discount of 40%. Find his gain percent.
Which type of memory is used to store the firmware that boots the computer?
The average of 8 numbers is 30. If one number is 40, find the average of the remaining 7.