Concept:The Excel function that returns the current seconds from a time is
SECOND, not
MINUTES.
Explanation:NOW() returns the current date and time in Excel.
To extract the seconds portion, use
=SECOND(NOW()).
This formula gives the current seconds past the minute.
The option
=MINUTE(NOW()) would return minutes, not seconds.
None of the given options uses the
SECOND function.
Therefore, none of the listed formulas correctly displays the current seconds.
Answer:No listed option is correct.
The correct formula is
=SECOND(NOW()).