Answer:
The formula is =OFFSET( A1, 7,3,1,1 )
Step-by-step 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" )