Today () is the correct function to display the current date only in MS Excel.

To understand why option 'B' is the correct answer, let's take a closer look at each of the options:

a) Date (): The Date function in Excel is used to create a date based on year, month, and day values. It does not display the current date but instead allows you to input specific date values.

b) Today (): The Today function in Excel is used to display the current date. It does not require any arguments or inputs. When you use the Today function, Excel automatically updates the date whenever you open the workbook or whenever the worksheet recalculates.

c) Now (): The Now function in Excel is used to display the current date and time. It does not display the current date only. If you only want to display the current date, the Now function is not the correct option.

d) Time (): The Time function in Excel is used to create a time based on hour, minute, and second values. It does not display the current date but instead allows you to input specific time values.

Therefore, the correct option for displaying the current date only in MS Excel is the Today () function.

To use the Today () function:
1. Select the cell where you want to display the current date.
2. Type "=Today()" (without the quotation marks) in the cell.
3. Press Enter.

The selected cell will now display the current date. Remember that this date will automatically update whenever you open the workbook or whenever the worksheet recalculates.

Using the Today () function is useful in various scenarios, such as tracking project deadlines, keeping a record of daily activities, or creating dynamic schedules that update with the current date automatically.

By selecting the Today () function, you can ensure that your Excel spreadsheet always displays the current date without any manual input or adjustments.