Chapter 8 – Date Formulas in Excel December 27, 2024 by Satish Dhawale Welcome to your Chapter 8 - Date Formulas in Excel Name Email Phone 1. How can you format the date in Excel to display in the correct format (DD/MM/YYYY)? Using the "Short Date" option Using custom format (DD/MM/YYYY) By typing the date manually By using the DATE function None 2. What should you do if the date format is not reflecting correctly despite applying the correct format? Double-click and press Enter Change the column width Re-enter the date Use a different cell None 3. What formula can be used to extract the year from a date in Excel? =YEAR() =MONTH() =DATE() =TEXT() None 4. Which of the following formulas extracts the day from a date? =DAY() =YEAR() =MONTH() =DATE() None 5. What is the purpose of the TODAY() function in Excel? To display the current date To calculate the difference between two dates To convert text into a date format To extract the year None 6. How can you calculate the difference between two dates in terms of days? Use =DATEDIF() function Use =YEARFRAC() function Subtract one date from another Use the TEXT() function None 7. Which function can you use to calculate the age of an employee in Excel? =DATEDIF() =YEAR() =TODAY() =TEXT() None 8. What formula would you use to combine the year, month, and day into a single date in Excel? =DATE(year, month, day) =TEXT() =YEAR() & MONTH() & DAY() =TODAY() None 9. If you want to calculate the difference between two dates in months, which function should you use? =DATEDIF() =DAY() =MONTH() =YEAR() None 10. 10. What is a common issue when working with dates in Excel that may prevent the formula from working correctly? Date is in text format Formula is entered incorrectly Formula is using the wrong date format Date cells are locked None Time's upTime is Up! Post Views: 2,413
