FUNDAMENTALS OF COMPUTER

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?
A
Formulas referencing cells in the column stop working
B
The data in the column in deleted
C
The column doesn’t appear, but the data is still there
D
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.