0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is the difference between a function and expression?
Functions and Expressions are representations of relationships that exist among entities, however a function always returns a value (or result)
What is f(g(4))?
That means that function "g" is first applied to the number 4. Then, the result of that is used with function "f".
A function takes in values of variable called inputs and gives back values of the variable called outputs?
No. A function takes in values of no, one, or more input variables, and returns no or one result. It cannot return more than one result. Do not confuse this with returning multiple results using call by reference parameters - this is not the same thing.
What is the limitation to the domain of a function?
Any number that produces an undefined result from a function f(x) is not in its domain.For example, the number 0 is not in the domain of f(x) = 1/x, because 1/0 is undefined.Undefined answers will result from any of the following situations:- Dividing by 0- Taking the square root of a negative number- Taking the log (any base) of 0 or any negative number- Taking the log (base 1) of any number
Can a function have an infinite number of values and domain and only a finite number of values in its range?
Sure. Remember that a function is ANY rule defined to calculate one number based on another number. You can define such a rule any way you want. For example, you can have a function which for ANY value in its domain, the result will always be 1 (or any other number you choose). Such a function (the constant function) will fulfill the requirements of the question. A more interesting (and more useful) example is the "sign" ("signum") function, defined with the following rule: * For x < 0, f(x) = -1 * For x > 1, f(x) = 1 * For x = 0, f(x) = 0 This function has only three values in its range.
What function returns a result based on a condition?
IF
Which logical function returns a true result only when all its arguments are true?
The AND function.
Difference between subroutine and function?
Both A function and a Sub carry out a procedure, but only A function returns a result while a Sub does not return a result.
What takes a value or values performs an operation and returns a result to the cell?
called function
What is the vlookup function?
looks up a value and returns a related result from the lookup table.
What is the difference between a function and expression?
Functions and Expressions are representations of relationships that exist among entities, however a function always returns a value (or result)
Where does the Subtotal command insert a row?
The SUBTOTAL function does not insert a row. It returns the result in the cell where you type the formula. See related links for information about the SUBTOTAL function.
What is the round function in excel used for?
ROUND is a function that returns a number rounded to a specified number of digits.Syntax: =ROUND( number, digits )number is the number to rounddigits is the number of digits to round the number toEXAMPLES:=ROUND(1/3,2) will return 0.33=ROUND(1/6,2) will return 0.17
What is a max formula?
The MAX function returns the largest number from the cells you evaluate.EXAMPLE:A1 = 104A2 = 623A3 = 23A4 = 234A5 = 198FORMULA: =MAX(A1,A2,A3, A4, A5) will display a result of 623, because A2 contains the largest number.
What is the Function that adds the values of cells in a range and divides the result by the number of cells?
The AVERAGE function.
What is return in programming?
The return statement is used in functions to return control to the caller. If the function is declared non-void, the return statement also allows the programmer to return a value to the caller.
What does the coalesce function do on an SQL server?
The coalesce function returns the first expression that contains the highest in data precedence. If all other expressions are considered 'nonnullable, then the result will be labelled nonnullable as well.
