We designed Top 100 MS-Excel Function MCQ to help every professional and student. Practice these Top 100 MS-Excel Function MCQ to test and enhance your knowledge in Microsoft Excel.
Top 100 MS-Excel Function MCQ
Q1. Which of the following function is used to create a date with year, month and a day?
a) YEAR
b) DATE
c) EOMONTH
d) TIME
Answer – [B]
Q2. Which of the following function is used to create a time with individual hour, minute, and a second components?
a) YEAR
b) DATE
c) EOMONTH
d) TIME
Answer – [D]
Q3. Which function is used to return the year for specified date in MS-Excel?
a) YEAR
b) DATE
c) EOMONTH
d) TIME
Answer – [A]
Q4. Which function is used to returns the second component of a time as a number between 0 to 59?
a) MINUTE
b) HOUR
c) SECOND
d) TIME
Answer – [C]
Q5. Which function is used to generates the hour from a time value as a number from 0 to 23?
a) MINUTE
b) HOUR
c) SECOND
d) TIME
Answer – [B]
Q6. Which function extracts the minute component of a time as a number between 0 to 59?
a) MINUTE
b) HOUR
c) SECOND
d) TIME
Answer – [A]
Q7. Which function is used to get the current date?
a) DATE
b) TODAY
c) NOW
d) TIME
Answer – [B]
Q8. Which function is used to return current date and time in Excel?
a) DATE
b) TODAY
c) NOW
d) TIME
Answer – [C]
Q9. Which function is used to extracts the month from a given date as a number between 1 to 12?
a) DAY
b) MONTH
c) YEAR
d) EOMONTH
Answer – [B]
Q10. Which function is used to return the day of the month for a specified date in Excel?
a) DAY
b) MONTH
c) YEAR
d) EOMONTH
Answer – [A]