0
A function is a built-in formula in Excel designed to do a particular task. Arguments are values that you provide to a function to do its task, like cell address that hold numbers that you want to use for the function. For example, the numbers and addresses in the following SUM function are arguments:
=SUM( A2:A5, 7, 800, B18 )
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Which term describes a function used as an argument for another function?
In Excel a function within another function would be called a nested function.
When the function argument box appears in excel?
When you choose the Insert Function command and then pick a function to use, it will appear so that you can type arguments into it.
What does Excel do if you do not include an optional argument?
If you do not include an optional argument, Excel will use the default value for that argument.
Does the CONCATENATE function in Excel require a text argument?
Normally yes, but it will actually take numbers and combine them into a text string.
Which is the ROUND function argument specifies the number of decimal places to round to?
In Excel, the second argument of the Round function specifies the number of decimal places to round to. If this number is negative, it rounds to corresponding digits before the decimal point.
What arguments are optional and not required for the PMT function in MS Excel?
The FV and Type arguments are optional in the PMT function.
What is the difference between the PMT and PPMT functions in Excel?
The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
Can a function be an argument in another function in Excel Microsoft?
If the function allows multiple arguement, you can use another function within most functions. EXAMPLE: =IF(SUM(A1:A14)>120,SUM(A1:A14),"Oops! not enough")
Does the NUMBER function return the number of cells in the range indentified in the argument contain data?
No. In Excel you would use the COUNT function to do it, or possibly the COUNTA or COUNTIF, depending on exactly what you were trying to do.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
An argument takes a value or values and performs an operation?
In programming, an argument takes a value or vales and performs an operation is called a function or method. If a method does not return a value, it is described as 'void'.
