Excel Date & Time Function Quiz
Question 1
In Excel's 'Temporal Serial Architecture', what does the integer portion of a cell value represent?
Question 2
Which function identifying 'Operational Milestones' should be used to calculate a date 10 business days in the future, skipping weekends?
Question 3
When using YEARFRAC to calculate 'Accrued Interest', which basis code identifies the high-precision Actual/Actual convention?
Question 4
What is the technical output of the 'Day-0 Month-End Hack' in the formula =DATE(2024, 3, 0)?
Question 5
Which 'Volatility Intercept' provides the current system date and precise sub-diurnal time decimal?
Question 6
To shift a milestone exactly 3 months forward while maintaining the specific day-order, which function is the 'Temporal Pilot'?
Question 7
For strict global compliance (ISO 8601), which return_type must be used in the WEEKNUM function?
Question 8
What is the result of the logical intercept =WEEKDAY(Date, 2) > 5 in a business reporting context?
Question 9
Which function identifies the 'Temporal Interval' in years, months, or days while remaining 'Hidden' from standard tooltips?
Question 10
How is exactly 6 hours (0.25 days) added to an Excel time serial in cell A1 via raw arithmetic?
Question 11
What does the EOMONTH(Start, -1) formula identify in a fiscal reconciliation audit?
Question 12
Which tool identifies the 'Cultural Operating Coordinate' by allowing a binary string (e.g. '0000011') for weekends?
Question 13
In the '2029 Century Trap', how does Excel interpret the 2-digit year string '1/1/30'?
Question 14
Which function is the 'Component Synthesizer'—building a valid serial from separate Year, Month, and Day integers?
Question 15