contestada

According to the lecture video on building dynamic charts, which of the following Excel functions are used in the "Refers to:" formula in Name Manager?
A) SUMIF
B) COUNTIF
C) OFFSET
D) COUNT

Respuesta :

Answer:

OFFSET

COUNT

Explanation:

two options are correct, select both.

Answer:

Option C  and D are correct

Explanation:

OFFSET - From a cell or a range of cells, returns a reference to a range with a specified number of rows and columns.

COUNT - To determine the number of entries in a number field that is part of a range or array of values, use the COUNT function.

Otras preguntas