Question

A function working with ranges can take name of the range as argument in place of the range's bounding sells.

Answer 1

Answer:

A function is a special kind of formula, so a function's arguments must follow the rules for entering formulas. The arguments for a function can be:

Numbers

Text strings

Logical values

Error values

Cell or range references

Array constants

A function may require its first argument to be a number, the second argument a text string, and the third argument a cell reference. Some arguments can be of more than one type; for example, the SUM function's argument can be a set of numbers, range references, or array constants. Refer to the documentation on the individual function to determine the type of data required for the function you are entering.

Numbers in Arguments

Usually you can enter a number in an argument by simply typing the number. Do not use commas to separate thousands, because the comma will be interpreted as separating two arguments.

Negative numbers are entered using the negative sign (-). Do not use parentheses: the function will interpret the value as a different argument.

Fractions can be entered by using a slash for the fraction separator (3/4 is evaluated as .75).

Percentages can be entered using the percent sign (34% is evaluated as .34).

Scientific notation can be used for very large or very small numbers (34E+09 is evaluated as 34,000,000,000).

Exponents can be entered using the caret sign (3^4 is evaluated as three to the fourth power, or 81).

Dates and times may be entered in two ways: as serial numbers, or in one of the conventional formats (e.g., mm/dd/yy) enclosed in quotation marks. Dates and times entered in this way are considered text, but Formula One for Java recognizes them as dates and internally converts them to their serial number values. For example, "10/10/94"-"10/1/94" is interpreted as 9.

Text Strings in Arguments

Text strings in an argument list must be enclosed in quotation marks. Without the quotation marks, the function will return the #NAME? error. When entering multiple text arguments, be sure the closing quotation mark comes before the comma that separates two arguments.

When the argument is a cell reference pointing to a cell containing a text string, the text in the cell does not have to be enclosed in quotes.