DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
This command displays as the last row in an Excel table and provides summary statistics
|
total
|
|
sorted
|
|
changeable
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To get the last row of your table, use Range("A1"). End(xlDown). Row, provided your “A” column does not have any blank cells.
Detailed explanation-2: -To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.
Detailed explanation-3: -So, the column header “XFD” is the last column in the worksheet.
There is 1 question to complete.