Question

Which function when entered into cellB7 calculated the range for average call length

Answer 1

Answer:

The average funcation returns the average of cells in a range that meet criteria you provide.

Explanation:

Hope it's help you.

Answer 2

Answer:

The correct answer is Average function.

Explanation :

• The AVERAGE Function is a part of the statistical functions in Excel ("). It will provide Excel with the mean value of the given group of numbers.

• The function in Excel is used to figure out the arithmetic mean of a group of inputs. Each step of computing the average in Excel will be demonstrated in this tutorial.

• To calculate the average (mean) of a group of statistics, a financial analyst can use this function. We can find out, for instance, what a company's annual average sales was.

Formula

=AVERAGE(number 1, [number 2],..) 

Furthermore, the following arguments are used by the function:

• The initial number of a cell reference or range for which the average is desired is Number1 (mandatory argument).

• Number2 is the second set of numbers, cell references, or a range for which the average is desired (optional argument). Additionally there is a limit of 255 numbers.

Some observations regarding the AVERAGE Function :

• The AVERAGE function disregards blank cells.

• Text, logical values, or empty cells are not taken into consideration when referencing a range or cell. However, cells with a value of 0 are also present.

• Errors in the function are caused by arguments that are error values or by text that cannot be converted to numbers.

#SPJ2