USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What happens when you hide a column in Microsoft Excel?
|
Formulas referencing cells in the column stop working
|
|
The data in the column in deleted
|
|
The column doesn’t appear, but the data is still there
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Nothing much. It’s not hidden from Excel, it’s only hidden from “view". The contents are still processed like any other column.
Detailed explanation-2: -Select “Visibility, ” and then select “Hide & Unhide” and “Unhide Columns” to make all missing columns visible.
Detailed explanation-3: -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.
There is 1 question to complete.