Question

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

Answer 1

OFFSET

COUNT

Step-by-step explanation:

two options are correct, select both.

Answer 2

Option C and D are correct

Step-by-step 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.