The "Rows" argument in the OFFSET function determines:AMovement above the reference pointBMovement below the reference pointCNumber of rows in the rangeDNumber of columns to move

The OFFSET function in Excel returns the value of a cell or:AA range of adjacent cellsBA specific cellCA random cellDA cell based on column number

What is the method to be used to move the pointer in the table?a.next()b.nextRow()c.Noned.nextColumn()

Question 7 (1 point)An offset is used when constraining two parts and you don’t want to constrain them completely flush (you might offset one part so that it sticks out from another part). True False

If the "Width" argument is omitted in the OFFSET function, what is assumed for its value?AThe width of the starting pointBThe height of the starting pointCZero widthDOne width

Fetch the value from the 7th column and 4th row by keeping A2 as the reference into the cell B1 in sheet named OFFSETERRORValue in cell OFFSET!B1 is incorrect