USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
False
|
|
|
True
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You can hide columns in Excel by following these simple steps: Right click on the header of any column you want to hide. Select Hide.
Detailed explanation-2: -From an Entire Worksheet (Used Range) This last row number is then used in a For Next loop, where it starts from the last row and checks whether it’s hidden or not. In case it’s hidden, that entire row is deleted.
Detailed explanation-3: -Microsoft Excel provides two useful features that are hide and unhide columns. Hiding a column will make that column disappear, it is still present in the sheet but will not appear on the screen. You can unhide the hidden column anytime whenever you want.
Detailed explanation-4: -Select one or more columns, and then press Ctrl to select additional columns that aren’t adjacent. Right-click the selected columns, and then select Hide.