Which of the following functions is used to display only the current system date in MS Excel 2010?

Correct option is B

In MS Excel 2010, the TODAY() function is used to display the current system date. When you use this function, it returns the date based on the system's date settings without including the time.
· TODAY() only displays the current date and automatically updates whenever the worksheet is recalculated or opened.
Important Key Points:
1. TODAY(): It returns the current date, formatted based on your system's regional settings. It does not include the time.
2. Dynamic Update: The TODAY() function will update to show the current date whenever the file is opened or the worksheet is recalculated.
Knowledge Booster:
· NOW(): The NOW() function returns both the current date and time.
· DATE(): The DATE() function is used to create a date value from individual year, month, and day values, but it does not return the system's current date automatically.
· TIME(): The TIME() function returns a time value from hour, minute, and second values, not the current date.