Question

Which function returns a valid value without any arguments?

TODAY
SQRT
COUNT
ROUND
NOW

Answer 1

Option TODAY and NOW

Step-by-step explanation:

The options of the function given in the question are referring to Microsoft Excel functions.

Argument is an input value required by a particular function to operate on it and return an output. The argument will be placed within the a pair of the parenthesis attached to the function name. For example, =Count(value1, value2, ... )

However, not all functions require argument to return an output. For example, writing =TODAY() and =NOW() will directly return a date of today and current time, respectively.

Answer 2

TODAY and NOW function returns valid value without any arguments.

Step-by-step explanation:

All the listed functions are used in MS Excel, their functionality is defined below:

• TODAY() function is a built-in function that gives the date of current function. It can also be used as a worksheet (WS) function. Every time we use a TODAY() function, the system will refresh the date before recalculated by worksheet.
• SQRT() function works by returning the square root of a value given in the parenthesis as argument.
• COUNT() function gives the number of entries present in a specific range given as argument to it.
• ROUND() function will round the number given to it to the nearest decimal.
• NOW() function is also a date/time function, which specifies the current system date and time.