Question

Which function returns a valid value without any arguments?

Answer 1

Answer:

TODAY and NOW function returns valid value without any arguments.

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.

Answer 2

Answer:

Option TODAY and NOW

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.