Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
Which of the following formulae is the equivalent of EOMONTH(A1,0)?
=DATE(0,MONTH(A1)+1,YEAR(A1))
=DATE(YEAR(A1),MONTH(A1),31)
=DATE(YEAR(A1),MONTH(A1)+1,0)
Don’t know
2
Beginner
What is the earliest date Excel recognises?
1 January 2000
1 January 1900
1 January 1904
Don’t know
3
Beginner
Which of the following gives the end of the year, where cell A1 contains a date in the first month of the year?
=EOMONTH(A1,365)
=EOMONTH(A1,12)
=EOMONTH(A1,11)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement