Suppose that you have a worksheet that you update frequently by adding new data to columns. You may need a way to reference the last value in column A (the value most recently entered at bottom of column A). If column A contains no empty cells which of the formula returns the last value entered in column A (bottom one)?
Correct Answer: =OFFSET(A1,COUNTA(A:A)-1,0)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Excel MCQ Questions