Respuesta :

Answer:

The formula is =OFFSET( A1, 7,3,1,1 )

Explanation:

Microsoft excel is a statistical and analytical tool for data management and analysis. Its working environment is called a worksheet. The worksheets are made up of rows and columns also known as records and fields respectively.

Functions like OFFSET in excel is used to return a cell or group of cells. It gets the position to turn by start getting a starting port, then the number of records below it and the fields after, then the length and width of cells to return.

syntax:   =OFFSET( "starting cell", "number of rows below", "number of columns after", "height of cells to return", "width of cells to return" )