USING MICROSOFT EXCEL
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: -The Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions. Click anywhere inside the table. Go to Table Tools > Design, and select the check box for Total Row. The Total Row is inserted at the bottom of your table.
There is 1 question to complete.