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

Question
In Excel, which function returns the weekday number of a given date?
A. DAY()
B. WEEKNUM()
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 purpose of the 'Slide Show' tab?
A. To design slides
B. To add animations
C. To set up and run the presentation
D. To insert media
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Slide Show tab contains options to start the slideshow, set up the show, rehearse timings, etc. Animations are on the Animations tab, Insert is for media, Design is for design.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which feature enables you to quickly save frequently used text or layout blocks so you can insert them with just a few keystrores?
A. Mail Merge fields
B. AutoCorrect table options
C. Smart Lookup database
D. Quick Parts (AutoText)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Quick Parts (including AutoText blocks) allow you to store text snippets, disclaimers, or layout blocks to reuse them across multiple documents.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to calculate the slope of a linear regression line?
A. All of the above
B. SLOPE
C. INTERCEPT
D. LINEST
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SLOPE, INTERCEPT, and LINEST can all be used for linear regression analysis (LINEST returns array).
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: