Computer Science · MS Excel

Which of the following is the correct syntax to enter a date using the built-in function in MS Excel?

Verified Solution4 OptionsUpdated: October 2026👁️1 View

1=DATE(month, day, year)
2=DATE(year, day, month)
3=DATE(day, year, month)
4=DATE(year, month, day)✓

Correct answer

=DATE(year, month, day)

Download Single Question PDF

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Share with Friends & Study Groups

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Preparing for Computer Science?

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Start Free Mock Test →

Chapter Practice

Want more practice questions on MS Excel?

Solve complete topic-wise tests with detailed solutions on GkGet.

Practice MS Excel MCQs →

Recommended practice questions in Computer Science · MS Excel

Browse More Computer Science →

Which Indian independence movement leader was primarily known for his philosophy and practice of non-violent civil disobedience?

Solve Question→

Who gave the call for 'Do or Die' during the Quit India Movement in 1942?

Solve Question→

Which of the following revolutionary pairs were imprisoned together in Cellular Jail and faced harsh conditions, contributing significantly to the Indian independence movement?

Which of the following is the correct syntax to enter a date using the built-in function in MS Excel?

Download Single Question PDF

Share with Friends & Study Groups

Preparing for Computer Science?

Practice by Subject

Practice by Exam

Topic-Wise Solved Questions

Which of the following is the correct syntax to enter a date using the built-in function in MS Excel?

Download Single Question PDF

Share with Friends & Study Groups

Preparing for Computer Science?

Related Practice Questions

Practice by Subject

Practice by Exam

Topic-Wise Solved Questions