Address of last cell in range as following formula?
Correct Answer: =ADDRESS(ROW(rng)+ROWS(rng)-1,COLUMN(rng)+COLUMNS(rng)-1)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
If the Formula cannot return a legitimate result or an inappropriate argument in a function, you will get the following error?
Which of the the following formulas will get the Last Name from name?
Information Rights Management (IRM) allows individuals and administrators to specify access permissions to documents, workbooks, and presentations. This helps prevent sensitive information from being printed, forwarded, or copied by unauthorized people. IRM cannot help with the following though:
To prevent yourself or others from accidentally deleting formulas or other critical data you can use:
A Shared Workbook will allow users to do all of the following except:
If A1=4.33, B1=6.111, and C1=26.5, then entering =A1:C1, when will return the answer ____ .
You've selected a range of sales data that has categories across the top row of the columns. How can you get filter buttons on this row, and alternate-row striping for the data?
If A1 is '=4*2' and B1 is '=6/2', what result would appear if C1 was '=A1(#)B1
Imagine a leaderboard of 1000 players. Column A shows player rankings, B their names and C their points. You want to sum the points of the top X players, where X is defined in D1. What is the correct formula?