Question

select all the correct answers. which function returns a valid value without any arguments? today sqrt count round now

Explanation:

• TODAY: In spreadsheet software (e.g., Excel), the TODAY() function returns the current date without needing any input arguments. It automatically updates to the current date when the spreadsheet recalculates (e.g., when you open the file or trigger a recalculation).
• NOW: Similarly, the NOW() function in spreadsheet software returns the current date and time. It also operates without requiring additional arguments, updating to reflect the real - time date and time as per the spreadsheet's recalculation rules.
• SQRT: The SQRT() function is used to calculate the square root of a number. For example, SQRT(9) returns 3. It requires a numerical argument (the number for which you want to find the square root), so it cannot return a valid value without an argument.
• COUNT: The COUNT() function is used to count the number of cells in a range that contain numbers. For example, COUNT(A1:A10) counts the number of numeric values in cells A1 to A10. It needs a range (or at least one cell reference) as an argument to know what to count, so it can't work without an argument.
• ROUND: The ROUND() function is used to round a number to a specified number of digits. For example, ROUND(3.14159, 2) rounds 3.14159 to 3.14. It requires two arguments: the number to be rounded and the number of digits to round to, so it can't return a valid value without arguments.

Answer:

• TODAY
• NOW