Oofset

Question 1

Creating dynamic name reanges

Answer 1

Dynamic names ranges incorporate dynamic reference formulas to create a name reference to a set of cells based upon a set of inputs.

Question 2

What I’d lines funcftion

Answer 2

The linest function calculate the statistics for a line by using the least squares method to calculate the straight line that fits your data, and then returns an array that describe the line.

Offset fiction returns a reference to a range constructed with five inputs
1, a starting point 2,a row offset,3 column offset, 4 height offset, 5 a width in a columns.

Question 3

What I’d dynamic ranges

Answer 3

Dynamic ranges are also know as expanding ranges they automatically expand and contract to accommodate New or delete data.
Offset us volatile function which means it recalculate with every change to a worksheet.

Question 4

Radar and surface chart

Answer 4

They used 3 demension