Bissoy.com
Doctors Medicines MCQs Q&A

What will be the output of the MS Excel 2007 date formula ‘=DATE(2020,8,31)’ if the selected date format is 'xx-xx-xxxx'?

What will be the output of the MS Excel 2007 date formula ‘=DATE(2020,8,31)’ if the selected date format is 'xx-xx-xxxx'? Correct Answer 31-08-2020

The correct answer is 31-08-2020.

Key Points

  • The selected date format is 'xx-xx-xxxx' which means 'dd-mm-yyyy'.
  • =DATE(2020.8.31) in this function day is 31, month is 8 and year is 2020.

Additional Information

  • The DATE() Function in Excel is categorized under Excel Date/Time Functions.
  • It is the main function used to calculate dates in Excel.
  • The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
  • TIME() function is a built-in function that allows you to create a time with individual hour, minute, and second components. 

Related Questions

Three companies L, M, and N participated in campus recruitment in college Z. All three companies selected an equal number of candidates. Out of the total candidates selected, 60 were selected by both L and M. The number of candidates selected by both M and N was 68 less than twice the number of candidates selected by both L and M. There were 28 candidates who got selected by each L, M and N companies. This number was 50% less than the number of candidates selected by both L and N. The total number of candidates selected by both L and N was 92% less than a total number of candidates selected. The total number of students that got placed in exactly one company was what percent more than the ones that got placed in exactly two companies?
In a survey of 100 students, 55 selected in IBPS Clerk, 36 selected in IBPS PO and 48 selected in SBI Clerk. 16 selected in IBPS Clerk and IBPS PO, 18 selected in IBPS PO and SBI Clerk and 15 selected in IBPS Clerk and SBI Clerk. Then, find the number students who are selected in all three exams (i.e IBPS Clerk, IBPS PO and SBI Clerk)?
A team of six members is to be selected from five men M1, M2, M3 M4, and M5, and five women W1, W2, W3, W4, and W5. W2 and W5 cannot be selected together. M1 and W3 have to be selected together. W3 and W4 cannot be selected with M2. W1 and M5 cannot be selected together. M3 and M4 cannot be selected together. Which of the following members may be selected?
A team of five members is to be selected from five boys B1, B2, B3, B4 and B5 and five girls G1, G2, G3, G4 and G5. B2 and G3 have to be selected together. G1 and B5 have to be selected together. B1 and G5 cannot be selected together. G2 and B4 cannot be selected together. G3 and B5 cannot be selected together. Which of the following members may be selected?
The different variant of Date() constructor to create date object is/are ___________ i. new Date(date) ii. new Date(milliseconds) iii. new Date(date string) iv. new Date(year, month, date)
A team is to be selected from 13 players P1, P2, P3, P4, P5, P6, P7, P8, P9, P10, P11, P12 and P13. There will be seven players in the team. P2 cannot be selected with P1, P6 or P4. P7 cannot be selected with P2, P10, P11 or P13. If P8 and P13 both are selected, then P5 must be selected. P4 cannot be selected with P2, P10, P12 or P11. Which of the following is a correct selection of the team?   
A group of four teachers is to be formed from amongst seven teachers T1, T2, T3, T4, T5, T6 and T7. Either T1 or T2 should be selected with T5. T4 and T7 cannot be selected together. Either T3 or T6 should be selected with T2. Either T7 or T5 should be selected with T6. Who among the following may be selected?
Some candidates were selected by a company after the hiring process. The ratio of selected to unselected was 4 ∶ 1. If 70 less had applied and 30 less selected, the ratio of selected to unselected would have been 6 ∶ 1. How many candidates were selected?
A, B, C, D and E play Hockey. 3 players from Hockey were selected to form Team 1. I. A is always selected. II. Exactly one among B and C is always selected III. D will not participate if B is selected. IV. E will not play with C Which among the given option is a possibility of team to be selected?
The “from” programs convert sequence files from GCG format into the named format, and the “to” programs convert the alternative format into GCG format.